Understanding Data Set Designer and the Data Migration Workbench

The Application Data Set functionality includes the Data Set Designer component (PTADSMMGR) and the Data Migration Workbench component (PTADSDMW):

Data Set Designer

Authorized administrators use the Data Set Designer to create data set definitions (ADS definitions) as a hierarchical structure of records and their collective properties.

A data set definition, with its group of records, constitutes a data set. Both record definitions and data set definitions are metadata that define the shape of the migration data. The same data set definition must exist in any PeopleSoft database that participates in a data set copy or compare.

For more information about Data Set Designer, see PeopleTools: Lifecycle Management Guide, “Using Data Set Designer”.

Data Migration Workbench

Authorized administrators can then use the Data Migration Workbench to insert data set instances (data content) into projects that represent a unit of work as a data migration project. Data migration projects are like managed object projects: a collection of data set instances with various data set definitions. The Data Migration Workbench enables administrators to copy and compare projects containing data sets as well as view compare reports and validation reports.

You can also integrate the Enterprise Components Approval Framework to provide administrative control of the Project Copy from File process. Employ enhanced security to ensure that the Data Set definitions are suitable for copying data, to enable user security for the data set pages, and assign access to copy and compare the data. PeopleSoft delivers the MigrateData process ID for enabling data migration Approval Framework.

For more information about security, see PeopleTools: Lifecycle Management Guide, ”Implementing Data Set Security”.