Oracle Cloud Infrastructure Documentation

What's supported

Learn about OCI GoldenGate deployment types and the connection types they support.

Deployment types

When you create a deployment, you select a deployment type for your specific data management needs:

  • Data replication
  • Data transforms
  • Stream analytics

The following lists detail the source and target technologies supported by each deployment type.

Supported connection types for Data Replication

Connections supported in 23ai

Table 3-1 Connections supported by each deployment technology type

Technology type Connection types supported
Oracle Database
  • Oracle Database 19c, 21c, and 23ai
  • Oracle Exadata 19c, 21c, and 23ai
  • Oracle Exadata Cloud Service 19c, 21c, and 23ai
  • Oracle Exadata Cloud@Customer (remote capture and delivery) 19c, 21c, and 23ai
  • Oracle Autonomous Transaction Processing
    Note

    Use of Oracle Utilities services is available through this connection type.
  • Oracle Autonomous Data Warehouse
  • Amazon RDS for Oracle 19c and 21c
  • Oracle Database@Azure - Exadata
  • Oracle Database@Azure - Autonomous Database
  • Oracle Database@Google Cloud - Autonomous Database
  • Oracle Database@Google Cloud - Exadata
  • Oracle Database@AWS - Exadata
Note

Ensure that you apply the latest patches for the databases you use with OCI GoldenGate as recommended by Oracle Support.
Big Data
  • Oracle Autonomous Data Warehouse (target only)
  • OCI Object Storage (target only)
  • OCI Streaming
  • OCI Cache Cluster (target only)
  • Oracle Oracle Autonomous JSON Database (target only) 19c
  • Oracle JSON Collection
  • Oracle NoSQL (target only) 19.1, 19.3, 19.5, 20.1, 21.1
  • Oracle API for MongoDB (target only)
  • Oracle Oracle Weblogic JMS 1.1
  • Apache Kafka 2.4, 2.5, 2.6, 2.7, 2.8, 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6
  • Confluent Kafka, with or without Confluent Schema Registry, 7.5 or earlier
  • Amazon DocumentDB
  • Amazon MSK
  • Amazon Kinesis (target only)
  • Amazon Redshift (target only)
  • Amazon S3 (target only)
  • Apache Iceberg (target only)
  • Azure Data Lake Storage / Azure BLOB Storage (target only)
  • Azure Cosmos DB for MongoDB (target only)
  • Azure Event Hubs
  • Azure Synapse Analytics (target only) 10
  • Databricks (target only, requires OCI GoldenGate deployment build 23.6 and higher)
  • Elasticsearch Server (target only) 7.5,7.6,7.7,7.8, 7.9, 7.10, 7.11, 7.12, 7.13, 8
  • Google BigQuery (target only)
  • Google Cloud Storage (target only)
  • Google Pub/Sub (target only)
  • Hadoop Distributed File System (HDFS) (target only)
  • Microsoft Fabric Lakehouse (target only)
  • Microsoft Fabric Mirror (target only)
  • MongoDB
  • Redis (target only)
  • Snowflake (target only)
  • Snowflake Streaming (target only, requires OCI GoldenGate deployment build version 23.6 and higher)
Db2 for i
  • IBM Db2 for i 7.4, 7.5
Db2 for z/OS
  • IBM Db2 for z/OS 12, 13
Microsoft SQL Server
  • Amazon RDS for SQL Server 2016, 2017, 2019, 2022
  • Azure SQL Database (target only) 12.0
  • Azure SQL Managed Instance 12.0
  • Google Cloud SQL for SQL Server 2017, 2019, 2022
  • Microsoft SQL Server 2016, 2017, 2019, 2022
MySQL
  • HeatWave on OCI
  • MySQL Database Server 8.0, 9.x
  • HeatWave on AWS
  • Amazon Aurora MySQL 8.0
  • Amazon RDS for MariaDB 10.6, 10.11
  • Amazon RDS for MySQL 8.0
  • Azure Database for MySQL 8.0
  • MariaDB 10.6, 10.11
  • SingleStoreDB 8.1, 8.5, 8.7, and 8.9
PostgreSQL
  • OCI PostgreSQL 14, 15
  • PostgreSQL Server 13, 14, 15, 16, 17
  • Amazon Aurora PostgreSQL 13, 14, 15, 16
  • Amazon RDS for PostgreSQL 13, 14, 15, 16
  • Azure Cosmos DB for PostgreSQL 13, 14, 15, 16
  • Azure Database for PostgreSQL 13, 14, 15, 16
  • Google Cloud SQL for PostgreSQL 13, 14, 15, 16
  • Google AlloyDB for PostgreSQL 14, 15
Generic
  • GoldenGate

For more information on build versions, see OCI GoldenGate Versions.

Learn more

Connections supported in 21c

A connection contains the network connectivity details to a data source or target.

Table 3-2 Connections supported by each deployment technology type

Technology type Connection types supported
Oracle Database
  • Oracle Database 11.2.0.4, 12.1.0.2, 19c, and 21c
  • Oracle Exadata 11.2.04, 12.1.0.2, and higher
  • Oracle Exadata Cloud Service 11.2.0.4, 12.1.0.2, and higher
  • Oracle Exadata Cloud@Customer (remote capture and delivery) 11.2.0.4, 12.1.0.2, and higher
  • Oracle Database@Azure - Exadata 11.2.0.4, 12.1.0.2, and higher
  • Oracle Autonomous Transaction Processing
    Note

    Use of Oracle Utilities services is available through this connection type.
  • Oracle Autonomous Data Warehouse
  • Amazon RDS for Oracle 19 and higher
  • Oracle Database@Azure - Autonomous Database
  • Oracle Database@Google Cloud - Autonomous Database
  • Oracle Database@Google Cloud - Exadata
  • Oracle Database@AWS - Exadata
Note

Ensure that you apply the latest patches for the databases you use with OCI GoldenGate as recommended by Oracle Support.
Big Data
  • Oracle Autonomous Database (target only)
  • OCI Object Storage (target only)
  • OCI Streaming
  • OCI Cache Cluster (target only)
  • Oracle Oracle Autonomous JSON Database (target only)
  • Oracle NoSQL (target only)
  • Oracle Oracle Weblogic JMS
  • Apache Kafka 2.4, 2.5, 2.6, 2.7, 2.8, 3.0, 3.1, 3.2
  • Confluent Kafka, with or without Confluent Schema Registry, 7.1 or earlier
  • Snowflake (target only)
  • MongoDB
  • Amazon MSK
  • Amazon S3 (target only)
  • Amazon Redshift (target only)
  • Amazon Kinesis (target only)
  • Azure Data Lake Storage / Azure BLOB Storage (target only)
  • Azure Synapse Analytics (target only)
  • Azure Cosmos DB for MongoDB (target only)
  • Azure Event Hubs
  • Google BigQuery (target only)
  • Google Cloud Storage (target only)
  • Elasticsearch Server (target only)
  • Hadoop Distributed File System (HDFS) (target only)
  • Redis (target only)
Microsoft SQL Server
  • Azure SQL Database (target only)
  • Azure SQL Managed Instance
  • Microsoft SQL Server 2012, 2014, 2016, 2017, 2019, 2022
    Note

    Microsoft SQL Server 2022 is only supported in builds _802 and higher
  • Amazon RDS for SQL Server 2012, 2014, 2016, 2017, 2019
  • Google Cloud SQL for SQL Server 2017, 2019, 2022
MySQL
  • HeatWave on OCI
  • MySQL Database Server 5.7, 8.0
  • HeatWave on AWS (target only)
  • HeatWave on Azure (target only)
  • Amazon RDS for MySQL 5.7, 8.0
  • Azure Database for MySQL 5.7, 8.0
  • Amazon Aurora MySQL 5.7, 8.0
  • Google Cloud SQL for MySQL 8.0
  • Amazon RDS for MariaDB 10.4, 10.5
  • MariaDB 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.11
  • SingleStoreDB 7.8, 8.0
  • SingleStoreDB Cloud 7.9
PostgreSQL
  • OCI PostgreSQL 14
  • PostgreSQL Server 10, 11, 12, 13, 14, 15, 16
  • Amazon Aurora PostgreSQL 10, 11, 12, 13, 14, 15
  • Amazon RDS for PostgreSQL 10, 11, 12, 13, 14, 15, 16
  • Azure Cosmos DB for PostgreSQL 11, 12, 13, 14, 15 (target only)
  • Azure Database for PostgreSQL 10, 11, 12, 13, 14, 15, 16
  • Google Cloud SQL for PostgreSQL 10, 11, 12, 13, 14, 15
Generic
  • GoldenGate
  • Generic connection

For more information on build versions, see OCI GoldenGate Versions.

Learn more

Supported applications

OCI GoldenGate data replication supports various Oracle Utilities services through the Autonomous Transaction Processing connection type including:

  • Oracle Utilities Billing Cloud Service
  • Oracle Utilities Customer Care and Billing Cloud Service
  • Oracle Utilities Customer Cloud Service
  • Oracle Utilities Customer Cloud Service for Retail
  • Oracle Utilities Digital Asset Cloud Service
  • Oracle Utilities Market Settlements Management Cloud Service
  • Oracle Utilities Meter Solution Cloud Service
  • Oracle Utilities Work and Asset Cloud Service
  • Oracle Utilities Java Migration Cloud Service

For information on how to use these applications, see GoldenGate Replication in the Cloud Services Administration Guide.

Supported connection types for Data Transforms

See Supported Connection Types for a full list of connections that you can use with OCI GoldenGate Data Transforms.

Tip:

For each connection type used with OCI GoldenGate Data Transforms, you must create a Generic connection, and assign the connection to the Data Transforms deployment.

After assigning the Generic connection(s) to the Data Transforms deployment, launch the console from the deployment details page and log in. In the Data Transforms deployment console, create a connection for each data source using the Host name(s) provided for the Generic connection(s).

Supported connection types for Stream Analytics

Table 3-3 Connections supported by Stream Analytics

Source or Target Connection types supported
Sources
  • Oracle Autonomous Transaction Processing
  • Oracle Autonomous Data Warehouse
  • Oracle Database
  • OCI Streaming
  • MySQL Database Server 5.7, 8.0
  • Apache Kafka
  • Confluent Kafka
  • Coherence, Ignite, and Java Message Server within the Stream Analytics console
  • Oracle GoldenGate
Targets
  • Oracle Autonomous Transaction Processing
  • Oracle Autonomous Data Warehouse
  • Oracle Database
  • OCI Object Storage
  • OCI Streaming
  • Apache Kafka
  • Amazon S3, Azure Data Lake Storage, Coherence, Hadoop File Storage (HDFS), Ignite, Java Message Server, and MongoDB within the Stream Analytics console

For more information on build versions, see OCI GoldenGate Versions.

Supported connection types for Pipelines

OCI GoldenGate Pipelines currently supports Autonomous Database connections.