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.
Follow the steps below to install Databridge on your local machine.
Linux
RAM - 3GB
Disk space - 3GB min
Processor type - 32bit, 64bit
Processing speed - 64 bit and 32 bit
Versions tested - Ubuntu 22.04.2 LTS
Package distribution - .bin file contains JRE, JavaFX runtime, JARs, lib, config files
1. Click Databases or click Files or FTP from the Choose a Datasource box and enable the Import from local network toggle. If you don't have any Databridge previously installed, you will be shown an intro to Databridges.
2. Click the Download button to redirect to the Download Zoho Databridge page.
Download the Linux installer based on the OS of your machine in which Databridge should be installed.
US, IN, JP, EU, AU, CA, SA DCs:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
CN DC:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
2. Download the Linux installer based on the OS of your machine in which the Databridge should be installed.
US, IN, JP, EU, AU, CA, SA DCs:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
CN DC:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
Notes:
1. Install Databridge on a computer that is always ON and connected to the internet. A wired network is preferred so that the data transfer is faster and more reliable.
2. Ensure the JDBC jar file required for database is placed at "~Zoho Databridge 2.0/lib/jars/<.jar>" folder.
1. Click one of the below links to download the Databridge installer for Linux system.
US, IN, JP, EU, AU, CA, SA DCs:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
CN DC:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
2. Move the downloaded file to a folder in your preferred location.
4. Run the databridge*.bin for Linux to start the installation wizard using the below command.
5. The Zoho Databridge Setup will be opened. Click Next to start installing Zoho Databridge.
6. Read and accept the License Agreement terms and click Next.
7. You can install Databridge in the default folder or choose the folder where you wish to install the application and click Next.
8. To use a proxy server select the Use Proxy Server checkbox and click Next.
9. Enter the Proxy Server hostname, Proxy server port, Username, Password, and click Next.
10. Review the configuration in the Pre-Installation Summary and click Install to proceed.
11. Once the installation is complete, you can start Zoho Databridge. Click Done to complete and exit the setup.
12. Log into Zoho Accounts with the username and password for your account with Zoho.
13. Click Accept.
14. Select one of your existing Organisation portals from the Select portal dropdown.
15. Give a name to your Databridge under Databridge name and click Setup.
16. The setup is complete and the Databridge is ready to be used. Please make sure the Auto start Databridge on system reboot box is checked. Click Done.
17. The Overview section shows details such as the Databridge name, status, uptime, and last started time.
18. Zoho Databridge installation is now completed and is registered to your Zoho account.
19. You can manage the linked databridges under Databridges in the Settings page.
Note: You can also verify this by viewing the Databridge dropdown in the import options or under the Databridge section in the Settings page.
If your databridge doesn't start automatically then enter the below commands to restart your databridge.
2) Enter the below command from Databridge installed location in the terminal to stop the databridge in Linux.
US, IN, JP, EU, AU DCs:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
CN DC:
Databridge installer for Linux - 64 bit
Databridge installer for Linux - 32 bit
If you have installed Zoho Databridge earlier on the same machine, make sure to uninstall it completely and delete the existing version. You can then proceed with installing the newly downloaded Databridge package.
To uninstall Databridge, you can simply close Databridge and delete the Zoho Databridge2.0 folder in your machine.
No, there is a separate application for Zoho DataPrep. Please use Zoho Databridge 2.0 for DataPrep.
You can restart Databridge, if your Databridge is inactive.
1) Close the Zoho Databridge.
If your Databridge doesn't restart automatically,
Yes, you can install Zoho Analytics Databridge along with Zoho DataPrep Databridge in your system.
Yes, you can run both Zoho Analytics and DataPrep databridges simultaneously.
No, you can have only one Databridge installed in your machine for your DataPrep organization. But you can have multiple databridges for one organization in different machines.
Click Databridges under the Settings page. Click the delete icon to permanently remove the databridge from your organization. Also delete the Zoho Databridge2.0 folder from your machine.
We try to throw appropriate errors in the UI to let the users know about the kind of error. But to debug connectivity related problems, we rely on the logs that are available in the Databridge installation folder. This helps us understand what kind of issue is stopping us from successfully connecting with your database. However, this might not make sense to an end user.
If there is an unknown error, the best way to move forward is to reach us at support@zohodataprep.com along with the logs present in "~/ZohoDatabridge2.0/logs"
One of the other ways to simplify testing is to use a database client tool in the same machine as the Databridge and try to connect to the database. This could let you know whether the problem is with connectivity to your database, or with the Databridge.
~/ZohoDatabridge2.0/conf/ - serveragent.config file
Please find the screenshots below for reference.
MacOS
Windows OS
Linux OS
SEE ALSO
How to perform silent installation?
What is Databridge and how to import data using Databridge in Windows?
What is Databridge and how to import data using Databridge in Mac?
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.