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, select Clone.

3. Select 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. Select Edit

2. In the Edit Connection panel, review the connection settings, make your updates, and then select 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. Select 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, select Delete.

3. In the Delete connection dialog, confirm that you want to delete the connection, and then select 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 AI Database and Exadata Database Connection

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

1. Select Oracle AI 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. Select Test Connection to confirm if the connection is successfully working.

Test Oracle Autonomous AI Database Connection

Follow these simple steps to test Oracle Autonomous AI Database connection.

1. In Home page select Create Connection. Fill in connection name, optional description and Technology Types.

2. Select Oracle Autonomous AI 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 AI Database.

4. After filling in the details, select Test Connection to verify the connection.

Test MySQL Database Connection

Follow these simple steps to test MySQL Database connection.

1. In Home page, select Create Connection. Fill in connection name, optional description and technology type. Select any MySQL Database, from the Technology Type dropdown.

2. On the Connection Details page, complete the fields as follows, then select Next:

   • Enter Username and Password for the GoldenGate Studio admin user.

   • Enter the Hostname, Port, and Database Name.

   • Enter SSL Details. From the Security Protocol dropdown menu, select one of the following options: plain or TLS.

3. Select Test Connection to confirm if the connection is successfully working.