Zoho Analytics

Zoho Analytics is a self-service business intelligence platform and analytics software by Zoho.

Data integration: Skyvia supports importing data to and from Zoho Analytics, exporting Zoho Analytics data to CSV files, and replicating Zoho Analytics data to relational databases.

Backup: Skyvia Backup does not support Zoho Analytics.

Query: Skyvia Query supports Zoho Analytics.

Establishing Connection

To create a connection to Zoho Analytics, select the data center, sign in with Zoho and select the workspace.

Creating Connection

To connect to Zoho Analytics, perform the following steps:

zoho-analitytics-connection

  1. Select the data center and Click Sign in with Zoho.

    zoho-analytics-enter-credentials

  2. Enter your credentials.

  3. Allow Skyvia to access data in Zoho account.

    zoho-analytics-permissions

Additional Connection Parameters

Asynchronous Export

This parameter enables the asynchronous export for connector.

Primary Key Columns

Here you can manually define primary key fields for connector objects.

To define a primary key for a specific object, use the object_name.field_name format. For example, to make the Account ID a primary key for the Accounts object, enter Accounts.Account ID.

To define a primary key for all objects in the connector, specify the field name only. For example, to make the Account ID a primary key for all the objects, enter Account ID.

Connector Specifics

Zoho Analytics has no predefined objects. All the objects and fields are custom.

Zoho Analytics supports the following field types

Zoho Analytics Type DbType and description
PLAIN String
MULTI_LINE String (length is 4000 characters or more up to CLOB)
EMAIL String
URL String (2048 characters)
BOOLEAN Boolean
AUTO_NUMBER INt64
NUMBER INt64 by default or Double if Decimal Places > 0
POSITIVE_NUMBER INt64 by default or Double if Decimal Places > 0
DECIMAL_NUMBER Decimal
CURRENCY String (255 characters)
PERCENT Double
GEO String (4000 characters)
GEO_NUM String (255 characters) altitude or longitude
DURATION String (255 characters)
DATETIME DateTime
DATE Date

Export Peculiarities

Zoho Analytics supports synchronous and asynchronous data export. Synchronous data export is useful for reading small data volumes. This approach is used by default in our connector.

Asynchronous export is more helpful for:

  • Tables having more than one million rows.
  • Tables and Views from live connect workspaces.
  • Dashboard and Querytable view types.

To use this approach, enable the Asynchronous Export parameter in Connection Editor. It allows only 5 simultaneous export jobs for an organization.

Filtering Specifics

Zoho Analytics API supports the following native filters:

Field Types Operators
PLAIN, MULTI_LINE, EMAIL, URL IS NULL, IS NOT NULL, =, !=, LIKE
BOOLEAN IS NULL, IS NOT NULL, =
AUTO_NUMBER, NUMBER, POSITIVE_NUMBER, DECIMAL_NUMBER, PERCENT, DURATION, DATETIME, DATE IS NULL, IS NOT NULL, =, !=, >, >=, <, <=, BETWEEN, IN
CURRENCY IS NULL, IS NOT NULL
GEO IS NULL, IS NOT NULL, =, !=, LIKE
GEO_NUM IS NULL, IS NOT NULL

Use these filters to improve performance and save API calls. You can use filters with other fields or operators, but it may increase API call usage.

Incremental Replication and Synchronization

Skyvia doesn’t support Replication with Incremental Updates and Synchronization for Zoho Analytics

DML Operations Support

All objects of the Table type support INSERT, UPDATE, and DELETE operations. QueryTable objects are read-only.

Supported Actions

Skyvia supports all the common actions for Zoho Analytics.

On This Page