Manage Connections

Manage connections from the GoldenGate Studio user interface including steps to edit, clone, and delete connections.

View Connection Details

Select a connection from the Database connections page to view its details. On the Connection details page, you can:
  • View connection details such as:
    • Connection name, description, when it was created, and when it was last updated.
    • Database type, hostname, port, username, connector, and connection type.
    • Connection role (source or target).
  • Edit the connection details.
  • Validate the connection details.
  • Clone the connection.
  • Delete the connection.

Clone a Connection

Check the steps how to clone the database connection.

To clone a connection:
  1. On the Database Connections page, select the database connection to clone.
  2. On the Connections page, click Clone.
  3. Click Save changes.
For example, you can clone a production connection to a development/test environment and then in the test environment, you can modify the necessary details to maintain consistency and speed up deployment.

Edit a Connection

To edit a connection:
  1. On the Connections page, select a database connection to edit. Click Edit
  2. In the Edit Connection panel, review the connection settings, make your updates, and then click Next to progress though the Edit connection pages. You can edit details like Database connection name, description, Hostname, Port, Username, Password, Pluggable Database Service Name.
  3. Click Save changes.

Delete a connection

Before you delete a connection, ensure that the connection is not currently in use by an active pipeline.
To delete a connection:
  1. On the Database connections page, select the connection to delete. You're brought to the connection details page.
  2. On the connection details page, click Delete.
  3. In the Delete connection dialog, confirm that you want to delete the connection, and then click Delete.
The Database connections list is refreshed and the deleted connection removed. You cannot undo a delete operation.

Test a Connection

Learn why testing the connection is essential while creating the database connection.

Before you can design, deploy, or manage data replication solutions in Oracle GoldenGate Studio, it’s essential to verify that your configured database connections are functioning correctly. Testing the database connection ensures that GoldenGate Studio can successfully communicate with your source and target databases using the specified configuration and credentials. This step helps identify potential connectivity issues early, such as incorrect network settings, authentication problems, or configuration errors, thereby reducing troubleshooting time and ensuring a smooth development and deployment process.

Test Oracle Database and Exadata Database Connection

Follow these simple steps to test Oracle Database and Exadata Database Connection.

  1. Select Oracle Database or Exadata as the Technology Type.
  2. The next screen will show fields for username, password, hostname, port, and database Type. Enter the Hostname and Port Number for your Exadata database.
  3. Select the Database Type and provide the Pluggable database service name (PDB) if applicable.
  4. Click Test Connection to confirm if the connection is successfully working.

Test Autonomous Database Connection

Follow these simple steps to test Autonomous Database connection.

  1. In Home page click Create Connection. Fill in connection name, optional description and Technology Types.
  2. Select Oracle Autonomous Database as the Technology Type.
  3. The next screen will prompt you for the Wallet details. You will need to provide a username and password. You also need to add the Wallet File that contains the credentials and connection information of your Autonomous Database.
  4. After filling in the details, click Test Connection to verify the connection.