Zoho Analytics connector for Zoho DataPrep
DataPrep supports importing data from Zoho Analytics using the Zoho Analytics connector. Zoho Analytics is a self-service BI and data analytics software that lets you visually analyze your data, create stunning data visualizations and discover hidden insights from your data.
To import data from Zoho Analytics
1. Click
Zoho Analytics
from the
Choose a data source
box.
2. Choose your organization from the
Choose organization
dropdown and select one of the available workspaces from the
Choose workspace
dropdown.
3.
Choose tables to import into DataPrep by selecting the check boxes. All the tables including query tables which are present in the workspace will be displayed by default. You can filter tables and query tables using the filter
menu besides the search icon.
Query table is a feature in Zoho Analytics that enables you to prepare data for easy reporting and analysis. You can combine data from one or more tables in a database to facilitate easy reporting.
Click here
to know more about Query tables.
4. Click the
Import
button.
5. Once you have completed importing data, you can choose to schedule this import, or start preparing your data right away.
6. After preparing your data, you can export your data from Zoho DataPrep to Zoho Analytics using the Zoho Analytics connector.
To export data to Zoho Analytics
1. Click the
Export now
option from the
Export
menu in the
DataPrep
Studio
page.
2. Select
Zoho Analytics
in the side pane.
3. You can choose to include columns containing personal data by selecting the
Include columns with personal data
checkbox.
4. Choose the
Organization
and
Workspace
to which you want to export your dataset.
5. Click
Export
.
6. You may choose to run the export in the background by clicking the
Run in background
button.
7. You will be notified if the export is in-progress and when the export is completed via notification in the notification panel.
8. Once the export is complete you can choose to schedule the export by clicking the
Configure schedule
link.
Note:
1. The rows whose values match their respective data types will be exported.
2. Rows with data type mismatch are not exported and error details will be notified through mail and in the notification panel.
3. Datasets containing invalid data cannot be exported to analytics. Please make sure the dataset does not contain invalid values before
scheduling export
to Zoho Analytics.
SEE ALSO
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:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Zoho Creator connector for Zoho DataPrep
Zoho DataPrep allows you to seamlessly bring in your forms from Zoho Creator using the Zoho Creator connector. Using the connector, you can import your forms from Creator to perform data cleanup, data migration, data sync and data backup in more than ...Importing data from Zoho Analytics
DataPrep supports importing data from Zoho Analytics . Zoho Analytics is a self-service BI and data analytics software that lets you visually analyze your data, create stunning data visualizations and discover hidden insights from your data. You can ...Ruleset in Zoho DataPrep
This page covers the following sections: What is a Ruleset? Data source settings Ruleset operations Options with individual rules Ruleset Templates What is a Ruleset? Each transform applied on the dataset is stored in DataPrep as a rule, in order of ...Zoho DataPrep's Home page
The home page gives you a brief overview of the workspaces you own, where they are located, and the workspaces that are shared with you. From Zoho DataPrep's home page, you can manage your Zoho DataPrep account, create and manage workspaces. The ...Zoho DataPrep - FAQ
1. What is Zoho DataPrep? Zoho DataPrep is an advanced self-service data preparation tool that helps organizations model, cleanse, prepare, enrich and organize large volumes of data from multiple data sources to serve data analytics and data ...
New to Zoho LandingPage?
Zoho LandingPage Resources