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.

이 섹션의 내용

• About logical data structures in Planning Server
  Describes the data structure elements that are used in 계획 서버, 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 계획 관리 콘솔.

• 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 계획 서버.

• Troubleshoot data integration
  Provides reference information about error messages.