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 Zoho Analytics at a periodic interval.

Setup Zoho Databridge

  1. What is Zoho Databridge?
  2. What are the system requirements to install Zoho Databridge successfully?
  3. How do I install Zoho Databridge?
  4. Can I independently download Zoho Databridge?
  5. How do I start/stop Zoho Databridge manually?
  6. Can I link multiple Zoho Databridge into my account?
  7. How do I manage all my Zoho Databridge?
  8. Why is my  Zoho Databridge Status shown as inactive?
  9. Can I modify the Proxy Settings after installation?
  10. Can I migrate from Upload Tool to Zoho Databridge?
  11. Do I have to enable any ports in my firewall settings to allow import from Zoho Databridge?

FAQ and Troubleshooting Tips 

  1. Zoho Databridge Status is Active, why am I not able to import?
  2. Databridge becomes In-active after I close the terminal in Linux / MAC. How to overcome this?
  3. Can I transfer my Zoho Databridge to another admin account?
  4. I get an error message "Error Connecting with databridge, please check your connection with your databridge" during Import. How to overcome this?
  5. I get an error message "Sorry, there is a problem in connecting to your local data source. Check your connection details and try again" How to overcome this?
  6. I have installed Databridge and started, but the Databridge is not getting listed in Manage Databridge page. How to overcome this?
  7. I get an error message "OutOfMemoryError: Java heap space" during Import. How to overcome this?
  8. Import from the cloud database fails. How to solve this? 

Zoho Databridge

1. What is Zoho Databridge? 

Zoho Databridge is a lightweight independent utility that bridges your data source and Zoho Analytics server to enable easy data import. Using this, you can import data you have stored in a local or hosted database such as MySQL, MS SQL Server, Oracle, PostgreSQL etc.,  

2. What are the system requirements to install Zoho Databridge successfully? 

To ensure a successful installation of Zoho Databridge, your system should meet the following requirements:

  • Operating System: Zoho Databridge is compatible with Windows, MacOS and Linux operating systems.
  • Disk Space: You will need a minimum of 512 MB of available disk space to accommodate the installation files and potential data storage.
  • RAM: At least 2 GB of RAM is required for the proper functioning of Zoho Databridge.
     

3. How do I install Zoho Databridge?

4. Can I independently download Zoho Databridge?

Yes, you can independently download the Databridge. Click the corresponding OS to download.

Download Zoho Databridge
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin l 64 bit bin
Mac Download
64 bit dmg
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin l 64 bit bin
Mac Download
64 bit dmg
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin l 64 bit bin
Mac Download
64 bit dmg
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin l 64 bit bin
Mac Download
64 bit dmg
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin64 bit bin
 Mac Download
64 bit dmg
Windows Download
32 bit exe l 64 bit exe
Linux Download
32 bit bin l 64 bit bin
Mac Download
64 bit dmg

5. How do I start/stop Zoho Databridge manually?

In Windows
In Windows, you can start or stop the service using the Windows Services manager.

In Mac and Linux
In Mac and Linux, you can start the Databridge by executing the StartServer.sh file available in the {installed location}/ZohoDatabridge folder using the command prompt.

Sh StartServer.sh

Note: In Mac and Linux, you need to start Zoho Databridge everytime the machine is rebooted. Whereas in the Windows the application will be automatically started by default.

6. Can I link multiple Zoho Databridge installations into my account?

Yes, you can link multiple Zoho Databridge installations into your account. Download the Zoho Databridge from the Manage Databridge tab in the Accounts Setup page. Install using the same installation key.  

All installations will be listed in the Manage Databridge tab of the Account Setup page.

Note:

  • A single Databridge can import data from various data sources available in the same network.
  • You can install only one Databridge per machine.

7. How do I manage all my Zoho Databridge?

You can monitor and manage all installation right from Zoho Analytics user interface using the Manage Databridge tab in the Account Setup page.

Follow the below steps to do so:

  1. Login to your account.
  2. Click the Setup icon at the top right corner. The Settings page will open. 
  3. Open the Manage Databridge tab. 
  4. All the Zoho Databridge linked to your account will be listed here with the following details.
    • The Zoho Databridge details such as Name and Version of each installation.  
    • The Host Name and OS of the machine where each Databridge is installed.
    • The Status of Databridge. This status shows whether the Databridge is able to connect to the Zoho Analytics server.
  5. Hover over the Databridge installation list, the contextual menu options will open. You can perform the following operations. 
    • Ping Databridge to check the connectivity status. This status shows whether the Zoho Analytics server is able to connect to the Databridge.
    • Enable or disable the Databridge.
    • Delete the Databridge. 

You can also enable, disable or delete multiple databridge together by selecting the corresponding checkboxes and then select the option at the top bar.  

8. Why is my Zoho Databridge Status shown as in-active?

The Zoho Databridge status will be shown as in-active when it is unable to connect to your server. Ensure the following to avoid this:

  • Your data source is running.
  • The server/machine where the Databridge is installed is running.

9. Can I modify the Proxy Settings after installation?

Yes, you can modify the proxy settings anytime after installation using the serveragent.config file available in the {installed location}/ZohoDatabridge/conf folder.  

Modify the Proxy Settings parameters as given below and save the file.

  • PROXY - Set this to true if you connect through a Proxy Server.
  • PROXY_HOST - Specify the Proxy hostname.
  • PROXY_PORT - Specify the Proxy port number.
  • PROXY_USERNAME - Specify the Proxy username.
  • PROXY_PASSWORD - Specify the Proxy password.

Restart the Databridge once the changes are done. 

Note: Ensure that the proxy details are configured properly. Zoho Databridge will not be able to import data if the Proxy Settings are not properly configured.

10. Can I migrate from Upload Tool to Zoho Databridge?

Yes, you can migrate from Upload Tool to Zoho Databridge. Refer to Migration from Upload Tool to Zoho Databridge document to know more.

11. Do I have to enable any ports in my firewall settings to allow import from Zoho Databridge?

After installing Zoho Databridge, enable port 443 (HTTPS protocol) in outbound connection from your Firewall Settings. 

If you find any discrepancies in enabling the port, please try enabling the below mentioned domains:

GridDomain
USanalyticsapi.zoho.com
us4-dms.zoho.com
us3-dms.zoho.com
dms.zoho.com
accounts.zoho.com
downloads.zohocdn.com
EUanalyticsapi.zoho.eu
eu1-dms.zoho.eu
eu2-dms.zoho.eu
dms.zoho.eu
accounts.zoho.eu
downloads.zohocdn.com
INanalyticsapi.zoho.in
in1-dms.zoho.in
in2-dms.zoho.in
dms.zoho.in
accounts.zoho.in
downloads.zohocdn.com
CNanalyticsapi.zoho.com.cn
cn2-dms.zoho.com.cn
cn3-dms.zoho.com.cn
dms.zoho.com.cn
accounts.zoho.com.cn
app-downloads.zohodl.com.cn
JP

jp1-dms.zoho.jp
jp2-dms.zoho.jp
accounts.zoho.jp
analyticsapi.zoho.jp
downloads.zohocdn.com

 

AUanalyticsapi.zoho.com.au
au1-dms.zoho.com.au
au2-dms.zoho.com.au
dms.zoho.com.au
accounts.zoho.com.au
downloads.zohocdn.com
CAanalyticsapi.zohocloud.ca
ca1-dms.zohocloud.ca
ca2-dms.zohocloud.ca
accounts.zohocloud.ca
downloads.zohocdn.com
SAanalyticsapi.zoho.sa
sa1-dms.zoho.sa
sa2-dms.zoho.sa
accounts.zoho.sa
downloads.zohocdn.com

FAQ and Troubleshooting Tips 

1. Zoho Databridge Status is Active, why am I not able to import?

This happens when the Zoho Databridge is active, but the Zoho Analytics server is unable to connect with the Databridge. 

You can check the connectivity status by clicking Ping icon that appears on mouse over.

The status will be displayed as in the below screen. 

In case the connectivity is poor, status is shown as failed. Try connecting after sometime.

2. Databridge becomes In-active after I close the terminal in Linux / MAC. How to overcome this?

You can overcome this by using nohup in Linux and MAC to start Databridge as shown below. This prevents Databridge from getting killed after closing the terminal.

nohup sh StartServer.sh

3. Can I transfer my Zoho Databridge to another admin account?

No, you cannot transfer the Zoho Databridge to another admin account. You will have to uninstall the existing Zoho Databridge and the new account admin will have to install it again in their machine.

All the local databases connected to the account need to be associated with the new Zoho Databridge. To do this, 

  1. From the relevant workspaces, click the Data Sources button from the side menu bar.
  2. On the Data Sources page, click the Edit Connection link.
  3. Change the databridge name from the Databridge drop-down.
  4. Click Save.

4. I get an error message "Error Connecting with databridge, please check your connection with your databridge." How to overcome this?

There might be a connectivity problem in reaching the Databridge. Restart the Databridge and try connecting your data source.

5. I get an error message "Sorry, there is a problem in connecting to your local data source. Check your connection details and try again." How to overcome this?

This error occurs when Zoho Analytics server is not able to connect with your data source. Ensure the following to avoid this error.

  • The connection details you have specified in the Import wizard are proper. 
  • Your data source is running.
  • The server where the Databridge is running has the privilege (or whitelisted) to connect to the data source hosted in the private cloud.

6. I have installed Databridge and started. But, the Databridge is not getting listed in the Manage Databridge page. How to overcome this?

Check whether the server where the Databridge is running is able to reach *.zoho.com domain. Once the network connectivity issue is resolved, restart the Databridge.

7. I get an error message "OutOfMemoryError: Java heap space" message during Import. How to overcome this?

This error occurs when the size of the data you are importing exceeds the default heap memory set to run the program. To overcome this, change the heap memory of Databridge. 

Windows
For Windows, you can change this in the wrapper.conf file available in the {installed location}/ZohoDatabridge/conf folder as given below. 

Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=1024

Mac and Linux
For Mac and Linux,  you can change this in the heapMemory.conf​ file available in the {installed location}/ZohoDatabridge folder as given below. 

HEAPMEMORY=1024

Restart the Databridge once the heap memory is modified. 

8. Import from the cloud database fails. How to solve this? 

Import from the cloud database may fail when the Databridge does not have the privilege to access the data. In case the security system of your cloud database only allows access from restricted IP Addresses, then it will blacklist the server/machine where the Databridge is installed. Ensure that you have whitelisted the IP Address of the server/machine where the Databridge is installed.