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

The connection stores the Cassandra cluster configuration, authentication settings, security configuration, and optional runtime settings independently of the Replicat configuration. This enables multiple Replicat processes to reuse the same validated connection.

Before creating a Cassandra connection, ensure that you have the following:

• An Oracle GoldenGate deployment.
• Network connectivity between the Oracle GoldenGate deployment and the Cassandra cluster.
• One or more Cassandra contact points.
• The local Cassandra datacenter name, if required by the Cassandra driver.
• Authentication credentials, if authentication is enabled.
• SSL/TLS certificates, Java TrustStore, or KeyStore files, if secure communication is required.
• The required Cassandra client libraries, if they are not already available in the deployment.
  • To download the required dependencies for Apache Cassandra, use the GG DAA Dependency Downloader

    {GGforDAA install}/DependencyDownloader/cassandra.sh 4.0.0

    Download the supported Apache Cassandra Java driver from:

    https://search.maven.org/artifact/com.datastax.oss/java-driver-core

  • If you are connecting to DataStax Enterprise (DSE), use:

    {GGforDAA install}/DependencyDownloader/cassandra_dse.sh 2.0.0

    Download the supported DSE Java driver from:

    https://search.maven.org/artifact/com.datastax.dse/dse-java-driver-core

  • After downloading the dependencies, configure the

    gg.classpath

    property in the Java Adapter properties file to include the downloaded libraries before starting the Replicat process.
• Configure common runtime settings, such as the runtime classpath, if additional libraries are required.
• Proxy information if the Oracle GoldenGate deployment accesses Cassandra through an HTTP proxy.

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

   • Contact Points – Specifies a comma-separated list of Apache Cassandra node addresses. This field is required.
   • Port – Specifies the Apache Cassandra native transport port. The default value is 9042.
   • Datacenter – Specifies the local Apache Cassandra datacenter that the driver uses to establish the connection.
   • Cassandra Configuration File – Specifies the Apache Cassandra configuration (

     cassandra.yaml

     ) file, when required by the deployment.
6. Configure the Authentication Settings section.
   Configure the following authentication settings:

   • Authentication Type – Specifies the authentication mechanism used to connect to the Apache Cassandra cluster.
   • Username – Specifies the Apache Cassandra user name. Configure this field when the selected authentication method requires user credentials.
   • Password – Specifies the password associated with the Apache Cassandra user name. This field is treated as sensitive information and is displayed as a password field.
7. Configure the Security Settings section, if secure communication is enabled.
   Configure the following settings when TLS is enabled:

   • Server Public Key – Specifies the server public key used for certificate-based authentication.
8. Configure the following settings when mutual TLS (mTLS) is enabled:
   • Server Public Key – Specifies the server public key used for certificate-based authentication.
   • Client Public Key – Specifies the client public key used for mutual TLS (mTLS) authentication.
   • Client Private Key – Specifies the client private key used for mutual TLS (mTLS) authentication.
   • Client Private Key Password – Specifies the password protecting the client private key.

   Note:

   Configure only the authentication and security properties required by the selected authentication method.
9. Configure Common Settings, if additional runtime configuration is required.

   Configure the following common settings:

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

   Note:

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

    • Proxy URL – Specifies the URL or host name of the proxy server used to access the Apache Cassandra cluster.
    • 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 the Apache Cassandra cluster through a proxy that requires authentication or TLS. If the deployment has direct network connectivity to the Apache Cassandra cluster, leave the Proxy Settings blank.
11. Click Submit.
12. 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 Apache Cassandra Handler configuration. After successful validation, the connection is available for selection during Replicat creation.

After the Cassandra connection has been successfully validated:

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