Skip to main content

Scheduled Synchronization

In HAP integration center, it allows data synchronization at scheduled intervals or specific times. Users can configure whether to fully overwrite data or only add/modify data based on specified fields during synchronization.

Currently, only SAP HANA data sources support scheduled synchronization, while other data sources only support real-time synchronization.

1. Create connection​

Select SAP HANA as data source, choose the target data source type, then click Next.

2. Select or create data source​

Create a new data source or select an existing one. Click "Test Connection", and once the connection is successful, click Next.

3. Select destination database​

4. Choose synchronization method​

Example: Select "synchronize data only"

5. Select the database and data object to synchronize​

6. Set up scheduled synchronization task​

  • Data read interval: Set to synchronize hourly or at a specific time every day.

  • Data reading method

    • Read all data each time

      Precondition: The table must include a primary key and will read complete data from the source, overwriting into the destination.

    • Read only new or modified data each time

      Precondition: The source table must contain any of the primary key, date/time stamp, or numeric field.

      • Matching field

        Select a field as the filtering field for each modification. The data source's primary key, date/time stamp, and numeric field will be shown as dropdown options.

        Primary key/numeric: For example, if the last sync range was 1 to 100, the next sync will start from over 100.

        Date/time stamp: For example, if the last sync was until June 14, 2024, at 00:29:49, the next sync will start from this time onward.

        First read start value: Based on the selected filtering field, the minimum value from the database records will be read.

7. Set up synchronization fields​

Configure the synchronization fields and other settings, then click to create the synchronization task.