Relational Databases

Importing Data from Local/Hosted Relational Databases

Zoho Analytics allows you to import data from wide range of relational databases like MySQL, SQL Server, Oracle, PostgreSQL, Maria DB, Amazon Aurora, Pervasive SQL, Sybase, DB2, Exasol, Vertica, Actian Vector, Greenplum, Denodo, DB2-AS/400, MS Access, SQLite, Firebird, and JDBC Driver Supported Databases that you have stores in the local intranet (behind the firewall) or the private cloud. You can also automate the import process to synchronize the data from your local /hosted database into Zoho Analytics at periodic intervals.

To provides a hassle-free import experience, Zoho Analytics provides a lightweight independent utility called Zoho Databridge. This bridges your local source and Zoho Analytics server to fetch data from your data source. Zoho Databridge needs to be installed on your premises from where it can access your local source.

Note:
  • You can also import data from your Relational database using the Upload Tool.
  • However, we strongly recommend you to use the Zoho Databridge as it allows you to import data from Zoho Analytics user interface.
  • Zoho Databridge can also be monitored and managed from the Zoho Analytics user interface.

The following sections explain how to import data from the corresponding database. 

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohoanalytics.com