Zoho Reports provides you with an utilitarian ‘Upload Tool’. This is an easy-to-install desktop utility that can be configured for periodic upload of data. This tool lets you upload data from both in-house databases located behind the firewall, and from hosted databases on the web.
The upload tool is simple, easy to install, and configure. It works behind firewalls, on Windows, Mac and Linux operating systems.
Wide range of databases (in-house & cloud)
It connects to a wide range of databases. Databases supported include Oracle, SQL Server, MySQL, PostgreSQL, Access, Teradata, Amazon RDS, SQL Azure, etc.
It also supports batch uploading of data from flat text files. This is especially useful for applications that generate huge data in CSV file format.
Periodic upload and synchronization
The tool helps you upload data periodically. You can achieve near real-time reporting and analysis, as data gets uploaded and synchronized from your databases and applications.
Zoho Reports offers a HTTP based web API (REST API). This platform neutral API enables you to integrate real-time changes of data from your applications or databases, into Zoho Reports.
API for every action
Zoho Reports provides you with a comprehensive API for every action. There is the Data API for actions such as insert/update of data, the Modeling API for actions like add/delete/rename columns and tables, the Metadata API for fetching information about the reports & dashboards, and many more.
Purely HTTP based
Our REST API provides request-responses in standard XML or JSON format, making it programming language neutral. Convenient wrappers are available in popular languages like Java, C#, Python, PHP, GO etc., for easy development.
Been playing with Zoho Reports today - give it a few CSV files, set up some relationships, and BOOM! Reporting, sorted.. pretty cool.