Send data from OCI GoldenGate to Oracle GoldenGate

Learn to create a trusted connection and pull data from Oracle Cloud Infrastructure GoldenGate to Oracle GoldenGate.

Overview

Oracle Cloud Infrastructure GoldenGate enables you to send data from an OCI GoldenGate deployment to an on-premises or Marketplace Oracle GoldenGate deployment using a Target-initiated Path. The following steps guide you through how to set up and run this replication model using the latest Oracle GoldenGate Marketplace instance.

This quickstart is also available as a LiveLab: View the workshop.

Description of ggstoogg.png follows

Description of the illustration ggstoogg.png

Before you begin

To successfully complete this quickstart, you must have:

An existing source database
An existing on-premises or Marketplace Oracle GoldenGate deployment

Note: Download and load the sample data, if needed.

Task 1: Create OCI GoldenGate resources

Task 2: Create a trusted connection between Oracle GoldenGate and OCI GoldenGate

Take care in distinguishing the Oracle GoldenGate Service Manager from the OCI GoldenGate deployment console while you complete this task.

Download the root certificate for the OCI GoldenGate Deployment Console.

Note: You can download the root certificate from any browser. The following steps describe how to download the root certificate from a Chrome browser.
1. In your Chrome browser address bar, select the padlock icon, and then select Connection is secure.
2. Select Certificate is valid. A Certificate window opens.
3. In the Certificate window, select Certification Path, select DigiCert, and then select View Certificate.
4. Ensure that Issued reads DigiCert Global Root G2, select Details, and then Copy to File.
5. In the Certificate Export Wizard, select Next, select Base-64 encoded X.509 (.CER), and then select Next.
6. Select Browse to save the file to your local drive.
7. Select Next, and then select Finish.
Upload the certificate to the on-premises or Marketplace Oracle GoldenGate Service Manager:
1. Open the on-premises or Marketplace Oracle GoldenGate Service Manager in a browser window.
2. In the navigation menu (hamburger icon), select Certificate Management.
3. On the Certificate Management page, select Add CA Certificates (plus icon).
4. In the Add CA Certificate dialog, enter a Unique Name.
5. For Certificate PEM, copy and paste the contents of the certificate file you downloaded from Chrome, and then select Add.
Add a user with which Oracle GoldenGate can use to connect to OCI GoldenGate.
1. Launch the OCI GoldenGate deployment console from the deployment Details page.
2. In the navigation menu, select User Administration.
3. Select Add New User (plus icon), complete the fields as follows, and then select Submit:
  - For Authenticated By, select Password from the dropdown.
  - For Role, select Operator from the dropdown.
  - For Username, enter a name.
  - For Password, enter the password associated with this user. Verify the password.
4. Open the on-premises or Marketplace Oracle GoldenGate Administration Service, and then navigate to the Path Connections page.
5. Select Add Path Connection (plus icon), complete the fields as follows, and then select Submit:
  - Credential Alias: Enter an alias.
  - User ID: Enter the name of the user created in the previous step.
  - Password and Verify Password: Enter the password associated with this user.
6. Select Submit.

Task 3: Send data from OCI GoldenGate to Oracle GoldenGate

This task instructs you on how to create and run a Target-initiated Path to pull Trail files from OCI GoldenGate to Oracle GoldenGate.

In the OCI GoldenGate deployment console Oracle GoldenGate, add and run an Extract.
On the on-premises or Marketplace Oracle GoldenGate, add a Target-initiated Path with the following values, and then select Create and Run:
1. On the Source Options page:
  - For Source Host: Enter the OCI GoldenGate hostname in the following format, <domain>.deployment.goldengate.<region>.oci.oraclecloud.com:443.
  - For Trail Name: Enter a two-character name for the trail when it's received by OCI GoldenGate.
  - For Port Number: Enter the port number of the target deployment.
  - For Alias, enter the Credential Alias created in Task 2.
2. On the Target Options page:
  - For Trail Name: Enter a two-character name for the trail when it's received by Oracle GoldenGate.
  - For Target Authentication Method (wss Target Protocol only):
    - If using GoldenGate credential store, then select UserID Alias.
    - If using IAM credential store, then use OAuth.
On the on-premises or Marketplace Oracle GoldenGate, add a Replicat.