Skip to main content
Installation Progress
  1. Create the source connections
  2. Create the destination connection
  3. Import the extractions
  4. Configure the global variables
  5. Schedule the extractions
  6. Set up the data sources in Nectari
  7. Import the template
  8. Build and load the OLAP cubes
  9. Import users to Nectari (optional)

Configure Global Variables

Global variables in DataSync provide reusable values that scripts and processes use throughout your Sage XRT Advanced integration. By defining these variables, 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.

Configure two global variables:

Global variableDescription
SXA_CUSTOM_SCHEMADefines the custom schema for post-execution scripts to read tables and insert missing fields.
TODAYDefines the date value used in post-execution scripts to refresh the daily cash balance.

Create the SXA_CUSTOM_SCHEMA global variable​

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

Create the TODAY global variable​

  1. Next to Variables, click New again.
  2. In Variable Name, enter TODAY.
  3. In Variable Type, select String.
  4. In Variable Value, enter DUMMY.
  5. Click Save.


Next: Schedule the Extractions →