Data integration process

During application creation in 规划管理控制台 or in 规划业务建模器, a staging database is created. The staging database that is created is empty and will receive content in Step 2. For more information, see Step 1: Creating the staging database.

You can start this step after you have an application built and models and dimensions that were created in 规划业务建模器. When you synchronize a model or dimension, related structures and data are created from the application database into the staging area database. For more information, see Step 2: Synchronizing the staging database. To learn how to synchronize by using the 规划命令实用工具, see Scriptable data integration.

In Microsoft SQL Server 2005, use the existing tool set. The tool set includes SQL Server script files, SQL Server Integration Service packages, or custom code, to populate the staging area database.

注意：
This is a manual process and is not supported by 规划服务器.

For more information, see Step 3: Populating the staging database.

After the data is loaded into the staging area database, in SQL Server, we recommend that you run stored procedures to validate the logical business rules and foreign key relationships. For more information, see Step 4: Validating data in the staging database.

In 规划业务建模器, load data from the staging area database into the application database. The arrow in the illustration is bidirectional because there is a partial synchronization for application changes from the application database to the staging database before data is loaded. For more information, see Step 5: Loading data from staging to application database. To learn how to load data by using the 规划命令实用工具, see Scriptable data integration.