Import data using Zoho Databridge

Databridge in Zoho DataPrep

Zoho Databridge is a lightweight independent utility that connects your on-premise data source and Zoho applications to import data. In other words, you can quickly and securely transfer local files and local databases from your internal network to Zoho applications. 


With Zoho DataPrep, you can use Zoho Databridge to allow the import of data from local databases such as MySQL, MS SQL Server, Oracle, and PostgreSQL in your local network and you can also incrementally import data from FTP servers and local files using Zoho Databridge.

Zoho Databridge solely transfers data from your local network to Zoho DataPrep. It does not retrieve data back to your local network, ensuring no security breach.


Before using Databridges to import and export data from DataPrep, you will need to download and install Databridge on your machine. To learn how to download and install Databridge, click here

1. If you have just installed Databridge on your machine, select Continue to import in the Download Zoho Databridge dialog box. 



2. Select your Databridge from the Databridge dropdown. 
Note: Please ensure the JDBC jar file required for database is placed at "~Zoho Databridge 2.0/lib/jars/<.jar>" folder.

3. After selecting your Databridge, choose the type of your database. 

4. Continue with the steps to import from local databases, FTP servers, or files from your local network. 



5. You can Manage Databridges from the settings page in DataPrep. 

SEE ALSO

    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









                                            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

                                                                                                              • Zoho Databridge Silent Installation

                                                                                                                Performing silent installation allows you to install Zoho Databridge on a Linux machine from the command line. This is especially handy for retrieving data from systems that do not have a graphical user interface. Steps to perform silent installation ...
                                                                                                              • Import data from Zoho CRM

                                                                                                                Zoho DataPrep allows you to seamlessly bring in your sales data from Zoho CRM using the Zoho CRM connector. Using the connector, you can import your sales data from CRM to perform data cleanup, data migration, and data backup in more than one way. To ...
                                                                                                              • Import data from Zoho Creator

                                                                                                                Zoho DataPrep allows you to seamlessly bring in your forms data from Zoho Creator using the Zoho Creator connector. Zoho Creator is a powerful low-code application development platform that helps businesses build custom web and mobile apps faster. To ...
                                                                                                              • Import data from local databases

                                                                                                                You can import data from the following local databases into DataPrep using Zoho Databridge: MySQL MS SQL Server Oracle PostgreSQL Maria DB Pervasive SQL Sybase DB2 Exasol Sqlite Actian Vector Greenplum Denodo Progress OpenEdge YugabyteDB Microsoft ...
                                                                                                              • Import data from FTP servers

                                                                                                                You can import files from FTP servers using the following steps. To import data using an FTP connection 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You can also ...
                                                                                                                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