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:

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 technology 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
      Oracle Autonomous JSON Database mongodb://<host>:<port>/?authMechanism=PLAIN&authSource=$external&ssl=true&retryWrites=false&loadBalanced=true

      Tip:

      Ensure that the trailing forward slash (/) is included after the port number if no additional options are passed in the Connection string.
    2. (Optional) If connection string includes credentials, enter the Username and Password.
    3. For MongoDB and Oracle JSON Collection connections, select Security settings:

      Note:

      MongoDB Atlas and Oracle Autonomous JSON Database technology types assume a CA-signed certificate and have no configurable security settings.
      • Plain: The TLS setting of the connection string is used unchanged. If tls=true is set in the connection string, then the server certificate validation is disabled.
      • TLS: Performs TLS validation of the server certificate against the provided certificate in the Certificate Authority Filepath (.pem) field. If one is not provided, then server certificate validation is disabled.
      • mTLS: Performs mutual mTLS validation of both server and client certificates. The user needs to provide both server and client certificates. You must provide a password if the client certificate is password-protected.
      Client and server certificates file paths are based on the container file system. It's recommended that you mount a local file system to the u02 container volume to pass the certificates to the container. To mount a local file system, add the following parameter to the docker run command: 
      -v [<host mount point>:]/u02
      For more information see Start and run the GoldenGate Studio docker image.
  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: