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 계획 명령 유틸리티. For more information, see Scriptable data integration.

주의:
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

이 섹션의 내용

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

• About synchronizing dimensions and models
  Provides helpful information about synchronizing models, In addition, provides recommendations and best practices for synchronizing data.

• Synchronize dimensions
  Describes the steps that you can follow to synchronize a specified dimension.

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

• About the structure of the staging database
  Describes the general structure of the staging database after synchronization.

관련 섹션

• Data integration overview
  Provides an overview of the architecture of the 계획 서버 data integration system and of the data load processes.

• Data integration configurations
  Describes different configurations that you can use for security and performance.

• Step 1: Creating the staging database
  Provides background information about the organization of the staging database, and describes the steps that are required to create it.

• Step 2: Synchronizing the staging database
  Provides background information about how 계획 서버 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 계획 명령 유틸리티 that you can use to write a script that performs data integration steps.

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