Step 3: Populating the staging database

Planning Server supports loading of ID-based tables from the staging database to the application database. Because only ID-based tables can be loaded, stored procedures are provided to help you prepare data that has labels in hierarchy and measure group tables.

In This Section

  • About data preparation
    Learn about the BizSystemFlag, and other important considerations for preparing data.
  • About preparing hierarchy data
    Learn about how to prepare hierarchy data. Also learn how to populate a hierarchy and how to prepare label-based data for hierarchies.
  • Data integration overview
    Provides an overview of the architecture of the Planning Server data integration system and of the data load processes.
  • Step 2: Synchronizing the staging database
    Provides background information about how Planning Server 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 Planning Command Utility. You can use the commands to write a script that performs data integration steps.