This post outlines the procedure used to create a Distribution Path between two Oracle Cloud Infrastructure GoldenGate Cloud Service deployments.
In this example we are replicating from an Oracle Autonomous Database source to Snowflake target using two Oracle GoldenGate Cloud Service deployments.
Deployment (A) : Oracle (OGGORA)
Deployment (B): Big Data (OGGADLS)
The Extract process running on Deployment A will generate trail files which are sent by the Distribution Path to the Replicat process running in Deployment B.
The Replicat process running in Deployment B for Big Data will write avro files to an Azure Data Lake Storage container from where a Snowpipe process will process the avro files and write data to the target Snowflake database.
In the GoldenGate for Big Data deployment (B), we create a user ‘oggadls’ with the Operator role.
In GoldenGate for Oracle deployment (A), we create a credential alias ‘oggadls’ and domain ‘OGGADLS’ which will refer to the oggadls user created in the step above.
We next will need to create a GoldenGate connection to enable both the GoldenGate Deployments to communicate with each other.
In OCI console, go to the GoldenGate Connections menu.
Click on Create Connection.
Create a connection of type GoldenGate.
Select the GoldenGate Deployment for Big Data (Deployment B).
After the status of the connection shows ACTIVE, we need to assign the connection to the appropriate deployments.
Assign the connection to the GoldenGate Deployment for Oracle (Deployment A).
From the Deployment Console, Distribution Service, click on the ‘+‘ icon to add a distribution path.
Provide a name and description for the distribution path.
The source for the distribution path will be the Extract trail files.
Enter the trail file prefix name (in this case cd) and edit the generated source URL to add any sub-directory name.
Target protocol is wss and for the target field, enter the console URL (obtain it from OCI Deployments page) – remove the ‘https’ part of the URL and cut and paste the rest.
Port will be 443 and provide a directory name and target trail file name.
Note: this is where trail files which will be read by the Big Data Replicat will be written.
For the credential domain and name we enter the values OGDADLS and oggadls. Note this credential in Deployment A was created in one of the previous steps.
Click on Create Path.
Start the Distribution Path.
If we connect to the Big Data Deployment, we can see that a corresponding Receiver Path has been automatically created.