Step 5: Loading data from staging to application database

The final data integration step is to load the data from the staging database to the application database. When you load data, dimension and hierarchy data that has changed in 规划业务建模器 is synchronized from the application database to the staging database.


Dimension and hierarchy data must be loaded before you can load model data.

You must be a member of the Data Administrator role to load data. For more information, see Security roles.



  • Data integration overview
    Provides an overview of the architecture of the 规划服务器 data integration system and of the data load processes.
  • 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.
  • Scriptable data integration
    Describes the commands in the 规划命令实用工具 that you can use to write a script that performs data integration steps.