PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Alternatives Interfacing PS database to non-PS database

edited Jul 9, 2010 9:22AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
  Request :  Alternatives / Trends / Best Practice

 

Mission to accomplish :  On a monthly basis, push data from a Peoplesoft (PS) database into a non-PS database.  Both housed at the same organization; both Oracle platform.

 

Source database :  Peoplesoft, Oracle platform, System of record

Target database :  non-Peoplesoft, Oracle platform, auxiliary database

 

Both databases reside within the same organization. Databases would be linked via a database link.

 

Ideal : Run process from the Peoplesoft environment, editing against the non-PS data checking for existing data, determining whether to insert new rows or update existing rows in the non-PS system. In this case the non-PS database would be written to immediately within the process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center