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

• About loading dimensions
  Important considerations when you load dimension data.

• Load dimension data
  Learn how to load dimension and hierarchy data.

• About loading models
  Important considerations when you load model data.

• Load model data
  Learn how to load model data.

Related Sections

• Data integration overview
  Provides an overview of the architecture of the Planning Server data integration system and of the data load processes.

• Data integration configurations
  Describes different configurations that you can use for security and performance.

• Step 1: Creating the staging database
  Provides background information about the organization of the staging database, and describes the steps that are required to create it.

• 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.

• Step 3: Populating the staging database
  Describes how to prepare data and structures for data loading.

• Step 4: Validating data in the staging database
  Describes the procedures that validate data in the staging database, and describes the steps that are required to run the procedures.

• Scriptable data integration
  Describes the commands in the Planning Command Utility that you can use to write a script that performs data integration steps.

• Troubleshoot data integration
  Provides detailed reference information about error codes.