Article
03/04/2011

Data integration overview

This topic provides links to information about the architecture, process, and practices for moving data from various sources to the application database for presentation and analysis.

In This Section

About logical data structures in Planning Server
Describes the data structure elements that are used in Planning Server, such as application, model site and model, and dimensions.

Data integration architecture
An overview of the architectural components that are used in data integration.

Data integration process
An overview of the processes for loading data from the staging database to the application database.

Data integration overview
Describes the architecture of data integration

Data integration configurations
Describes required settings for data integration

Step 1: Creating the staging database
Describes how to create a staging database in Planning Business Modeler or in Planning Administration Console.

Step 2: Synchronizing the staging database
Describes the data integration step that creates measure groups, dimensions, and hierarchies in the staging database.

Step 3: Populating the staging database
Describes how to prepare dimension data and hierarchies, and describes the stored procedures that populate the database.

Step 4: Validating data in the staging database
Describes the stored procedures that validate dimensions and hierarchies in the staging database.

Step 5: Loading data from staging to application database
Describes the stored procedures that load data and metadata.

Scriptable data integration
Describes the command-line options for Planning Server.

Troubleshoot data integration
Provides reference information about error messages.