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 Console de Administração do Planning 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 Console de Administração do Planning, or by using the Utilitário de Comando do Planning. For more information, see Security roles.

Nesta Seção

• 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 Console de Administração do Planning.

• 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 Console de Administração do Planning.

• Attach or detach an existing staging database
  Provides instructions about how to attach a staging database in Console de Administração do Planning.

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

Seções Relacionadas

• 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 Utilitário de Comando do Planning. You can use these commands to write a script that performs data integration steps.

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