Workflow when using scripts

This is a high level description of the workflow using stored procedures in the Integration database. Using the stored procedures for integration is recommended for more complex integrations that cannot be completed via the user interface.
  1. In Infor d/EPM, configure the configuration sets and activate entities with associated currencies.
  2. In Microsoft SQL Server:
    1. Load the source system data to the staging tables using scripts.
    2. Run the scripts to validate the staged data.
    3. Run the scripts to process the data into tables ready for importing.
  3. In Designer:
    1. Establish a connection to the Integration database.
    2. Import the available dimensions.
    3. Recreate the OLAP database.
    4. Import data into the OLAP database.