Skip to main content
Installation Progress
  1. Create the source connections
  2. Create the destination connection
  3. Import the extractions
  4. Schedule the extractions
  5. Set up the data source in SEI
  6. Import the template

Scheduler

To keep your Sage 200 UK data up-to-date for reporting, you can create job schedules in DataSync to automatically refresh, update, or clean your data warehouse without manual intervention. The Sage 200 UK template requires three schedules to manage your data lifecycle and ensure your reports always reflect the latest information.

Follow the steps below to configure each schedule.

ScheduleDescription
Incremental LoadRetrieves records that changed since the last load and updates their corresponding records in the destination. Typically runs weekly.
Truncate and LoadReplaces all data in the destination with current data from the source. Typically runs weekly.
Process Deleted RecordsDeletes records from the destination if they no longer exist in the source. This is based on the maximum number of days defined in the validation logic. Typically runs daily.

Schedule the extraction​

Configure the Incremental Load schedule​

  1. In the left panel, select the Scheduler icon.
  2. Click New.
  3. In the Description field, enter Incremental Load.
  4. From the Action dropdown list, select Incremental Load.
  5. From the Extraction dropdown list:
    • For scenarios 2 – data warehouse and 4 – cloud, select the synchronization refresh extraction.
    • For scenario 3 – consolidated, select all consolidation refresh extractions.
  6. Select the Active checkbox.
  7. In the left panel, select Weekly. Then configure the Start On date and At time.
  8. Edit the Time Zone as needed.
  9. Click Save.

Configure the Truncate and Load schedule​

  1. Click New.
  2. In the Description field, enter Truncate and Load as the name for your schedule.
  3. From the Action dropdown list, select Truncate and Load.
  4. From the Extraction dropdown list:
    • For scenarios 2 – data warehouse and 4 – cloud, select the synchronization no refresh extraction.
    • For scenario 3 – consolidated, select all consolidation no refresh extractions.
  5. Select the Active checkbox.
  6. In the left panel, select Weekly. Then configure the Start On date and At time.
  7. Edit the Time Zone as needed.
  8. Click Save.
note

Using No Refresh is recommended for the Truncate and Load schedule. Choosing Refresh is possible, but only if the table is not too large—otherwise, it may slow down or interrupt the schedule.

Configure the Process Deleted Records schedule​

  1. Click New.
  2. In the Description field, enter Process Deleted Records as the name for your schedule.
  3. In the Action dropdown list, select Process Deleted Records.
  4. From the Extraction dropdown list:
    • For scenarios 2 – data warehouse and 4 – cloud, select the synchronization refresh extraction.
    • For scenario 3 – consolidated, select all consolidation refresh extractions.
  5. Select the Active checkbox.
  6. In the left panel, select Daily. Then configure the Start On date and At time.
  7. Edit the Time Zone as needed.
  8. Click Save.


Scenario 2: Data Warehouse & Scenario 3: Consolidated – Next: Set Up the Data Source in SEI →

Scenario 4: Cloud – Next: Import the Template →