What's supported

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

Related Topics

Deployment types

A deployment type is a replication use case that supports specific connection types. When you create a deployment you can choose from the following deployment types:

  • Oracle Database
  • Big Data
  • Microsoft SQL Server
  • MySQL
  • PostgreSQL

Supported connection types

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

Table - Connections supported by each deployment type

Deployment type Connection types supported
Oracle Database
  • Oracle Database 11.2.0.4, 12.1.0.2, and higher
  • Oracle Exadata 11.2.04, 12.1.0.2, and higher
  • Oracle Exadata Cloud Service
  • Oracle Exadata Cloud@Customer (remote capture and delivery)
  • Oracle Autonomous Transaction Processing
  • Oracle Autonomous Data Warehouse
  • Amazon RDS for Oracle 19 and higher

Note:

Ensure that you apply the latest patches for the databases you use with OCI GoldenGate as recommended by Oracle Support.
Big Data

The Big Data deployment type is available in OCI GoldenGate build 21.6.0.0.2_220714.0903_616 and higher.

  • Oracle Autonomous Database (target only)
  • Oracle Autonomous JSON Database (target only)
  • OCI Streaming
  • OCI Object Storage (target only)
  • Oracle WebLogic Java Message Service (JMS)
  • Oracle NoSQL (target only)
  • Azure Data Lake Storage (target only)
  • Azure Event Hubs
  • Azure Synapse Analytics (target only)
  • Azure Cosmos DB for MongoDB (target only)
  • Amazon S3 (target only)
  • Amazon MSK
  • 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
  • Apache Hadoop Distributed File System (HDFS) (target only)
  • MongoDB
  • Snowflake (target only)

Note:

Confluent Cloud private endpoints are not currently supported.
Microsoft SQL Server

The Microsoft SQL Server deployment type is available in OCI GoldenGate build 21.9.0.0.0_230120.0600_716 and higher.

  • Azure SQL Database (target only)
  • Azure SQL Managed Instance
  • Microsoft SQL Server
  • Amazon RDS for SQL Server
MySQL

The MySQL deployment type is available in OCI GoldenGate build 21.7.0.0.0_220820.1908_616 and higher.

  • MySQL Database Server 5.7, 8.0
  • OCI MySQL Database Service 8.0
  • Amazon Aurora MySQL 5.7
  • Amazon RDS for MariaDB 10.4, 10.5
  • Amazon RDS for MySQL 5.7, 8.0
  • Azure Database for MySQL 5.7, 8.0
  • MariaDB 10.4, 10.5
  • Google Cloud SQL for MySQL 8.0
PostgreSQL

The PostgreSQL deployment type is available in OCI GoldenGate build 21.7.0.0.0_220731.2140_663 and higher.

  • PostgreSQL Server 10, 11, 12, 13, 14
  • Amazon Aurora PostgreSQL 10, 11, 12, 13
  • Amazon RDS PostgreSQL 10, 11, 12, 13, 14
  • Azure Database for PostgreSQL 10, 11, 12, 13
  • Google Cloud SQL for PostgreSQL 10, 11, 12, 13, 14
Oracle GoldenGate GoldenGate microservices deployments

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

Learn more

For more information about what's supported and not supported, see: