Import/Connect to Data
This section discusses the various options to import data into Zoho Analytics:
Import from Files and Feeds
Zoho Analytics 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.
Comma Separated Value (CSV) | Excel (XLS and XLSX) | HTML | JSON | XML | OData
Import from Cloud Storage/Drive
Zoho Analytics allows you to import data stored on different Cloud Drive/Storage such as Zoho Docs , Zoho WorkDrive , Google Drive , Dropbox , Box , OneDrive , and Amazon S3 , for advanced reporting and analysis.
Zoho Docs | Google Drive | Dropbox Box | Box | Microsoft OneDrive | Amazon S3
Import from Cloud Databases
Zoho Analytics allows you to import the data stored in different Cloud databases such as Amazon RDS, Amazon Redshift, Amazon Athena, Microsoft Azure, Google BigQuery, Google Cloud SQL, Snowflake, Oracle Cloud, IBM Cloud, Heroku PostgreSQL, Panoply, and so on 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.
Amazon RDS | Amazon Redshift | Amazon Athena | Microsoft SQL Azure | Google BigQuery | Google Cloud SQL | Snowflake | Oracle Cloud | IBM Cloud | Heroku PostgreSQL | Panoply | Common Cloud Services
Import from Local Databases
If you have applications that stores data in any local or 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, JDBC Driver Supported Databases , you can easily import them into Zoho Analytics.
Zoho Databridge | 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 | JDBC Driver Supported Databases
Import Data from Popular Business Applications
Zoho Analytics 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 Analytics. Each integration comes bundled with a wide range of handpicked domain specific reports that will help you jumpstart on analyzing your data.
Zoho Apps
Zoho CRM
|
Zoho SalesIQ
|
Zoho Finance
|
Zoho Desk
|
Zendesk
|
Zoho Projects
|
Zoho BugTracker
|
Zoho Survey
|
Zoho Campaigns
|
Zoho Recruit
|
Zoho People
|
Zoho Analytics for Google Suite
|
Zoho Creator
Popular Business Applications
Salesforce CRM
|
Microsoft Dynamics CRM
|
HubSpot CRM
|
QuickBooks
|
Xero
|
Stripe
|
Sage Accounting
|
Google Analytics
|
Google Ads
|
ManageEngine ServiceDesk Plus
|
ManageEngine SupportCenter Plus
|
Teamwork Desk
|
Teamwork Projects
Survey Monkey
|
SurveyGizmo
|
Mailchimp
|
YouTube Channel
l
Twitter Competitive Analytics
|
Twitter Analytics
|
Facebook Pages
|
Facebook Ads
|
Bing Ads
l
LinkedIn Ads
l
Instagram
Importing Data using Zoho Analytics API
The Zoho Analytics API Guide helps Independent Software Vendors, Developers and System Integrators to build /integrate powerful reporting and analytical capabilities into their applications using the Zoho Analytics API.
Importing Data using Zapier
Zapier is a Web Automation app that helps you connect with other complementary apps side by side. The Zoho Analytics app for Zapier enables you to connect and extract data from over 500+ other online applications.
Importing Data using Flatly
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 Analytics using Google Drive
Managing Data Sources
Zoho Analytics allows you to easily view and manage all the data sources setup in a Workspace from a single page. This enables you to keep track and manage all the sources from which the data has been imported in a Workspace.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Azure Data Lake
Zoho Analytics allows you to connect to the data stored in Data Lake. Zoho Analytics enables you to create data visualizations that help in identifying the underlying trends and optimize operational efficiency. You can also schedule imports and ...Managing Data Sources
Managing Data Sources Zoho Analytics allows you to easily view and manage all the data sources set up in a Workspace. This enables you to keep track and manage all the sources from which the data has been imported in a Workspace. This section briefs ...Analytics - Import Help
Custom Date Format When you connect to a datasource, Zoho Analytics automatically interprets the data type of the columns in the table and assigns the same accordingly. Similarly, the existence of a date column in the data that you are importing into ...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 Data Modeling
You might have a database consisting of multiple data tables related to each other. You would want to import these related tables into Zoho Analytics and create reports and dashboards combining data from these tables. When these tables are imported ...