Importing Data from Local Databases
Zoho Analytics allows you to imports data from local or hosted databases such as MySQL, MS SQL Server, Oracle, PostgreSQL etc., that you have stored in a local network or in private cloud behind the firewall. You can connect and import data from Relational and NoSQL databases into Zoho Analytics.
You can upload data from any of the following data source.
1. Upload Data from Relational Databases
You can pull data from a relational database and import the same into Zoho Analytics. You can connect to the databases like MS Access, MS Access 2010, MySQL, Microsoft SQL Server, Sybase, PostgreSQL, Oracle, SQLite, DB2, DB2-AS/400, Firebird or any JDBC driver supported database.
2. Upload Data from NoSQL Databases
You can pull data from NoSQL databases and import the same into Zoho Analytics. You can connect to the databases like MongoDB, Cassandra, Apache Hadoop Hive, Cloudera Hadoop and Hortonworks Hadoop.
3. Upload Data from Large CSV Files
You can bulk import data in a CSV file format into Zoho Analytics. It is especially useful when you need to upload more than 1,000,000 rows or whose file size is greater than 100 MB (this size limitation is applicable when you use the import from files and feeds option).
In the subsequent sections, we will discuss in detail about how to import data from various sources into Zoho Analytics.