Skip to main content
Installation Progress
  1. Create the source connections
  2. Create the destination connection
  3. Configure the global variable
  4. Upload the project into Acumatica
  5. Import the extractions
  6. Import the cube extractions
  7. Schedule the extractions
  8. Set up the data source in Nectari
  9. Configure Acumatica real‑time finance
  10. Import the template
  11. Build and load the OLAP cubes

Cube Extraction

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

After creating your cube source connection and configuring your global variable, the next step is to import the Acumatica cube extraction templates (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 the extraction, it connects to your Acumatica database, 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 Acumatica.

important

Cube extractions require that the standard synchronization or consolidation extraction be imported and built before importing the Nectari template.

Cube extraction order​

Cube extractions must be imported and built in a specific order. Importing them out of order will cause validation or build failures.

Extraction TypeDescription
1 – Table StagingLoads the staging tables required for cube processing. Executed only once.
2 – Dimension MappingLoads the dimension‑mapping tables used by the cubes and refreshes the data.

Configure the cube extractions​

1 – Table Staging 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 Acumatica ZIP file (DS_20XX.0.X.XXX_Acumatica OLAP ETL Staging.zip), or drag and drop the file into the dialog.
  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 Cube - Table Staging.
  7. Select the Source Connection created for Data Warehouse (Source).
  8. In Destination Connection, select Data Warehouse.
  9. Select the Destination Schema. Click Add and enter a new schema name, such as Acumatica.
  10. Leave all other settings at their default values.
  11. Click Import.
  12. In the left panel, click Extractions again.
  13. Select the extraction you just created, and click the Validate and Build icon in the top-right corner.
  14. In the dialog, for the first company only, select Drop the previously created object and recreate the objects based on the new definition.
  15. 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.
  16. Select your extraction from the list and click the Run Extraction Now icon.
  17. Select the tables to populate.
  18. 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.

2 – Dimension Mapping 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 Acumatica ZIP file (DS_20XX.0.X.XXX_Acumatica OLAP ETL Refresh.zip), or drag and drop the file into the dialog.
  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 Cube - Dimension Mapping.
  7. Select the Source Connection created for Data Warehouse (Source).
  8. In Destination Connection, select Data Warehouse.
  9. Select the Destination Schema. Click Add and enter a new schema name, such as Acumatica.
  10. Leave all other settings at their default values.
  11. Click Import.
  12. In the left panel, click Extractions again.
  13. Select the extraction you just created, and click the Validate and Build icon in the top-right corner.
  14. In the dialog, for the first company only, select Drop the previously created object and recreate the objects based on the new definition.
  15. 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.
  16. Select your extraction from the list and click the Run Extraction Now icon.
  17. Select the tables to populate.
  18. 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 Extractions →