This section provides an introduction and the methodology to work with the PeopleSoft Knowledge Modules in Oracle Data Integrator.
PeopleSoft Knowledge Modules
The Oracle Data Integrator Knowledge Modules for PeopleSoft provide integration and connectivity between Oracle Data Integrator and the PeopleSoft platform.
These KMs enable Data-level integration for PeopleSoft: Data extraction is performed directly on the PeopleSoft Business Objects tables. This method is read-only.
The Oracle Data Integrator KMs for PeopleSoft use mature integration methods for PeopleSoft, in order to:
Reverse-Engineer PeopleSoft data structures (Business Objects, tables, views, columns, keys, and foreign keys). Extract data from PeopleSoft using a data-level integration approach.
Oracle Data Integrator provides two Knowledge Modules (KMs) for handling PeopleSoft data.
RKM PeopleSoft ORACLE
RKM PeopleSoft MSSQL
Reverse-engineering knowledge module to retrieve the business objects, tables, views, columns, keys, and foreign keys from PeopleSoft. The database hosting the PeopleSoft tables is Oracle.
Reverse-engineering knowledge module to retrieve the business objects, tables, views, columns, keys, and foreign keys from PeopleSoft.The database hosting the PeopleSoft tables is Oracle.
The Oracle Data Integrator PeopleSoft knowledge modules are certified on the following platforms and versions:
Oracle PeopleSoft 8.x or higher
Installation and Configuration
There is no specific Oracle Data Integrator configuration for using the PeopleSoft KMs.
Working with PeopleSoft KMs
The Oracle Data Integrator PeopleSoft KMs enable read-only access to PeopleSoft data.
Knowledge Modules Reference Guide