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.

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

• MySQL
• SQL Server
• Oracle
• PostgreSQL
• Maria DB
• Amazon Aurora
• Pervasive SQL
• Sybase
• DB2
• Exasol
• Vertica
• SQLite
• Actian Vector
• Greenplum
• Denodo
• Progress OpenEdge
• Hive
• Firebird
• Yugabyte DB
• MS Access
• SAP HANA
• DB2-AS/400
• JDBC Driver Supported Databases