Getting Started with PeopleSoft Data Transformer

This chapter provides an overview of PeopleSoft Data Transformer and discusses:

Click to jump to parent topicPeopleSoft Data Transformer Overview

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:

Click to jump to parent topicPeopleSoft Data Transformer Business Processes

The following process flow illustrates the PeopleSoft Data Transformer business processes:

PeopleSoft Data Transformer business process flow

Click to jump to parent topicPeopleSoft Data Transformer Implementation

The PeopleSoft Data Transformer implementation can be divided into two phases:

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.

Click to jump to top of pageClick to jump to parent topicSetting 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.

See Defining Remote Database Connections.

2. Define installation options.

See Defining Installation Options.

3. Define subject areas.

See Defining Subject Areas.

Click to jump to top of pageClick to jump to parent topicCreating Source Data Objects

To set up source data objects, perform the following steps:

Step

Reference

1. Create basic source data objects.

See Creating Basic Source Data Objects.

2. (Optional) Create expressions.

See (Optional) Creating Expressions.

3. (Optional) Create filters.

See (Optional) Creating Filters.

4. (Optional) Join records.

See (Optional) Joining Records.