项目
06/14/2010

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 规划业务建模器 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.