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.

I’ve been busy trying to get Oracle Data Integration to work. First step after installation is to connect one or more data sources using the Topology Manager. Although ODI is a fairly new product, it only comes with a SQL Server 2000 driver.

To install the SQL Server 2005 JDBC driver and use it to connect to the database you need to follow the following steps: