Download Oracle Warehouse Builder User's Guide

Integrating with PeopleSoft
1.
Move the objects from the Available list to the Selected list.
The Import Wizard also enables you to choose whether you want to import tables
with foreign key relationships for each object that you choose to import. You can
select one of the following:
None: Import only the objects in the Selected list.
One Level: Import the objects in the Selected list and any tables linked to it
directly through a foreign key relationship.
All Levels: Import the objects in the Selected list and all tables linked to it through
foreign key relationships.
The foreign key level you select is the same for all tables selected for importing.
Selecting All Levels increases the time it takes to import the
metadata because you are directing the wizard to import tables that
are related to each other through foreign key constraints. Select this
option only if it is necessary.
Note:
2.
Click Next.
If you select One Level or All Levels, the Confirm Import Selection dialog box is
displayed.
Review this dialog box to ensure that you are selecting an appropriate number of
tables.
3.
Click OK.
The selected objects appear in the Selected pane of the Object Selection page.
4.
Click Next.
The wizard displays the Summary and Import page.
Reviewing Import Summary
The wizard imports definitions for the selected tables from the PeopleSoft Application
Server, stores them in the PeopleSoft source module, and then displays the Summary
and Import page.
You can edit the descriptions for each object by selecting the description field and
typing a new description.
Review the information on the Summary and Import page and click Finish.
The PeopleSoft Connector reads the table definitions from the PeopleSoft application
server and creates the metadata objects in the workspace.
The time taken to import PeopleSoft metadata to the workspace depends on the size
and number of tables and the connection between the PeopleSoft application server
and the workspace. Importing 500 or more objects could take one to three hours or
more, especially if you are connecting to servers in separate Local Area Networks
(LANs).
When the import completes, the Import Results dialog box displays. Click OK to finish
importing metadata.
Identifying Data Sources and Importing Metadata
4-17