• Artículo

Step 2: Synchronizing the staging database

Synchronizing the staging database is the second step in the data integration process. Synchronization can occur many times because data integration is an iterative process when models and dimensions are created or modified in Planning Business Modeler. You can also script synchronization by using the Herramienta de comando de planeación. For more information, see Scriptable data integration.

PrecauciónPrecaución:

   The synchronization operation overwrites the existing tables for those dimensions and models that you select.

To synchronize dimension and hierarchy data that has changed because of actions in Planning Business Modeler, you can run a partial synchronization. For more information about the tools that you can use to run a partial synchronization, see Step 5: Loading data from staging to application database

En esta sección

The following are considerations and procedures for synchronizing dimensions, models, and associations.

  • Synchronize models
    Describes the steps that you can follow to synchronize models, dimensions, hierarchies, and related annotations.

Secciones relacionadas

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