Maintain Data freshness with multiple sync intervals

Access to the most recent data is crucial to staying ahead in your analytical efforts. Outdated data can lead to incorrect analysis and decision-making. This article covers the data sync intervals available and the methods to configure.

On this Page

Data Sync Intervals in Zoho Analytics

Zoho Analytics offers flexible sync schedules to ensure that the data is always up-to-date for effective analysis. The following are the data frequency supported in Zoho Analytics.

  • Every 'N' hour (Enterprise plan)
  • Everyday (Standard plan and above)
  • Weekly Once (Standard plan and above) 
  • Monthly Once (Standard plan and above) 

Multiple Sync Intervals

While analyzing data, there might arise a need to sync different tables at different intervals. Zoho Analytics allows you to configure multiple sync schedules within a connection, enabling you to set different tables to sync at various intervals. For example, some tables can be set to sync every hour, while others can be synced daily or weekly, based on your needs.

Note: A connection can currently have a maximum of five different sync schedules.

Configuring Multiple Sync Intervals 

Multiple Sync Intervals can be configured in the following two ways in Zoho Analytics:

  • From the Data sources tab
    • Creating a new sync interval when all the tables in a connection have the same data sync interval.
    • Creating a new sync interval when there are more than one sync interval configured for a connection.
      While importing data as a new table in an existing connection
  • While importing data as a new table in an existing connection.

From the Data Sources Tab

Case 1: When all the tables in a connection have the same data sync interval

To configure multiple sync intervals,

  1. Access the Data Sources tab from the side navigation panel.
  2. Choose the connection (database) for which you need to modify the sync schedules.
  3. Click Sync Settings.
  4. The Cloud Database - Synchronization Settings will open; click Set Multiple Sync Intervals.
  5. Select the tables that should be moved to a new sync interval.
  6. In the Schedule Settings section, choose the interval in which the data should be synced from the Repeat option drop-down menu. Zoho Analytics provides multiple sync intervals such as Every N hours, Every Day, Weekly Once, Monthly once. Selecting Not Scheduled will import the data only once, i.e., at the time of import.
  7. Specify the other related settings, such as the time of day (for daily syncs), day of the week (for weekly syncs), and date of the month (for monthly syncs) can be configured based on the selected interval.
  8. The Notify Me After Every option keeps you informed by sending updates whenever there are consecutive import failures, ensuring you are aware of any issues with data synchronization.
  9. You can also choose to notify Account Admins, Workspace Admins, Organization Admins, and Custom users (selected users).
  10. Click Save.

Once multiple sync schedules are configured for a connection, the tables are grouped according to their respective sync schedules.

Case 2: Creating a new sync interval when there is more than one sync interval configured for a connection

Once multiple sync schedules are configured for a connection, the tables are grouped according to their respective sync schedules.

  1. Access the Data Sources tab from the side navigation panel.
  2. Choose the connection (database) for which you need to modify the sync schedules.
  3. Select the tables you want to add to a new interval and click Move table.
  4. Choose the Schedule to which the tables should be moved and click Move. The tables will be moved to the chosen sync interval.

Alternately, you can also create a New Sync Interval using the steps given below:

  1. Choose the Schedule from which you want to move tables to a new schedule.
  2. Click the Edit option adjacent to the Schedule field.
  3. The Cloud Database - Synchronization Settings will open; click Create New Sync Interval.
  4. Select the tables that should be moved to a new sync interval.
  5. In the Schedule Settings section, choose the interval in which the data should be synced from the Repeat option drop-down menu.
  6. The successive steps are similar to the steps mentioned in the above section.

Configuring Multiple Sync Intervals While Importing a New Table in an Existing Connection

  1. Click the Create icon on the side navigation panel and choose New Table or Import Data.
  2. Choose existing connections and the tables to be imported. Click Next.
  3. By default, the existing schedule will be applied to the new tables that are set to import. Click Edit Schedule to modify the schedule interval.
  4. Choose the preferred data fetch method and click Next. Refer to this article to learn more.
  5. The existing data sync schedules will be listed; click Create New Sync Interval.
  6. In the Schedule Settings section, choose the interval in which the data should be synced from the Repeat option drop-down menu. Zoho Analytics provides multiple sync intervals such as Every N hours, Every Day, Weekly Once, Monthly once. Selecting Not Scheduled will import the data only once, i.e., at the time of import.
  7. The other related settings, such as the time of day (for daily syncs), day of the week (for weekly syncs), and date of the month (for monthly syncs) can be configured based on the selected interval.
  8. The Notify Me After Every option keeps you informed by sending updates whenever there are consecutive import failures, ensuring you are aware of any issues with data synchronization.
  9. You can also choose to notify Account Admins, Workspace Admins, Organization Admins, and Custom users (selected users) in the case of sync failures.
  10. Click Save.