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.