Synchronizing and Scheduling Integrations

A new version of AutoSync is available in Studio! Check out the documentation.

You can choose the synchronization type when creating or editing an integration. AutoSync offers one or more of the following for each source-destination pair:

  • Load and reload: Loads the first time and on reload, overwrites the tables.

  • Insert new and update changed: Upserts on reload.

  • Maintain change history using SCD2: Preserves change history.

AutoSync can process up to 2 billion records per table, per load. For tables with more than 2 billion records, you can use Insert new and update changed to process the remaining records in subsequent loads, if it is available for the endpoints.

The integration executes if you click Save and Load during creation or editing. Subsequent loads are scheduled every 6 hours by default. You can schedule custom synchronization for a frequency between one minute and 999999 hours and 59 minutes.

This page describes the following procedures:

Running an Integration Manually

You can run an integration in either of the following ways:

  • When creating or editing it, click Save and Load.

  • From the AutoSync dashboard, in the integration card, click the run button and it executes after a 10-second lag:

Editing the Synchronization Type, Concurrency, or Tables to Replicate

To change the settings related to synchronization, edit the integration from the AutoSync dashboard:

  1. Click the edit button on the integration card:

    The integration opens.

  2. Click step 3:

  3. Change the method, concurrency, or tables to synchronize:

  4. Click Save or Save and Load.

Editing the Synchronization Schedule

Edit the start time and schedule for an integration from the AutoSync dashboard:

  1. In the Integration card, click the schedule button:

    The Schedule synchronization dialog opens:

  2. Select a Start time from the list.

  3. Select the frequency from those in the Repeat every list. For Custom, you can enter hours and minutes up to 999999 hours and 59 minutes.
    The Preview updates with the next three scheduled loads.

  4. Click Save change.