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.

Related Topics

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 Receiver 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 ggs2ogg.png follows
Description of the illustration ggs2ogg.png

Before you begin

You must have the following in order to proceed:

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

Task 1: Create OCI GoldenGate resources

  1. Create an OCI GoldenGate deployment.
  2. Create connections to your source and target databases.
  3. Assign connections to the deployment.

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.
  1. 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, click the padlock icon, and then click Connection is secure.
    2. Click Certificate is valid. A Certificate window opens.
    3. In the Certificate window, click Certification Path, select DigiCert, and then click View Certificate.
    4. Ensure that Issued reads DigiCert Global Root G2, click Details, and then Copy to File.
    5. In the Certificate Export Wizard, click Next, select Base-64 encoded X.509 (.CER), and then click Next.
    6. Click Browse to save the file to your local drive.
    7. Click Next, and then click Finish.
  2. 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), click Certificate Management.
    3. On the Certificate Management page, click 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 click Add.
  3. Add a Credential that allows Oracle GoldenGate to connect to OCI GoldenGate.
    1. Launch the OCI GoldenGate Deployment Console from the Deployment Details page.
    2. Log in, and then access the Administrator page from the navigation menu.

      In 23ai, click User Administration in the left navigation.

    3. Click Add User, and then create a user that Oracle GoldenGate can use to connect to OCI GoldenGate. Assign this user the Operator role.
    4. Open the on-premises or Marketplace Oracle GoldenGate Adminstration Service, and then navigate to the Configuration page.
    5. Under the Database tab, click Add Credential, and then complete the following:
      • Credential Domain: Enter a name for this connection.
      • 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. Click Submit.

Task 3: Send data from OCI GoldenGate to Oracle GoldenGate

This task instructs you on how to create and run a target-initiated Receiver Path to pull Trail files from OCI GoldenGate to Oracle GoldenGate.
  1. In the OCI GoldenGate deployment console Oracle GoldenGate, add and run an extract.
  2. On the on-premises or Marketplace Oracle GoldenGate, add a receiver path with the following values, and then click Create and Run:
    1. Path Name: Enter a name for this path
    2. Source: Select the Extract created in step 1.
    3. Source Authentication Method: Use Basic Authentication to UserID Alias
    4. Source Host: Enter the OCI GoldenGate hostname in the following format, <domain>.deployment.goldengate.<region>.oci.oraclecloud.com:443

      Note:

      You can copy and paste the Console URL From your OCI GoldenGate deployment details page, and remove the https:// protocol and any trailing slashes (/).
    5. Source Trail Name: Enter the name of the OCI GoldenGate trail file to send to Oracle GoldenGate
    6. Source Domain: Enter the domain name you created in Task 2.
    7. Source Alias: Enter the alias name you created in Task 2.
    8. Target: Enter a two-character name for the Trail file when it is received by Oracle GoldenGate
  3. On the on-premises or Marketplace Oracle GoldenGate, add a replicat.

Task 4: Monitor performance

  1. Monitor performance.
  2. Manage Trail files.