Step 1: Creating the staging database

PerformancePoint Server 2007

The first step to integrating data into the application database is to create a staging database. You might want to create a staging database in 规划管理控制台 for an existing application or for a new application.

The following list shows several reasons to create a staging database.

  • To start data integration by using a new staging database

  • To bring an existing staging database online after data cleansing

  • To replace the existing staging database

You must be a member of the Global Administrator role to create a staging database in 规划业务建模器 or 规划管理控制台, or by using the 规划命令实用工具. For more information, see Security roles.

本节内容

About the staging database

Discusses what the staging database is and how it is used.

Create the staging database

Provides instructions on how to create a staging database for a new application in 规划业务建模器 and in 规划管理控制台.

About the staging database after it is created

Provides information about the structure of the staging database after it is created in either 规划业务建模器 or 规划管理控制台.

Attach or detach an existing staging database

Provides instructions about how to attach a staging database in 规划管理控制台.

Connect to Planning Server for data integration

Provides instructions about how to connect to the Planning Server for data integration.

相关章节

Data integration overview

Provides an overview of the architecture of the PPLS data integration system and of the data load processes.

Data integration configurations

Describes different configurations that you can use for security and performance.

Step 2: Synchronizing the staging database

Provides background information about how 规划服务器 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.

Step 5: Loading data from staging to application database

Provides background information about dimensions and models, and describes the steps that are required to load data

Scriptable data integration

Describes the commands in the 规划命令实用工具. You can use these commands to write a script that performs data integration steps.

Troubleshoot data integration

Provides detailed reference information about error codes.

显示: