Skip to main content
Installation Progress
  1. Create the source connection
  2. Create the destination connection
  3. Configure the global variable
  4. Import the extraction
  5. Import the cube extractions
  6. Schedule the extraction
  7. Set up the data source in SEI
  8. Import the template
  9. Build and load the OLAP cubes

Configure Global Variable

Follow these steps only to set up the OLAP cubes. Otherwise, continue with the standard setup.

Global variables in DataSync provide reusable values that scripts and processes use throughout your Sage 300 integration. By defining this variable, you create centralized references that control settings or drive automation within post-execution scripts and data refresh operations. This helps ensure consistency and simplifies maintenance whenever these parameters need to be updated.

Create the S300_SCHEMA global variable​

  1. From the DataSync welcome screen, select Variables.
  2. Next to Variables, click New.
  3. In Variable Name, enter S300_SCHEMA.
  4. In Variable Type, select String.
  5. In Variable Value, enter [YOUR_SCHEMA].
  6. Click Save.


Scenario 2: Data Warehouse & Scenario 4: Cloud – Next: Import the Synchronization Extraction →

Scenario 3: Consolidated – Next: Import the Consolidation Extraction →