Import/Upload Data into Zoho Reports
Zoho Reports provides various options to import the data that you have in local files, Web URLs, Cloud drives (Google Spreadsheets, Google Docs etc), Local/Cloud databases, popular business applications and from your custom applications into Zoho Reports reporting databases for your in-depth analysis & reporting.
This section discusses the various options to import data into Zoho Reports:
Zoho Reports allows you to import data stored in tabular file formats like CSV, XLS (Excel), JSON, OData, and HTML files in your system or as a web feed.
Zoho Reports allows you to import data stored on different Cloud Drive/Storage such as Zoho Docs, Google Drive, Dropbox, Box and OneDrive, for advanced reporting and analysis.
Zoho Reports allows you to import the data stored in different Cloud databases such as Amazon RDS, Amazon Redshift, Microsoft SQL Azure, Google Cloud SQL, Heroku etc for advanced reporting & analysis. You can easily setup data import from these cloud databases using the simple setup wizard.
Shown below is the import presentation for Amazon RDS. You can access the individual setup presentations for each of the Cloud Database from the respective links given below.
If you have applications that stores data in any local or relational databases like MS Access, MySQL, SQL Server, Sybase, PostgreSQL, Oracle, SQLite, DB2, DB2 AS/400, SQLite, FireBird etc you can easily import them into Zoho Reports.
Zoho Reports enables you to analyze data from 25+ popular business applications. You can easily connect to these applications and make use of the advanced reporting and analytical capabilities of Zoho Reports. Each integration comes bundled with a wide range of handpicked domain specific reports that will help you jumpstart on analyzing your data.
Popular Business Applications
The Zoho Reports API Guide helps Independent Software Vendors, Developers and System Integrators to build /integrate powerful reporting and analytical capabilities into their applications using the Zoho Reports API.
Zapier is a Web Automation app that helps you connect with other complementary apps side by side. The Zoho Reports app for Zapier enables you to connect and extract data from over 500+ other online applications.
Flatly is a web automation app that allows you to seamlessly integrate data from popular CRM services such as Insightly CRM, Pipedrive and Base CRM into Zoho Reports using Google Drive