Using Application Data Sets to Migrate DEIU Data
PeopleSoft delivers Application Data Set (ADS) definitions to support data used by the Data Export Import Utility. Oracle’s PeopleSoft recommends configuring the Data Export Import Utility in a test database, validating the data, and using ADS to migrate the data to a production environment.
For introductory information about data migration using ADS, see this documentation:
Delivered Application Data Set Names for DEIU Data
The following table lists the ADS definitions delivered in Data Set Designer that support the migration of DEIU data:
ADS Definition |
ADS Usage |
Records in the Data Set |
---|---|---|
FS_MAP_DEFINITION |
This data set is used to move the map definition data for the Data Export Import Utility. |
This data set is built on the FS_MAP_HDR_TBL record. It includes these subrecords and related subrecords used for map definitions:
|
FS_DOC_RELATION |
This data set is used to move document relationship data used by map definitions in the Data Export Import Utility. |
This data set is built on the FS_DOC_RLTS_HDR record. It includes the FS_DOC_RLTS_GRP subrecord and related subrecords for document relationships. |
FS_FLAT_FILE |
This data set is used to move delimited file layout data used by map definitions in the Data Export Import Utility. |
This data set is built on the FS_FLAT_FILE record and FS_FF_LANG subrecord, which are used for delimited file layouts. |
FS_MAP_RUN |
This data set is used to move run control data used for Data Export Import Utility processing. |
This data set is built on the FS_MAP_REQUEST record, and FS_MAP_ATT and FS_MAP_RUN_PARA subrecords, which are used for transformation processing. |
You can find complete information about setting up and using ADS definitions for data migration in the PeopleTools: Lifecycle Management Guide. This documentation covers the following topics:
Using the Data Set Designer.
Copying and comparing projects.
Validating data sets.
Implementing data set security.