Step 5: Loading data from staging to application database

The final data integration step is to load the data from the staging database to the application database. When you load data, dimension and hierarchy data that has changed in Planning Business Modeler is synchronized from the application database to the staging database.

Note

Dimension and hierarchy data must be loaded before you can load model data.

You must be a member of the Data Administrator role to load data. For more information, see Security roles.

In This Section

  • Data integration overview
    Provides an overview of the architecture of the Planning Server data integration system and of the data load processes.
  • Step 2: Synchronizing the staging database
    Provides background information about how Planning Server synchronizes the structures and data of each database, and describes the steps that are required to perform synchronization.
  • Scriptable data integration
    Describes the commands in the Planning Command Utility that you can use to write a script that performs data integration steps.