Generating PeopleSoft Parameter File Input

Prior to creating and editing the Oracle GoldenGate configuration files, you need to generate PeopleSoft-specific input parameters for the Oracle GoldenGate parameter files.

To generate PeopleSoft-specific Oracle GoldenGate parameter files:

1. Open the following SQL script in your SQL editor or text editor:

   PS_HOME/scripts/psggconfiggenerateparmfilelists.sql.

2. Modify the following variables:

   • Modify all occurrences of <OWNER> to reflect the access ID for the database.

   • Modify all occurrences of <PATH> to reflect the script output directory path (as in, /data1/PT862/scripts/ or c:\temp\).

     Note:

     The ending slash is mandatory for the path.

3. Save your changes to the SQL file.

4. Log into SQL*Plus using your PeopleSoft access ID.

5. Run the psggconfiggenerateparmfilelists.sql script.

6. Verify that these files appear in the output directory:

   • PSGGconfiggenerateparmfilelists.log

   • PSGGgeneratetableexcludes.txt

   • PSGGgeneratetrandatadeletes.txt

     Note:

     You will add the output from the .txt files to the appropriate Oracle GoldenGate parameter files manually.