A JDBC connection is a named connection definition that stores the authentication and connectivity information required to connect Oracle GoldenGate for Distributed Applications and Analytics (GG DAA) to a target system through a JDBC driver.

The connection definition includes:

• JDBC Connection URL
• JDBC Driver Class
• User Name and Password, when required
• Common Settings
• Proxy Settings, when required

Each connection is identified by a unique connection alias. During Replicat creation, the selected connection alias supplies the generated connection reference used by the Replicat configuration.

With Connection Config, JDBC connection information is securely stored in Oracle GoldenGate for Distributed Applications and Analytics, managed separately from the Replicat configuration, and can be reused across multiple Replicat processes.

Before creating a JDBC connection, obtain the JDBC connection details and the JDBC driver required for the target system. Ensure that the Oracle GoldenGate deployment has network access to the target and can load the required JDBC driver libraries.

For JDBC connection configuration, ensure that you have the following:

• JDBC Connection URL: The JDBC URL used to connect to the target system. This field is required and is treated as sensitive information.
• JDBC Driver Class: The fully qualified class name of the JDBC driver. This field is required.
• User Name (Optional): The user name required to authenticate to the target system.
• Password (Optional): The password associated with the user name. This field is treated as sensitive information.
• JDBC Driver Libraries: The required JDBC driver JAR files available to the Replicat runtime.
• Common Settings (Optional): Common connection properties, such as the runtime classpath, if required by the deployment.
• Network Connectivity: Network connectivity from the Oracle GoldenGate deployment to the target system.
• Proxy Information (Optional): Proxy configuration details if the deployment accesses the target system through an HTTP proxy.

Use the Add Connection page to create a JDBC connection.

Procedure

1. In the navigation menu, select DB Connections.
2. Click Add Connection.
3. In Connection Alias, enter a unique name for the connection.
4. From Technology Type, select JDBC.
5. In the Technology Settings section, provide the JDBC connection information.
   • Connection URL: Enter the JDBC connection URL for the target system.
   • Driver Class: Enter the fully qualified JDBC driver class name.
   • Username: Enter the user name required to authenticate to the target system, if applicable.
   • Password: Enter the password associated with the user name, if applicable. This field is treated as sensitive information.
6. Configure the following settings:
   • Common Settings: if additional runtime configuration is required.
   • Classpath: Specify the full path to the JDBC driver JAR files required by the Replicat type. You can use Dependency Downloader to download supported client libraries.
7. (Optional) In the Proxy Settings section, configure proxy information only if the Oracle GoldenGate deployment accesses the target through an HTTP proxy.
   • Proxy URL: Specifies the URL or host name of the proxy server.
   • Proxy Port: Specifies the proxy server port number.
   • Proxy Username: Specifies the user name for proxy authentication, if required.
   • Proxy Password: Specifies the password for proxy authentication.
   • Truststore: Specifies the Java truststore file used to validate the proxy server certificate, when required.
   • Truststore Password: Specifies the password associated with the truststore.
   • Keystore: Specifies the Java keystore file containing the client certificate and private key, when required.
   • Keystore Password: Specifies the password associated with the keystore.
   • SSL Key Password: Specifies the password protecting the private key when it differs from the keystore password.

   Note:

   If the deployment has direct network connectivity to the target system, leave Proxy Settings blank.
8. Click Submit to create the connection.
9. On the DB Connections page, run DB Login to validate the connection. Verify that the connection is successfully validated.
10. After successful validation, the connection is displayed in the DB Connections table and is available for selection during Replicat creation.

After the JDBC connection has been successfully validated, you can associate it with a Replicat.

1. Start the Create Replicat workflow.
2. Select JDBC as the target technology.
3. Select the validated JDBC target alias.
4. Review the generated connection reference.
5. Complete the remaining Replicat configuration.
6. Create the Replicat.

The selected connection alias supplies the generated connection reference in the Replicat configuration.

For example:

gg.handler.<handler>.connectionId=<GENERATED_CONNECTION_ID>
gg.handler.<handler>.connectionAlias=<JDBC_CONNECTION_ALIAS>