Reference

Authentication Default

Description

No description available [API reference]

Instructions

Apache Cassandra JDBC (ING wrapper + DataStax Java driver bundle) from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. One tile covers Cassandra, Amazon Keyspaces, and ScyllaDB -- edit the JDBC URL after Finish rather than picking a second connector.

  1. Note contact points (host1, host2), native port (default 9042), keyspace, and local datacenter name (required by the default load-balancing policy).
  2. Create a Cassandra role if the cluster requires authentication. Paste user and password. Lab clusters sometimes allow empty credentials.
  3. The wizard downloads the GitHub bundle JAR (shaded with the DataStax driver). Do not use the thin Maven JAR alone.
  4. After Finish, replace hosts (e.g. MyHostName), port (e.g. 9042), keyspace (e.g. MyKeyspace), and local datacenter (e.g. DC1). The driver uses -- between hosts (not a comma).
  5. Amazon Keyspaces: use jdbc:cassandra:aws://cassandra.REGION.amazonaws.com:9142/keyspace?awsregion=REGION plus SSL/IAM as in the AWS Keyspaces Java-driver docs. ScyllaDB uses the same jdbc:cassandra:// URL on port 9042.
  6. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  7. 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: 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.