Configuring PeopleSoft to Work with Oracle GoldenGate

To set up your PeopleSoft system to recognize both the source and target databases, as well to recognize the components and processes that will use the Oracle GoldenGate implementation, you need to:

• Specify the target database information in the application server and Process Scheduler configuration files.

• Configure read-only components.

• Configure read-only processes.

The procedures for performing these tasks are identical to those for setting up Oracle ADG.

Note:

Its important to understand the inherited behavior for marking a component as RO. If an initial component is marked as RO and this component calls other components, the called components will inherit the RO flag. That is, not only will the initial components SQL be redirected to the TARGET database, all the SQL from the called components will also be redirected to the TARGET database. Oracle has accounted for tables that may be involved with DML SQL operations from the supported components and processes listed in Understanding Oracle GoldenGate and PeopleSoft Environments by including those tables in the CREATEREMOTESYNONYM.SQL script. If additional components are marked RO and perform DML SQL operations on any tables not previously accounted for, then REMOTE SYNONYMS must be created for those tables as well.