Step 1: Creating the staging database

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 Planning Administration Console 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 Planning Business Modeler or Planning Administration Console, or by using the Planning Command Utility. For more information, see Security roles.

In This Section

• 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 Planning Business Modeler and in Planning Administration Console.

• About the staging database after it is created
  Provides information about the structure of the staging database after it is created in either Planning Business Modeler or Planning Administration Console.

• Attach or detach an existing staging database
  Provides instructions about how to attach a staging database in Planning Administration Console.

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

Related Sections

• 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 Planning Server 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 Planning Command Utility. You can use these commands to write a script that performs data integration steps.

• Troubleshoot data integration
  Provides detailed reference information about error codes.