Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. 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.

]]> 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.

]]> Lists tables in MyKeyspace from system_schema. Use this in Power BI or a SQL Server Linked Server to confirm the catalog.

]]> Returns rows from MyKeyspace.users. Replace the keyspace and table. Works in Excel, SSRS, and Crystal Reports.

]]> Returns one partition. Cassandra requires a primary-key restriction for efficient reads.

]]> Reads with a non-key filter. Avoid on large tables in production; prefer a secondary index or a new table.

]]> Returns a column list instead of star. Prefer this in Linked Server views.

]]> Returns several partitions. Use in Azure Data Factory when you extract a known id set.

]]> Returns the first 100 rows of a partition in clustering order. Preview in Excel or Crystal Reports.

]]> Counts rows in MyKeyspace.users. On large tables this is expensive; prefer a counter table for dashboards.

]]> Aggregates per partition. CQL GROUP BY must follow the primary-key prefix.

]]> Lists keyspaces visible to this role. Confirm Amazon Keyspaces / Scylla catalogs the same way.

]]>