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.

Related Sections

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