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

  • 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.

Secciones relacionadas

  • Data integration overview
    Provides an overview of the architecture of the PPLS 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 Herramienta de comando de planeación. You can use these commands to write a script that performs data integration steps.