PerformancePoint Server data integration process

Updated: 2009-04-30

The PerformancePoint data integration process moves data from a separate staging database to an application database in Planning Server, and then loads data into a model from which users work.

• Data integration overview

• Data integration configurations

• Step 1: Creating the staging database

• Step 2: Synchronizing the staging database

• Step 3: Populating the staging database

• Step 4: Validating data in the staging database

• Step 5: Loading data from staging to application database

• Scriptable data integration

• Troubleshoot data integration

The following are two video demonstrations of data integration presented by Forrest Dermid, one of Microsoft's senior technical solutions professionals.

• Demo about how to load dimension and hierarchy data from AdventureWorks

• Demo about how to prepare label-based measure group data

Download this book

This topic is included in the following downloadable book for easier reading and printing:

• Planning Server Planning and Architecture Guide for PerformancePoint Server 2007

See the full list of available books at Downloadable content for PerformancePoint Planning Server.

See Also

Concepts

PerformancePoint Server Data Import Wizard (OBSOLETE)