Workflow using stored procedures

This is a high-level description of the workflow using stored procedures in the Integration database. We recommend using the stored procedures for more complex integrations that cannot be completed through the user interface.

  1. In Microsoft SQL Server:
    1. Using stored procedures, load the source system data to the staging tables.
    2. Run the stored procedures to validate the staged data.
    3. Run the stored procedures to process the data into tables ready for importing.
  2. 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.
  3. In Infor d/EPM, configure the configuration sets and activate entities with associated currencies.