Integration with Zoho Creator
Analytics Plus seamlessly integrates with Zoho Creator, and enables you to easily slice and dice your Zoho Creator data and create insightful reports and dashboards.
- How do I integrate Analytics Plus with Zoho Creator?
- How long should I wait for my Zoho Creator data to initially appear in Analytics Plus?
- What should I do when the data synchronization fails?
- How frequently can I synchronize my data?
- Can I edit the synchronization settings?
- Can I synchronize my Zoho Creator data instantly?
- Will the data from my Zoho Creator's forms and subforms be related?
- How do I create custom reports over my Zoho Creator data?
- Can I set up the Zoho Creator integration in existing workspaces of Analytics Plus?
- How do I remove this setup?
- What are the report types supported by Analytics Plus?
- Can I modify the pre-built reports created on integrating with Zoho Creator?
- How do I create reports using fields/columns across different forms?
- What are formulas in reports?
- Is it possible to create custom formulas in Analytics Plus?
- Can I modify the tables imported from Zoho Creator?
- Can I add new columns to the tables imported from Zoho Creator?
- Can I import new tables into the Zoho Creator workspace?
- Can I combine data from other sources with data from Zoho Creator, and create reports and dashboards?
- What are Query Tables?
Sharing & Collaboration
- How do I share reports, dashboards, and tables in Analytics Plus?
- Why are my colleagues unable to access the reports I create?
- Can other users create reports using the tables in the Zoho Creator workspace?
- Is it possible to share the same report with multiple users such that they each see different data?
- Can I export a report or a dashboard?
- How do I print the reports and dashboards created in Analytics Plus?
- Can I email reports and dashboards at scheduled times?
- Can I embed reports?
Help & Support
- How do I get technical support on Analytics Plus?
- Can I have get a personalized demo of this integration?
ManageEngine Analytics Plus is an on-premises reporting and business intelligence application that helps you analyze your IT data and create insightful reports & dashboards for informed decision-making. It offers the following important capabilities:
Displays data in an easy-to-view excel format.
Build custom reports and dashboards easily, with the drag-and-drop report builder.
Generate reports and KPIs in seconds with Zia, Analytics Plus' intelligent analytics assistant powered by Machine Learning and Artificial Intelligence.
Create custom formulas using the built in formula engine that contains a wide range of mathematical, statistical and logical functions.
Share reports and dashboards with your colleagues easily, through a wide range of collaboration features.
Supports out-of-the-box integrations with a wide number of applications, to give you pre-built reports and dashboards on your application's data within minutes.
ManageEngine Analytics Plus offers out-of-the-box analytics for your Zoho Creator applications' data. You can import data from both pre-built and custom Zoho Creator applications into Analytics Plus easily, for advanced reporting and analysis.
Benefits of Analytics Plus over the inbuilt reporting module in Zoho Creator:
|Reporting Module in Zoho Creator||ManageEngine Analytics Plus|
|Users can create only tabular, grid, summary and pivot reports. Chart reports are limited to some of the application data.||It offers over 25+ chart types along with pivot, summary and tabular views for all the synchronized application data.|
|Does not support creation of dashboards.||Users can create dashboards to view all the reports in a single page layout.|
|Cannot create KPI Widgets.||Allows creation of KPI widgets to track and monitor the key performance metrics. Supports 6 types of single number widgets and 2 types of chart type widgets.|
|Cannot combine and analyze data from different sources.||Can combine data from any resources for advanced reporting and analysis.|
|Does not allow the users to email the reports.||Users can not only email reports to users but also schedule the emails.|
|Does not allow the users to embed the reports that they create.||Users can embed the reports that they create in a website or blog.|
|Does not offer formula engine.||Offers a powerful formula engine.|
|Limited customizations.||Offers a wide range of customizations.|
To integrate Analytics Plus with Zoho Creator Cloud, follow the steps detailed in the below presentation.
To integrate Analytics Plus with Zoho Creator On-Premise, follow the steps detailed in the below presentation.
After setting up the integration, you might have to wait sometime for the initial fetch to complete. Depending on the amount of data in your application, the reports and dashboards might take up to 5 minutes to display all the metrics. If you access the workspace before the initial fetch, it will not display any data.
The import or synchronization process of your Zoho Creator data can sometimes fail, due to a variety of reasons. Follow the below steps to resolve this:
Click the Data Sources button from the side panel. This opens the Data Sources summary page which lists all the configured data sources in the workspace.
Navigate to the Zoho Creator data source, and click the Re-Authenticate link.
In the popup that appears, click Authenticate Zoho Creator Business.
You will be able to synchronize your data in the intervals mentioned below.
Daily: This option allows you to synchronize data every day at the specified time.
Hourly: This option allows you to synchronize data every 3, 6, or 12 hours.
To edit the connection and synchronization settings, follow the steps below:
Click the Data Sources option from the side panel. This opens the Data Sources summary page which lists the data sources configured in the workspace.
Navigate to the Zoho Creator data source, and click the Edit Setup link.
In the Edit Setup - Zoho Creator dialog, make the necessary changes and click Save.
You can also edit the setup from the Data Sources summary page.
Click the Settings icon that appears on mouse over on the Zoho Creator data source and click the Edit Setup option.
In the Edit Setup - Zoho Creator dialog, make the necessary changes and click Save.
Yes. To do this, click the Data Sources option from the side panel. In the page that appears, navigate to the Zoho Creator source and click the corresponding Sync Now button.
You can also access the Zoho Creator data source page, and click Sync Now.
Yes. The data from your forms and subforms will be stored in Analytics Plus as tables, and a lookup relationship will be created between relevant tables automatically.
You can easily create custom reports in the form of charts, pivot tables, summary and tabular views in Analytics Plus. Click the corresponding links to learn more about creating reports. These reports can also be organized together to form intuitive dashboards. Refer this documentation to learn more about creating dashboards.
Yes. Follow the steps below to do this.
Open the required workspace, click the Create button from the side panel, and select the New Table / Import Data option.
Select the Zoho Creator tile from the Import Your Data screen that appears, and follow the setup procedure.
Open the required workspace, and click the Data Sources option from the side panel.
Click the Settings icon that appears on mouse over the data source's name, and select Remove Data Source.
Analytics Plus supports a wide variety of reports, in the form of charts, pivot tables, summary views, and tabular views. To learn more about the various types of reports click here. To know more about dashboards and KPI widgets, click here.
Yes. If you are the Server Administrator, or a workspace administrator of the workspace in which the integration is set up, click the Edit Design button in a report's toolbar and make the required changes. If you are a user with whom a report is shared, save a copy of the report by clicking the More Options icon > Save As, and modify the copied version as needed.
If the specific forms are related in Zoho Creator, , a lookup relationship will automatically be created between the two corresponding tables in Analytics Plus. You can then easily create the required report by dragging and dropping the required columns.
Formulas are calculations that can be defined using the powerful formula engine to create required reports. Refer this documentation to know more.
Yes. Refer this documentation to learn more.
No, you cannot add/modify data in the Zoho Creator data tables. The Zoho Creator's application data is synchronized with Analytics Plus automatically, and stored in the form of various tables (one table for one form). Therefore, it is not possible to add data or modify the existing data present in these tables.
However, you can add new tables, add/import data into them, and combine the data with Zoho Creator data to create reports.
No. However, you can add Formula Columns and Aggregate Formulas to these tables, to create custom reports. Refer this documentation to know more.
Yes. To do this, open the Zoho Creator workspace, click Create from the side panel and select the New Table / Import Data option. You can integrate with other applications, or choose to import data stored in local files, web URLs, local databases, cloud databases and cloud drives. Click the corresponding links to know more.
9. Can I combine data from other sources with the data from Zoho Creator, and create reports and dashboards?
Yes. To do this, import or add a new table to the Zoho Creator workspace and define a lookup relationship between the added data and the existing data in the workspace. To define a lookup relationship between two tables, it is essential that the tables have at least one column in common between them. Follow the below steps to establish a lookup relationship.
Open the corresponding table, right click the column header and select the Change to Lookup Column option.
In the Change to Lookup Column dialog that appears, select the column from the second table to look up.
Click Save & Close.
Click here to learn more about lookup columns.
Using query tables, Analytics Plus allows you to import the required data by writing standard SQL queries. This feature also allows you to combine data from different tables, and create reports from the combined data. Refer this documentation to know more.
Sharing & Collaboration
You can share the out-of-the-box reports, dashboards and tables, and the ones you create, with other users easily. Refer this documentation to know more.
The Zoho Creator workspace can be accessed only by the administrator who set up the integration. To allow other users to access the out-of-the-box reports and dashboards, you can share the reports and dashboards as needed. Refer this documentation to know more. You can also share the entire workspace with a user. Refer this documentation to know more.
Yes. To do this, share the required table with the users with the required permissions and filters. Refer this documentation to know more.
4. Is it possible to share the same report to multiple users such that they each see different data?
Yes, you can do this by creating Variables. This allows you to share the report to several users, with associated filter criteria so that each user can access only the data specific to them. To learn more, refer this documentation.
Yes, you can export the report or dashboard in various formats such as CSV, EXCEL, PDF, HTML and image. To learn more, refer this documentation.
To do this, export the report or dashboard in the required format and print the exported file. To learn more about exporting a view in Analytics Plus, refer this documentation.
Note: To export a shared report or dashboard, the Export permission has to be enabled. Refer this documentation to learn more about permissions.
Yes, you can easily set up email schedules. Refer this documentation to learn more.
Yes. You can easily embed reports and dashboards into websites, applications or blogs. Refer this documentation to know more.
Help & Support
Technical support is free for all users, even during the trial period. You can contact technical support through:
- Email: email@example.com
- Phone: +1-888-720-9500
You can also get answers straight from our community.
Yes, please register for a demo using the form on this page.