PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.4
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

Step 2. Import Tree Attributes

You can add multiple instances of the source definition to a mapping. For each instance, import the attributes of a PeopleSoft tree. The Designer uses the tree attributes to associate a PeopleSoft tree with the instance of the definition.

To import tree attributes into a tree source definition:

In the Mapping Designer, create a mapping.

Drag a created tree source definition into the workspace.

Double-click the source definition and click the Properties tab.

The attributes are empty.

Click the Add button in the Import Vertical Tree Attributes field.

The Import Attributes from PeopleSoft dialog box appears.

Select the PeopleSoft ODBC connection.

To create or modify an ODBC data source, click the button next to the list of existing data sources to open the ODBC Administrator. Create the appropriate data source, and click OK. Then in the Import Tables dialog box, select the new ODBC data source.

Enter the database username and password to connect to the PeopleSoft metadata tables in the underlying database.

The username must have SELECT permission on the PeopleSoft metadata tables.

Optionally, enter the owner name of the PeopleSoft metadata tables.

If the database username is not the owner of the PeopleSoft metadata tables, enter the table owner name to view available records and trees.

Optionally, enter a filter criterion and how to apply the filter.

You can filter tree names using the Table option, but not business names. The Designer returns all trees if you apply the filter to business names.

Use an underscore (_) as a wildcard to represent a single character. Use the percent symbol (%) to represent multiple characters.

The Designer filters trees on the Trees tab. To filter tree names, enter capitalized text.

Optionally, enter a PeopleSoft language code.

To import metadata in the base language of the PeopleSoft system, leave this option blank. If you want the Designer to import language-sensitive metadata in a particular language, enter the corresponding PeopleSoft language code.

Click Connect.

Strict-level and loose-level trees appear on the Trees tab below the Trees folder.

Select the tree and click OK.

The Designer displays the tree attributes on the Properties tab. If there are attributes you do not want, click Revert to remove them.

The Import Vertical Tree Attributes field is empty after you import the tree attributes.

Click OK to close the Edit Transformations dialog box.

If the tree changes after you import the tree attributes, reimport or update the tree attributes accordingly.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Step 2. Import Tree Attributes

Step 2. Import Tree Attributes