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 Consola de administración de planeación 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 Consola de administración de planeación, or by using the Herramienta de comando de planeación. For more information, see Security roles.

En esta sección

• 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 Consola de administración de planeación.

• 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 Consola de administración de planeación.

• Attach or detach an existing staging database
  Provides instructions about how to attach a staging database in Consola de administración de planeación.

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

Secciones 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 Herramienta de comando de planeación. You can use these commands to write a script that performs data integration steps.

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