How to connect a PeopleSoft schema to ODI

In addition to my post of yesterday, I found out how to read PeopleSoft table definitions into the Topology manager of ODI.

After creating the SQL Server 2005 Data Server create a new Physical Schema specifying your PeopleSoft database (for instande HRMS9 for a HR 9.0 environment) and the owner of the schema (= dbo for SQL Server). In the Context tab give the Logical schema a logical name.

To actually load table definitions you can use furtheron for integration, start the ODI Designer.

Go to the Models tab and create a new Model, for instance HRMS9_EMPLID_DATA if you want to load all EMPLID related tables into a model. On the definition tab of the Model specify the Logical schema created in the Topology Manager. In the next tab (Reverse) you can specify the objects (for instance tables, views etc) you want to load. Now go to the Selective Reverse tab and select the checkbox ‘Objects to Reverse’. A list of all available tables and views from the PeopleSoft HRMS9 database will appear. Just select the ones you want to use and press the Reverse button. The selected objectdefininitions will be loaded into the model.

 Viewed 2902 times by 1226 visitors

Posted by: Frank Kortekaas (8 post(s)).