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.

• Changes made to the connection string result in the use of new Ingress IPs for that connection and may require you to update firewall settings to prevent disruptions to your Extracts and Replicats.

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. Certain deployment types support specific connection types. See what’s supported for OCI GoldenGate. You can also assign connections 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.