Before extracting data from a source, you need to import a source definition. Use the Designer to connect to the PeopleSoft metadata tables for PeopleSoft source metadata.

PowerExchange for PeopleSoft extracts source data from two types of PeopleSoft objects:

You cannot configure some metadata imported from PeopleSoft records in the Designer. Therefore, always import PeopleSoft records from the Sources > Import from PeopleSoft menu in the Source Analyzer.

Importing trees is different than importing records. The PowerCenter Integration Service needs to denormalize trees to extract data from them. Depending on how you want to denormalize a tree, you can choose to import or create a source definition for a tree.

When you use a PeopleSoft source definition in a mapping, you connect it to an Application Source Qualifier transformation. Use the Application Source Qualifier to define the record set you want from PeopleSoft sources by creating a filter or extract override. You can also use the Application Source Qualifier to join data from related sources.