How to Use DataStax ODBC Drivers

DataStax provides ODBC drivers for Business Intelligence (BI) tools to enable use cases with Apache Cassandra® and DataStax Enterprise (DSE). In 2015, a new CQL ODBC driver was released, followed by a SQL ODBC driver for Apache Spark™. Both drivers can be used independently with DSE. For BI and ETL tasks, users should adhere to the strengths of the technology being connected to and what's available. Cassandra is best suited for simple queries using CQL read and write fundamentals, while more complex reads, aggregations, joins, and ETL are better handled by Apache Spark. DSE offers enhanced capabilities over DataStax Basic due to its integration with both Cassandra and Spark, as well as additional features like AlwaysOn SQL and custom optimizations in the Spark engine.