Understanding PeopleSoft Product Configuration
Data Synchronization
This chapter provides an overview of Product Configuration data synchronization and discusses how to:
Migrate data using Data Mover.
Migrate data using PeopleSoft Integration Broker.
Understanding PeopleSoft Product Configuration
Data Synchronization
During a Product Configurator implementation the question of how to migrate data between different databases often arises. There are a couple of different approaches that can be used to synchronize Product Configuration data such as, configuration rules, and matrices between different databases. You can use PeopleSoft's Data Mover or the predefined service operations that Product Configuration provides. Product Configuration data can be replicated between different Financials and Supply Chain Management (FSCM) databases and a Customer Relationship Management databases.
Migrating Data Using PeopleSoft Data Mover
Product Configuration data can be replicated across databases using Data Mover. Complete Product Configuration data export and import scripts are provided on the PeopleSoft CD under the <PS_HOME>\scripts folder. Namely, the script that exports all of the Product Configuration data is cpdmsexport_all.dms and the script that loads the output from the export script into a database is cpdmsimport_all.dms.
See Also
Enterprise PeopleTools PeopleBook: Data Management
Migrating Data Using PeopleSoft Integration
Broker
Product Configuration data can also be replicated across databases using PeopleSoft Integration Broker. The following table provides a detailed list of all of the service operations that are provided for Product Configuration data synchronization:
|
Description |
Service Operation (Inbound/Outbound) |
Messages |
|
|
Batch, Full table synchronization of Product Configurator Constraint data. |
This service operation handles the publish and subscription of Product Configurator Constraint data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_CONSTRAINT_FULLSYNC |
CP_CONSTRT_HDR CP_CONSTRT_COND CP_CONSTRT_DETL |
|
Batch, Full table synchronization of Product Configurator Expression data. |
This service operation handles the publish and subscription of Product Configurator Expression data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_EXPRESSION_FULLSYNC |
CP_EXPR CP_EXPR_FORMAT |
|
Batch, Full table synchronization of Product Configurator Global Variable data. |
This service operation handles the publish and subscription of Product Configurator Global Variable data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_GLOBAL_FULLSYNC |
CP_GBL_VAR |
|
Batch, Full table synchronization of Product Configurator Internal Variable data. |
This service operation handles the publish and subscription of Product Configurator Internal Variable data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_INTRN_VAR_FULLSYNC |
CP_INTRN_VAR CP_INTRN_KEY |
|
Batch, Full table synchronization of Product Configurator Matrix data. |
This service operation handles the publish and subscription of Product Configurator Matrix data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_MATRIX_FULLSYNC |
CP_MATRIX_HDR CP_MATRIX_DETL |
|
Batch, Full table synchronization of Product Configurator data. |
This service operation handles the publish and subscription of Product Configurator data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_MESSAGE_FULLSYNC |
CP_MESSAGE CP_MESSAGE_LANG |
|
Batch, Full table synchronization of Product Configurator Multiple Option data. |
This service operation handles the publish and subscription of Product Configurator Multiple Option data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_MULTOP_FULLSYNC |
CP_MULTOP_HDR CP_MULTOP_DETL |
|
Batch, Full table synchronization of Product Configurator Option Variable data. |
This service operation handles the publish and subscription of Product Configurator Option Variable data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_OPTION_FULLSYNC |
CP_OPT_VAR |
|
Batch, Full table synchronization of Product Configurator Print Code data. |
This service operation handles the publish and subscription of Product Configurator Print Code data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_PRINTCD_FULLSYNC |
CP_PRINTCD |
|
Batch, Full table synchronization of Product Configurator Rule data. |
This service operation handles the publish and subscription of Product Configurator Rule data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_RULE_FULLSYNC |
CP_RULE_HDR CP_RULE_COMMENT CP_RULE_DETL CP_RULE_D_LANG CP_RULE_DETL_AD CP_RULE_DETL_CL CP_RULE_DETL_OS CP_RULE_HTML CP_RULE_HT_LANG CP_RULE_H_LANG |
|
Batch, Full table synchronization of Product Configurator Secondary Variable data. |
This service operation handles the publish and subscription of Product Configurator Secondary Variable data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_SECONDARY_FULLSYNC |
CP_SEC_VAR |
|
Batch, Full table synchronization of Product Configurator Template data. |
This service operation handles the publish and subscription of Product Configurator Template data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_TEMPLATE_FULLSYNC |
CP_TEMP_HDR CP_TEMP_DETL |
|
Batch, Full table synchronization of Product Configurator Constant data. |
This service operation handles the publish and subscription of Product Configurator Constant data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_CONSTANT_FULLSYNC |
CP_CONSTANT |
|
Batch, Full table synchronization of Product Configurator Model data. |
This service operation handles the publish and subscription of Product Configurator Model data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_TREE_FULLSYNC |
CP_TREE_HDR CP_TREE_DETL |
|
Batch, Full table synchronization of Product Configurator Value List data. |
This service operation handles the publish and subscription of Product Configurator Value List data. This service operation is designed to be used with the Enterprise Integration Full Batch Publish design pattern. |
CP_VALUE_LIST_FULLSYNC |
CP_USERCD_HDR CP_USERCD_DETL CP_USERCD_LANG |
Setting Up the Service Operations for Product Configurator
You must activate the service operations in order to migrate data across databases.
See Implementing Integrations.
Publication Run Control Definitions
You use the Full Data Publish page (Enterprise Components menu) to create the run control parameters and initiate the Table Replication Push (EOP_PUBLISHT) application engine process.
Instead of creating a separate run control definition for each service operation, you can add multiple request IDs—a row for each service operation name—to a single-run control ID to publish all data at once.
Performing a Full Data Publish of Current Effective Data
To perform a full data publish, please refer to the PeopleSoft Enterprise Supply Chain Management Integration PeopleBook.
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Integration Testing Utilities and Tools