An Oracle NoSQL connection stores the information that Oracle GoldenGate uses to connect to an Oracle NoSQL Database. After the connection is created and validated, you can reuse it when configuring Replicat processes that deliver transactional data to Oracle NoSQL Database.

The connection stores the Oracle NoSQL client configuration, authentication information, and optional runtime settings independently of the Replicat configuration. This enables multiple Replicat processes to reuse the same validated connection.

Before creating an Oracle NoSQL connection, ensure that you have the following:

• An Oracle GoldenGate deployment.
• Network connectivity between the Oracle GoldenGate deployment and the Oracle NoSQL Database service.
• An Oracle NoSQL client configuration file.
• The OCI API private key associated with the Oracle NoSQL configuration.
• Oracle Cloud Infrastructure (OCI) credentials configured in the Oracle NoSQL client configuration file.
• Common runtime settings, such as the runtime classpath, if additional client libraries are required.
• Proxy information if the Oracle GoldenGate deployment accesses Oracle NoSQL Database through an HTTP proxy.

Use the Add Connection page to create an Oracle NoSQL 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 Oracle NoSQL.
5. In the Technology Settings section, provide the Oracle NoSQL connection information.
   Configure the following technology settings:

   • Configuration File – Upload the Oracle NoSQL client configuration file. Oracle GoldenGate for Distributed Applications and Analytics uses this file to obtain the connection information and Oracle Cloud Infrastructure authentication settings required to access the Oracle NoSQL Database service. This field is required.
   • Private Key File – Upload the Oracle Cloud Infrastructure API private key referenced by the Oracle NoSQL client configuration file. Oracle GoldenGate for Distributed Applications and Analytics uses this key to authenticate with Oracle Cloud Infrastructure. This field is treated as sensitive information.

   Note:

   Ensure that the uploaded private key matches the key referenced in the Oracle NoSQL client configuration file.
6. Configure Common Settings, if additional runtime configuration is required.

   Configure the following common settings:

   Classpath – Specifies the runtime classpath used to load the required Oracle NoSQL client libraries. You can use Dependency Downloader to download client libraries

   Note:

   • Download the supported Oracle NoSQL client libraries by using the Dependency Downloader for Oracle NoSQL.
   • Configure the runtime classpath to reference the downloaded client libraries before starting the Replicat process.
7. (Optional) Configure Proxy Settings if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses Oracle NoSQL Database through an HTTP proxy.

   Configure the following proxy settings:

   • Proxy URL – Specifies the URL or host name of the proxy server used to access Oracle NoSQL Database.
   • Proxy Port – Specifies the port number of the proxy server.
   • Proxy Username – Specifies the user name for proxy authentication, if required.
   • Proxy Password – Specifies the password for proxy authentication. This field is treated as sensitive information.
   • Truststore – Specifies the Java truststore file that contains the certificate authority (CA) certificates 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 used for client authentication, when required.
   • Keystore Password – Specifies the password associated with the keystore.
   • SSL Key Password – Specifies the password protecting the private key stored in the keystore when it differs from the keystore password.

     Note: Configure the proxy and SSL settings only if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses Oracle NoSQL Database through a proxy that requires authentication or TLS. If the deployment has direct network connectivity to Oracle NoSQL Database, leave the Proxy Settings blank.

8. Click Submit.
9. On the DB Connections page, click DBLOGIN to validate the connection.

   Note: A successful DBLOGIN validates only the saved connection information. It does not validate the Replicat configuration or Oracle NoSQL Handler configuration. After successful validation, the connection is available for selection during Replicat creation.

After the Oracle NoSQL connection has been successfully validated:

1. Create or edit a Replicat.
2. Select Oracle NoSQL as the target technology.
3. Select the validated Oracle NoSQL connection.
4. Complete the remaining Replicat configuration.
5. Create and start the Replicat.

Oracle GoldenGate for Distributed Applications and Analytics uses the selected connection to establish communication with Oracle NoSQL during Replicat execution.