This chapter provides an overview of PeopleSoft Data Transformer and discusses:
PeopleSoft Data Transformer business processes.
PeopleSoft Data Transformer implementation.
PeopleSoft Data Transformer enables organizations to extract, transform, and load data from remote or local data sources to a target data source. Tasks that you perform in PeopleSoft Data Transformer, to prepare the data for transfer, include:
Setting up default target fields.
Defining transformation and filtering rules to convert data.
Creating map rules.
Creating map definitions.
The following process flow illustrates the PeopleSoft Data Transformer business processes:
PeopleSoft Data Transformer business process flow
The PeopleSoft Data Transformer implementation can be divided into two phases:
Setting up core PeopleSoft Data Transformer features.
Creating source data objects.
Complete these phases to support PeopleSoft Data Transformer features.
In the planning phase of your implementation, take advantage of all PeopleSoft sources of implementation, including the installation guides and business process maps.
To set up core PeopleSoft Data Transformer features, perform the following steps:
Step |
Reference |
1. Define remote database connections. |
|
2. Define installation options. |
|
3. Define subject areas. |
To set up source data objects, perform the following steps:
Step |
Reference |
1. Create basic source data objects. |
|
2. (Optional) Create expressions. |
|
3. (Optional) Create filters. |
|
4. (Optional) Join records. |