Search

Thursday, July 30, 2009

Peoplesoft Integration between Oracle and SQL server

There has been a notion floating around that integration cannot be achieved between peoplesoft versions running on separate database platforms using Integration Broker (although Peoplesoft is designed to be platform independent). I procrastinated long enough before I tried the integration with the following set of environments. It works just fine.



FSCM: App Rel 8.4, Tools 8.45, DB Oracle 9i, app server on AIX 5.3 (unix)

HRMS: App Rel 9.0, Tools 8.49, DB SQL Server 2005, app server on Win'2003 server

Messages: PERSON_BASIC_SYNC, WORKFORCE_SYNC



Points to keep in mind here, though, as the Financials Release is lagging behind HRMS:

Convert the service operation version in the source from INTERNAL to the one that is used in the target. In the above example, Financials uses VERSION1 of PERSON_BASIC_SYNC.



External Alias Naming in the routing parameters should match the version of the target message.



But otherwise it is pretty straightforward.

No comments:

Post a Comment