Replicate data from Db2 for i to Autonomous Data Warehouse
JavaScript must be enabled to correctly display this content
Replicate data from Db2 for i to Autonomous Data Warehouse
Learn to replicate data from a Db2 for i system to Autonomous Data Warehouse
using OCI GoldenGate.
Before you begin
To successfully complete this quickstart, you must have:
- An existing on premises Db2 for i database, with users and privileges properly
configured.
- An existing Autonomous Data Warehouse instance in your Oracle Cloud
tenancy, with the GGADMIN user unlocked
- Network connection from your on premises system to your Oracle Cloud tenancy using
either FastConnect or VPN
- The appropriate VCN security rules to allow connection from your
private subnet to your on premises Db2 for i through TCP/IP
Task 1: Create the OCI GoldenGate
resources
First, create the deployments and connections:
- Create the source Db2 for i
deployment.
Tip:
- In the Create deployment panel, ensure you select Db2 for
i for type.
- It's recommended to use OCI IAM for the credential store to prevent
issues with log in and Distribution Paths.
- Create the target Oracle Database
deployment.
Tip:
In the Create
deployment panel, ensure you select
Oracle for
type.
- While the service creates the deployments, create the source and target
connections:
- Assign each connection to their respective
deployment.
Tip:
- Assign the Db2 for i connection to the Db2 for i
deployment.
- Assign the Autonomous Database connection to the Oracle
deployment.
- Assign the Oracle GoldenGate server connection to the Db2 for i
deployment. (This lets the Db2 for i deployment connect to the
Oracle deployment.)
- Assign the Db2 for i GoldenGate server connection to the Oracle
deployment. (This lets the Oracle deployment connect to the Db2 for
i deployment.)
- After the Db2 for i deployment is in an Active state, proceed to the next
task.
Task 2: Set up the source deployment
Before you begin, ensure your source Db2 for i deployment is in an
Active state.
- On the source Db2 for i deployment details page, click Launch
console.
- Add and run an Extract.
Note:
Ensure that you:
- Add transaction information (TRANDATA) to enable
supplemental logging.
- The Extract is running and
capturing source changes before you move on to the next step.
Task 3: Set up the target deployment
- From the target Oracle Autonomous Database deployment details page, click
Launch console.
- Add and run a Target-Initiated Path:
- Click Receiver Service
- On the Receiver Service page, click Add Target-Initiated Path (plus icon).
- Complete the Add Path fields with the following values:
- On the Path Information page, enter a
Path Name.
- On the Source Options page:
- For Source Protocol,
select wss.
- For Source Host,
click Copy next to the
Console URL value on the
source Db2 for i deployment details page, and then paste
the value.
Tip:
Ensure that you remove the
https://
and any trailing forward
slashes (
/
) from the URL.
- For Port Number,
enter
443
.
- For Trail Name, enter
the two-character name of the Extract created in Task 2.
- For Set Source Authentication Method,
select OAuth.
- Click Next.
- On the Target Options page, enter the two-character
name for the Target Trail, and then click
Next.
- On the Managed Options page, click
Create Path and Run.
- Verify that the Target-Initiated Path is created and
running.