1. Using Oracle GoldenGate on Oracle Cloud Marketplace
  2. Oracle GoldenGate Microservices on Oracle Cloud Marketplace
  3. Connecting to Data Sources
  4. Connecting to Db2 z/OS (On-Premises)

Connecting to Db2 z/OS (On-Premises)

You can use Oracle GoldenGate Microservices for Non-Oracle (Db2 z/OS) on Oracle Cloud Marketplace to remotely capture and apply data to Db2 z/OS database on-premises or across Oracle Cloud platforms. This allows you to enable replication between cloud services in a scalable fashion and centrally manage the replication processes.

Use Cases for Replication

Use Oracle GoldenGate Microservices for Non-Oracle (Db2 for z/OS) to replicate data between data resources in the following use cases:

  • Migrations
  • Data Distribution
  • Real-Time Data Warehousing
  • Operational Reporting

Prerequisites

Ensure that the following are set up before you begin replication:

  • Oracle GoldenGate Microservices for Non-Oracle (Db2 for z/OS)
  • Oracle DB2 Source or Target Database

To configure DB2 for replication, see: Prepare Db2 z/OS for Replication in Oracle GoldenGate Microservices Documentation.

Configuring Oracle Db2 z/OS for Replication

There is no default ODBC driver installed in Marketplace, you need to install your ODBC driver. Oracle GoldenGate Administration Service does not run upon the virtual machine creation. You need to start it up once ODBC driver is properly installed and configured. For more information, see Setting up for DB2 z/OS.

To prepare your Oracle Db2 z/OS database for replication, perform the tasks that are outlined in Prepare Db2 z/OS in Oracle GoldenGate Microservices Documentation.