Data Migration Workbench Overview
Data Migration Workbench facilitates the Configuration Management process using Application Data Sets as its underlying transport technology . The Data Migration Workbench is designed to manage the complexity of migrating configuration data across multiple PeopleSoft systems. It is very common to have four or more databases in a PeopleSoft environment, including one or more for development, another for quality assurance, as well as the primary production system. PeopleTools migrates managed objects between environments in PeopleSoft projects that are extracted from one database and imported into another, which works well for PeopleTools metadata however it does not handle application configuration data.
The Data Migration Workbench provides the ability for any authorized developer to easily define application data sets and to compare and copy the data similar to the way managed objects have been copied and compared for many years.
Application Data Sets:
Enable developers to use PeopleSoft Pure Internet Architecture (PIA) to define data set definitions as a hierarchy of records with some collective properties. A data set definition defines the shape of data set instances. It consists of a hierarchy of one or more record definitions and some properties. Each child record has all the keys of its parent record and optional additional keys. A data set instance has a single root row defined by the unique keys of the root record.
Data set definitions are like record definitions: record definitions define a group of fields that constitute a record; data set definitions define a group of records that constitute a data set. Both record definitions and data set definitions are metadata that define the shape of data.
Enable developers or administrators using PIA to insert data sets instances ( data content) into projects to represent a unit of work as a data migration project. Data migration projects are like managed object projects: a collection of data set instances having various data set definitions.
Enable developers or administrators using PIA or Change Assistant to copy and compare projects containing data sets.
Enable PIA-based copy and compare to use powerful servers rather that the Windows workstations required for PeopleSoft Integrated Development Environment (PSIDE)-based copy and compare.
Note: Copy and Compare can also be run from Change Assistant using Application Engine, which is independent of PIA. Change Assistant requires a Windows client.
Integrate with the Enterprise Components Approval Framework to provide administrative control of the project copy from file process.
Provide enhanced security to assure that the data set definitions are suitable for copying data, that the user has access to the PIA data set pages, and that user has the right to copy and compare the data.
Provide an alternative to Data Mover that offers greater visibility and control for managed changes of a customer's environment.
The two main components in data sets are the Data Set Designer used to define the structure of the data set and the Data Migration Workbench, used to define the data migration project content and to orchestrate copy and compare. Data Migration Workbench shows the current status of a project and prevents inconsistent actions. Once you have defined the data migration project, you can copy the data to a file that can later be compared or copied from file on another PeopleSoft database.
The Data Migration Workbench uses a Project Repository as a place in the file system where project files can be copied to and from. The Project Repository is defined in the data base as a repository name, an associated file path, and one or more areas (sub folders) that can contain project files. The purpose of Project Repository is to avoid manually copying project files from one system to another by promoting common definition of shared file locations and providing better security for administrative control of the places that project files can be copied to.
Image: Data Set Components
This diagram illustrates the main components for Data Sets: Data Set Definition and Data Migration Workbench