Create connections

Connections contain the network connectivity information for sources and targets.

What is a connection?

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

Supported connection types

Check the following list for specific technologies you can use as sources and targets in Oracle GoldenGate for MongoDB Migrations.

Supported source technologies Supported target technologies
  • MongoDB
  • MongoDB Atlas
  • Oracle JSON Collection Tables
  • Oracle Autonomous JSON Database

Create a connection

Learn to create a connection to MongoDB to use as a GoldenGate Studio source or target.

Watch this short video to learn how to create a database connection:

Tip:

Before you create a connection, ensure that you enable Archive Log Mode and restart your database.
To create a connection:
  1. From the GoldenGate Studio Home page, click Create connection.
  2. The Create connection configuration panel consists of three pages. On the General Information page, enter a Connection name, and optionally, a Description.
  3. Select a connection from the Connection type dropdown, and then click Next.
  4. On the Connections details page, complete the following fields, and then click Next:
    1. Enter the Connection string.

      If the username and password are included in the connection string, remove them from the connection string and enter them in the Username and Password fields provided. Ensure the connection string matches the expected format:

      Supported technologies Expected connection string format
      MongoDB mongodb://host1[:port1][...hostN[:portN]][/[defaultauthdb][?options]]
      MongoDB Atlas mongodb+srv://<host>/[?options]
      Oracle JSON Collection Tables mongodb://<host>:<port>/?authMechanism=PLAIN&authSource=$external&retryWrites=false&loadBalanced=true&tls={true|false}
      Oracle Autonomous JSON Database mongodb://<host>:<port>/?authMechanism=PLAIN&authSource=$external&ssl=true&retryWrites=false&loadBalanced=true
    2. (Optional) If connection string includes credentials, enter the Username and Password.

      Note:

      For MongoDB or Oracle JSON Collection connections, if TLS/SSL is set to true in your connection string, then only verified CA-signed certificates will be accepted. Self-signed certificates won't be validated.
  5. On the Confirmation page review a summary of your connection details, and then click Create.

Next steps

After you have source and target connections created in GoldenGate Studio, you can: