Reference

Authentication SSL

Description

No description available [API reference]

Instructions

Cassandra / Scylla / Keyspaces with SSL. The bundle JAR still applies. Set JSSE truststore properties on the Bridge JVM when the cluster uses a private CA.

  1. Enable client-to-node encryption on the cluster (or use Amazon Keyspaces, which requires TLS on 9142).
  2. This Auth sets enablessl=true. Point javax.net.ssl.trustStore at a JKS that trusts the cluster CA if the default Java truststore is not enough.
  3. Create a database role. Paste user and password. For Keyspaces IAM, keep this tile and put access-key style credentials in user/password after switching the URL to the jdbc:cassandra:aws:// form -- do not add a second catalog tile.
  4. After Finish, replace hosts (e.g. MyHostName), keyspace (e.g. MyKeyspace), and local datacenter (for Keyspaces, local datacenter is the AWS region name).
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Apache Cassandra\cassandra-jdbc-wrapper-4.15.0-bundle.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 9042). 		YES 9042
Name: Keyspace

Label: Keyspace

Cassandra keyspace (e.g. MyKeyspace). 		YES MyKeyspace
Name: LocalDataCenter

Label: Local data center

Cassandra local datacenter (e.g. DC1). 		YES DC1
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. com.ing.data.cassandra.jdbc.CassandraDriver). 		com.ing.data.cassandra.jdbc.CassandraDriver
Name: EnableSsl

Label: Enable SSL

Enable TLS for this JDBC URL (e.g. Yes from the dropdown). 		true
Name Value
Notset
Yes true
No false
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.