Configuring the Deployments

After creating the deployments, set up the database connection in the Oracle GoldenGate Service Manager.

You can use the Service Manager web-based UI or the Admin Client command line utility to set up the database connections. You must set up the connection on both the source and target.

Setting Up the Database Connection in Service Manager

1. Enter the URL in a browser for the Oracle GoldenGate Service Manager interface:

   http://<fully qualified host name>:<Service Manager port>.

   The host name is the name of the host where Service Manager is running, and the Service Manager port is specified in Section C of the deployment response files. The sample response files shown in this topic are oggca_source.rsp and oggca_target.rsp.

2. Enter the Service Manager credentials that you entered in the response files for the deployment.

   The Service Manager administrator credentials, ADMINISTRATOR_USER and ADMINISTRATOR_PASSWORD, are set in Section B of the response files. The administrator user in these examples is psft_sm.

3. On the Service Manager home page, select the link for the PeopleSoft deployment from the Deployment grid.

   The deployment name, which is PSFT_SOURCE in this example, is specified in Section A of the deployment response file. The services for the deployment are listed.

   This example illustrates the Deployments page in Oracle GoldenGate Service Manager.

   

4. Select the Administration Service link.

   This example illustrates the Services page in Oracle GoldenGate Service Manager.

   

5. Click the DB Connections plus sign (+) to open the Credentials page.

   Enter the following information:

   • Credential Domain — OracleGoldenGate (default)

   • Credential Alias — Enter an alias for the user ID.

   • User ID — Enter the oggadmin user that you created earlier.

   • Password and Verify Password — Enter the access ID password.

   This example illustrates the Credentials page.

   

Setting Up the Database Connection with the Admin Client

Use the Microservices Architecture Admin Client on the command line as an alternative to the web interface.

1. Start the Oracle GoldenGate Admin Client.

   $OGG_HOME/bin/adminclient

2. Connect to the deployment.

   adminclient>connect http://server.example.com:<Service Manager port> deployment <DEPLOYMENT_NAME> as <Service Manager User> password <Service Manager password>

3. Add the database credentials — user, password, alias, and domain.

   adminclient>alter credentialstore add USER "[e-mail]:1521/p" alias ggprime domain OracleGoldenGate PASSWORD "password";