To use PeopleSoft with the Oracle Data Integrator PeopleSoft KM, you must:
Define the Topology.
Set up the Project
Perform a PeopleSoft Reverse-Engineering.
Use PeopleSoft datastores as sources in an integration interface
Defining the Topology
The steps to create the topology in Oracle Data Integrator, which are specific to projects using PeopleSoft KMs, are the following:
Connect to your master repository using Topology Manager.
Create a data server using the appropriate Oracle or Microsoft SQL Server technology. This data server represents the database instance that stores the PeopleSoft data.
Create a physical schema under this data server. This schema is, for example, the Oracle schema or the Microsoft SQL Server database that contains the PeopleSoft tables you want to reverse- engineer.
Create a logical schema for this physical schema in the appropriate context.
You can now perform a PeopleSoft Reverse-Engineering.
Note: The Oracle schema or the Microsoft SQL Server database storing the PeopleSoft tables should not be defined as a work schema in the physical schema definition. Moreover, this schema or database must not be used as staging area for an interface.
Setting up the Project
Import the following KMs into your Oracle Data Integrator project, if they are not already in your project:
RKM PeopleSoft ORACLE RKM PeopleSoft MSSQL
For more information about importing a KM, please refer to the Oracle Data Integrator User’s Guide.
Reverse-Engineering PeopleSoft Tables
The RKM PeopleSoft <database> is able to reverse-engineer PeopleSoft data structures at data level, enriching them with information retrieved from the PeopleSoft dictionary.
Data extraction is performed directly on the PeopleSoft Business Objects tables. This access method is read- only.
The reverse-engineering process returns the following information:
Business Objects as sub-models Business Objects tables as datastores with their associated columns and constraints Comments attached to the reversed tables and columns
To perform a PeopleSoft Reverse-Engineering:
Create a model based on the Oracle or Microsoft SQL Server Technology, and on the logical schema created when defining the Topology.
In this Model, select the Reverse tab and:
Select the RKM PeopleSoft ORACLE or RKM PeopleSoft MSSQL from the KM list.
Set the BUSINESS OBJECT RKM option as follows: Enter the Business Object code, for example CCM, DBI, or DPO.
Knowledge Modules Reference Guide