Alternatives Interfacing PS database to non-PS database
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.