Oracle Cloud Infrastructure Documentation

Explore connections

Learn about the different types of connections you can use with OCI GoldenGate and how to create them.

What is a connection?

A connection contains the connectivity details for a data source or target. Connections support database and non-database technologies such as Oracle, MySQL, PostgreSQL, Microsoft SQL Server, Kafka, Oracle Object Storage, OCI Streaming, and Oracle GoldenGate Distribution and Receiver Paths, to name a few.

WARNING:

You must only create and edit connections in the Oracle Cloud console. Refrain from creating or editing connections in the Credentials screen of the deployment console. Updates are automatically synced to the deployment from the Oracle Cloud console.

Before you create connections, it's recommended that you review OCI GoldenGate connectivity to learn how OCI GoldenGate connects to your sources and targets.

After you create a connection, you must then assign it to the deployment you want to use it with. Keep in mind that certain deployment types support specific connection types. You can assign a connection to a deployment that resides in a different compartment. To view the assignment from the connection details page, you must first change the compartment view.

Learn more about managing connections.

Supported connection types for data replication

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

Table 4-1 Connections supported by each deployment technology type

Technology 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)
  • OCI Object Storage (target only)
  • OCI Streaming
  • 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
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 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

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 HeatWave
  • 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

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

  • OCI Database with 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 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.

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 4-2 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.