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 sources in Nectari
8. Import the template
9. Build and load the OLAP cubes
10. Import users to Nectari (optional)

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 X3 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 X3_CUBESCHEMA global variable

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

Create the X3_LANG global variable

1. From the DataSync welcome screen, select Variables.
2. Next to Variables, click New.
3. In Variable Name, enter X3_LANG.
4. In Variable Type, select String.
5. In Variable Value, the language code you want to use for dimension descriptions (e.g., ENG).
6. Click Save.

Create the OPENBAL global variable

1. From the DataSync welcome screen, select Variables.
2. Next to Variables, click New.
3. In Variable Name, enter OPENBAL.
4. In Variable Type, select String.
5. In Variable Value, enter one of the following:

• SIM — simulate opening balances when none exist in Sage X3
• X3 — only use opening balances from Sage X3

6. Click Save.

Next: Import the Synchronization Extraction →