Zoho Reports Upload Tool - Introduction
|Users are requested to download the latest version of the Upload Tool released on or after 17th June 2013. Support for older version will be removed soon.
Zoho Reports Upload Tool is a downloadable standalone utility, that enables you to upload data from your local databases such as MS Access, Microsoft SQL Server, Oracle, MySQL, Sybase, PostgreSQL SQLite, DB2, DB2 AS/400, Firebird, SQL Azure and other applications behind firewall into Zoho Reports. The tool can be used in two ways. They are:
Upload Data from CSV Files
You can bulk upload data in a CSV file format into Zoho Reports using this tool. It is especially useful when you need to upload more than 500,000 rows or whose file size is greater than 50 MB (these import size limits are applicable when you use the Zoho Reports web user interface). This tool splits the data in the CSV file into batches and uploads it to Zoho Reports, making it much more resilient to intermittent Internet connectivity outages or slow connections. It can be invoked in GUI and Console (command line) modes.
Upload Data Directly from Databases behind Firewalls and Cloud Databases
You can pull data from application databases behind firewall and cloud database to upload the same into Zoho Reports. The tool directly accesses your database, queries for the required data and uploads it to Zoho Reports. Currently supported databases are MS Access, MS Access 2010, MySQL, Microsoft SQL Server, Sybase, PostgreSQL, Oracle, SQLite, DB2, DB2-AS/400, Firebird and SQL Azure (Cloud Database).
You can use the tool in either of the above said ways to suit your requirement. You can also setup the tool for periodic automatic execution, so that you could keep the data synchronized with Zoho Reports.
The following screenshot illustrates how the Upload Tool functions.
In the subsequent sections of this topic, we will discuss in detail about how to use the Upload tool in various modes to upload/synchronize your data with Zoho Reports.
Next: Download and Setup