Installation Progress

1. Create the source connection
2. Create the destination connection
3. Import the extraction
4. Schedule the extraction
5. Set up the data sources in Nectari
6. Import the template
7. Build and load the OLAP cubes
8. Import users to Nectari (optional)

Scheduler

To keep your Sage X3 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 X3 template requires one schedule to manage your data lifecycle and ensure your reports always reflect the latest information.

Schedule the extraction

Configure the Incremental Load schedule

Retrieves records that changed since the last load and updates their corresponding records in the destination. Typically runs weekly.

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, select the synchronization extraction.
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.

Scenario 2: Data Warehouse – Next: Set Up the Data Source in Nectari →

Scenario 3: Cloud – Next: Import the Template →