This chapter provides an overview of PeopleSoft Data Transformer and discusses:
PeopleSoft Data Transformer business processes.
PeopleSoft Data Transformer implementation.
PeopleSoft Data Transformer OverviewPeopleSoft 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.
PeopleSoft Data Transformer Business ProcessesThe following process flow illustrates the PeopleSoft Data Transformer business processes:
![]()
PeopleSoft Data Transformer business process flow
PeopleSoft Data Transformer ImplementationThe 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.

Setting Up Core PeopleSoft Data Transformer Features
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. |

Creating Source Data Objects
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. |