X hits on this document

357 views

0 shares

1 downloads

0 comments

83 / 131

The Business Object code corresponds to the PeopleSoft “Object Owner ID”. The different Object Owner IDs are listed in the PeopleSoft view: EO_BCOWNRID_VW. This field is used as a mask to filter the Business Objects to be reverse-engineered. This field must not be empty and must contain at least the percentage symbol (%).

See the Knowledge Module Options Reference section below for more details.

    • 4.

      Specify the reverse-engineering mask in the Mask field in order to select the tables to reverse. The Mask field, in the Reverse tab, filters reverse-engineered objects based on their name. The Mask field must not be empty and must contain at least the percentage symbol (%).

  • 3.

    Click Apply, and then click Reverse.

You can follow the reverse-engineering process in the Execution Log.

Note: The reverse-engineering process may take several minutes or longer depending on the number of Business Objects reverse-engineered.

At the end of the reverse-engineering process, the applications and tables are represented as sub-models and datastores. You can then use PeopleSoft as a source in an integration interface.

Using PeopleSoft as a Source in an Integration Interface

After performing a reverse-engineering using the RKM PeopleSoft <database>, you can use PeopleSoft data tables as a source of an integration interface to extract data from the PeopleSoft database and integrate them into another system (Data warehouse, other database...). Using PeopleSoft as a source in these conditions is identical to using an Oracle or Microsoft SQL Server datastore as a source in an integration interface. The Generic SQL, Oracle Database or Miscrosoft SQL Server KM%s can be used for this purpose.

Knowledge Module Options Reference RKM PeopleSoft ORACLE and RKM PeopleSoft MSSQL

Option

Values

BUSINESS OBJECT

String,

Default is: %

Mandatory

Yes

Description

Business Object name.

Mask used to filter the Business Objects to be reverse- engineered. '%' returns all the Business Objects.

The Business Object is corresponding to the PeopleSoft "Object Owner ID"

You will find the different Object Owner ID in the PeopleSoft view: EO_BCOWNRID_VW. Some tables do not have an Object Owner ID listed in this view. These tables are reverse-engineered in the default Business Object (sub-model) named “NA”.

Knowledge Modules Reference Guide

83/131

Document info
Document views357
Page views360
Page last viewedMon Dec 05 14:55:58 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments