Migrating from Upload Tool to Zoho Databridge | Zoho Analytics Help

Migrating from Upload Tool to Zoho Databridge

Zoho Databridge is an enhanced utility by Zoho Analytics that enables you to import data from on-premise databases and local files into Zoho Analytics. If you are currently using the Upload Tool, we strongly recommend you to try the Zoho Databridge. This section provides you a guide on how to migrate from Upload Tool to Zoho Databridge.

General

1. What is Zoho Databridge?

Zoho Databridge is a lightweight independent utility that bridges your on-premise data sources and Zoho Analytics service. With Databridge you can easily automate the import process from your local databases and privately hosted databases into Zoho Analytics right from the Zoho Analytics user interface. You can also easily manage and monitor the import process. 

For more information on Zoho Databridge, go through the Zoho Databridge documentation.

2. Why should I migrate from Upload Tool to Zoho Databridge?

In Zoho Databridge, you can upload, configure, and manage the data import from the Zoho Analytics interface. Whereas in Upload Tool it is done in the terminal/command line interface.

With Zoho Databridge, you can also monitor all your upload processes right from your Zoho Analytics user interface and also get notified on failures through emails. 

To sum it up, managing the data import using Zoho Databridge is a very straightforward and user-friendly process with a minimal requirement of technical expertise.

3. What are the pre-checks to be done before migrating to Zoho Databridge?

  • You must have the Zoho Databridge downloaded and installed in the same network as that of Upload Tool. Refer to the Zoho Databridge documentation to know how to install Zoho Databridge.
  • You must ensure the data source of your Upload Tool is one of the following: 
    • MySQL
    • Oracle
    • SQL Server
    • Sybase
    • PostgreSQL
    • Maria DB
    • Amazon Aurora MySQL
Note: As of now, the Upload Tool has been used to upload data from the rest of the data sources (not listed above). The support for other data sources in Zoho Databridge will be provided in due course.

4. How to migrate from Upload Tool to Zoho Databridge?

You can easily migrate from Upload Tool to Zoho Databridge executing the migration tool as described below. 

Before migrating, ensure that the corresponding data source of the Upload Tool is supported by Zoho Databridge and the Zoho Databridge is installed in the same network as that of Upload Tool. Refer to the list of data sources that can be migrated section.

Follow the below steps to migrate from Upload Tool to Zoho Databridge:

  1. Download the Migration Tool given below appropriate to your OS:
Download Migration Tool
 Windows Download  Linux Download  Mac Download
  1. Unzip the MigrateToDatabridge zip file and place the files available in the bin and lib folder of the MigrateToDatabridge folder into the bin and the lib folders of your existing Upload Tool respectively.
  2. Invoke the below script from the Upload Tool/bin folder by executing it in the command line/terminal:
Windows OS: MigrateDBToDatabridge.bat
Mac/Linux OS: sh MigrateDBToDatabridge.sh
  1. The script will do all the pre-checks for the migration. Incase, you have multiple databridges, you will be prompted to select a Zoho Databridge after executing the Migration Tool. You can choose a Zoho Databridge by entering the index of the Zoho Databridge displayed in the terminal.
  2. Specify a schedule interval at which Databridge should execute the data import process from your local/hosted databases to Zoho Analytics.  

You can choose a schedule interval from the listed options by entering a number from 1 to 4, which is described below:

  • 1 - DO NOT Schedule
  • 2 - Schedule DAILY at 12 AM in your timezone
  • 3 - Schedule WEEKLY on every Sunday at 12 AM in your timezone
  • 4 - Schedule MONTHLY on the 1st day of every month at 12 AM in your timezone
Note: Only limited schedule options are available here for easy migration purposes. However, you can change this schedule interval as required from the Zoho Analytics interface. Refer to  Scheduling Import section for more information.
  1. The Upload Tool will be migrated to the Zoho Databridge and a success message will be displayed. 

The synchronization will begin from the next sync schedule.

Note:
  • Upload Tool used to sync data from Large CSV files cannot be migrated to Zoho Databridge.
  • If you have multiple instances of Upload Tool, you can migrate them one-by-one to Zoho Databridge following the steps described above. 
  • On successful migration, refer to the below question, please stop the execution of the Upload Tool.

5. How to verify whether the settings from the Upload Tool are successfully migrated to Zoho Databridge?

On completion of all the steps mentioned in the above question, the Upload Tool configurations will be migrated, and a success message will be displayed. Your data will get synchronized from the next sync schedule. 

You can verify whether your data is properly imported by following the below steps: 

  1. Open the corresponding Workspace in Zoho Analytics.
  2. Click the Data Sources tab. 
  3. From the list of available data sources, select the Data Source for which you want to make the modifications. 

The Data Sources page that opens will list the following details:

  • Sync status summary details such as:
    • Databridge Name: Name of the Zoho Databridge
    • Databridge Status: Status of the Zoho Databridge
    • Source Database Name: Name of the database imported
    • Last Data Sync Status: Status of the last synchronization, with the possible status being Success, Failure, In Progress, and Partial Success
    • Last Data Sync Time: Time of the last synchronization
  • Schedule information such as:
    • Schedule: Interval in which the import is scheduled 
    • Next Schedule Time: Time of the next schedule 
    • Synchronizations Done: Number of instant syncs done in the day 
  • Table details: Details of the individual tables will be displayed, which includes, the Table Name, Source Table Name, Last Fetched Time, and Sync Status.

From the above details you can verify that the Zoho Databridge is successfully running after migration.

Note:
  • You can instantly sync the data from here by clicking the Sync Now link if required. 
  • You can always Edit Connection details and Sync Settings as and when required. Refer to Import from Database using Zoho Databridge document to know more.

6. How do I manage all my databridges?

You can monitor and manage all installation right from Zoho Analytics user interface using the Manage Databridge tab in the Account Setup page. To know more about the same, refer Zoho Databridge document.

FAQ and Troubleshooting Tips 

1. Is it necessary to install the Zoho Databridge in the same network as that of the Upload Tool?

Yes, it is manditory to install Zoho Databridge in the same network as that of the Upload Tool.

2. I am having the Upload Tool setup in Windows OS. Can I migrate it to Zoho Databridge setup in Mac/Linux OS?

Yes, you can migrate the Upload Tool setup in one OS (say Windows) to the Zoho Databridge setup in another OS (say Mac/Linux OS), as along as they are setup in the same network. There are no constraints regarding the same.

3. Do I need to retain the Upload Tool after migrating?

No, you can delete the Upload Tool after the migration is successfully complete. 

4. I get an error message "{Database Type} not supported in Databridge" while migrating. How to overcome this?

This error occurs when the data source of the Upload Tool you are migrating is not supported by Zoho Databridge. Ensure that your data source is in the supported by Zoho Databridge list, before migrating.

5. I get an error message "No such file or directory" while migrating. How to overcome this? 

This error occurs when the Migration Tool files are not placed in appropriate location. Ensure to place the files available in the bin and lib folder of the MigrateToDatabridge folder into the bin and the lib folders of your existing Upload Tool respectively.

6. I get an error message "Connection already exists with another Databridge. Please check Workspace -> Data Source page " while migrating. How to overcome this?

This error occurs when the Upload Tool is already migrated into another Zoho Databridge. You can verify the Zoho Databridge that you have migrated to from the corresponding Workspace by following the below steps.

  1. Log in to your Zoho Analytics.
  2. Open the corresponding Workspace.
  3. Click the Data Sources tab. 
  4. From the list of available data sources, select the Data Source for which you want to make the modifications.
  5. The details of the selected Data Source appear. Refer successful migration section for more information regarding the same.
Note: You cannot migrate the same Upload Tool to two different databridges.

7. I get an error message "Workspace "{Name}" is not found in the given account, Please check credentials and try again" while migrating. How to overcome this?

This error occurs when the Workspace mentioned in the Upload Tool is not found in Zoho Analytics. Always ensure that there is no mismatch between the Workspace name mentioned in the Upload Tool and the one available in the Zoho Analytics.

8. I get an error message "Table "{Name}" is not present in Workspace {Name}, Please check credentials and try again" while migrating. How to overcome this?

This error occurs when the Table mentioned in the Upload Tool is not found in Zoho Analytics. Always ensure that there is no mismatch between the Table name mentioned in the Upload Tool and the one available in the Zoho Analytics.


    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION





                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Migrate from older version of Upload Tool

                                                                                                                1. Why should I migrate from older versions of the Upload Tool? As part of our continuous endeavor to make Zoho services more secure, we are phasing out support for TLS versions 1.0 and 1.1. The older versions of the Upload Tool uses these TLS ...
                                                                                                              • Zoho Databridge

                                                                                                                Zoho Databridge is a lightweight independent utility that bridges your on-premise data source and Zoho Analytics server to enable easy data import. You can also automate the import process to synchronize the data from your local /hosted database into ...
                                                                                                              • Importing from PostgreSQL using Zoho Databridge

                                                                                                                If you have data in a local /hosted PostgreSQL database, then you can easily import your data into Zoho Analytics using the Zoho Databridge. The Zoho Databridge bridges your local PostgreSQL database and Zoho Analytics server to fetch data from your ...
                                                                                                              • Importing from Oracle using Zoho Databridge

                                                                                                                If you have data in a local /hosted Oracle database, then you can easily import your data into Zoho Analytics using the Zoho Databridge. The Zoho Databridge bridges your local Oracle database and Zoho Analytics server to fetch data from your local ...
                                                                                                              • Importing from Sybase using Zoho Databridge

                                                                                                                If you have data in a local /hosted Sybase database, then you can easily import your data into Zoho Analytics using the Zoho Databridge. The Zoho Databridge bridges your local Sybase database and Zoho Analytics server to fetch data from your local ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources