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)

Source Connection

A source connection in DataSync defines how the system connects to your Sage X3 database to extract and refresh data. Creating source connections is required before you can load or synchronize tables in your data warehouse.

Create a refresh source connection in DataSync​

  1. Log in to DataSync.
  2. From the welcome screen, select Connections.
  3. Next to Source Connections, click New.
  4. Select SQL Server or Oracle.
  5. In the Connection Properties panel, enter Refresh as the description.
  6. Enter the Server and Database names.
  7. Enter the Sage X3 database credentials for Username and Password.
  8. In the Advanced Settings panel, set Tracking Type to Date.
    The time zone must match the Sage X3 application server.
  9. Click Save.


Next: Create the Destination Connection →