Skip to main content
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 SEI
  6. Import the template
  7. Build and load the OLAP cubes
  8. Import users to SEI (optional)

Synchronization Extraction

After creating your source and destination connections, the next step is to import the Sage X3 extraction template (ZIP file) into DataSync. This creates the necessary extractions for synchronizing your data and allows you to validate, build, and run them to load data into your data warehouse.

When DataSync processes a synchronization extraction, it connects to your Sage X3 database for a single company, extracts the necessary tables, and loads them into your data warehouse. This ensures that your reporting database always reflects the latest information from that specific Sage X3 company.

Configure the synchronization extraction​

StepDescription
Import the extractionLoad the Sage X3 extraction ZIP file into DataSync and map the connections and schema fields.
Validate and build the extractionCheck and generate the extraction objects to ensure all required tables and fields are included.
Run the extractionPopulate the destination tables with data from Sage X3 and verify the status or any errors.

Import the extraction​

  1. In the left panel, select the Extractions icon.
  2. Click the Import Extraction icon in the top-right corner to open the dialog.
  3. Click Choose a zip file and select the appropriate Sage X3 ZIP file for your version:
    • For Sage X3 older versions with SQL Server, choose DS_20XX.0.X.XXX_Sage X3v11 SYNC - SQL.zip
    • For Sage X3 recent versions with SQL Server, choose DS_20XX.0.X.XXX_Sage X3v12 SYNC - SQL.zip
    • For Sage X3 version 11 with Oracle, choose DS_20XX.0.X.XXX_Sage X3v11 SYNC - ORACLE.zip
  4. Click Next.
  5. Confirm the default extraction type is selected. Click Next again.
  6. In the Description field, enter a meaningful name, such as Synchronization.
  7. In Unique Identifier, enter the company name.
  8. In Column Name, enter CPYID.
  9. Select the previously created Source Connection.
  10. Select the Source Schema.
  11. In Destination Connection, select Data Warehouse.
  12. Select the Destination Schema. Click Add and enter a new schema name, such as SX3.
  13. Leave all other settings at their default values.
  14. Click Import.
    When the Tables window opens, confirm that all required tables and fields are present. If any are missing, repeat the import process.

Validate and build the extraction​

  1. In the left panel, click Extractions.
  2. Select the extraction you just created.
  3. Click the Validate and Build icon in the top-right corner.
  4. In the dialog, for the first company only, select Drop the previously created object and recreate the objects based on the new definition.
  5. Click Build.
    When the process is complete, review the validation report and the Status column. If an error appears, click the link in the Error column to view the Log Page.

Run the extraction​

  1. Select your extraction from the list and click the Run Extraction Now icon.
  2. Select the tables to populate.
  3. In the upper right, set the load mode to Truncate and Load, then click Run. This replaces all destination data with current source data.
    Wait for the process to finish. The results appear in the Status column. If there's an error, click the link in the Error column to view details in the Logs page.


Next: Schedule the Extraction →