Apache Cassandra ODBC Driver

SQL on Cassandra made easy.
Overview
Features
Specifications
Documentation

The first ODBC 3.8 driver with direct SQL access to Apache™ Cassandra™ database clusters.

Apache Cassandra ODBC Driver Connector Diagramcassandra_logo Simba’s Cassandra ODBC Driver offers direct, universal ODBC 3.8 data access to Cassandra data stores via Cassandra’s native API, with no extraction. And the Simba Technologies Apache Cassandra ODBC Driver is the first to extend Cassandra data access to the Mac platform.

SQL for NoSQL: The Simba Technologies Cassandra ODBC Driver enables direct SQL query translation to the Cassandra Query Language (CQL), offering users unparalleled performance at scale. The built-in Collaborative Query Execution (CQE) passes down filters and aggregations to provide high-performance access to Cassandra.

Simba’s ODBC connector allows to you to make quick analytic insights and to leverage back end data source high performance calculation capabilities for your favorite BI client.

The Apache Cassandra database is the right choice when you need scalability without compromising performance. Cassandra’s support for replicating across multiple datacenters provides lower latency and higher availability for users. Complying with the latest ODBC 3.8 data standard, the driver adds important functionality such as asynchronous execution.

Product Highlights

  • Mac Support – Lets Mac users connect directly to Cassandra data clusters.
  • Enables SQL queries on NoSQL Cassandra data.
  • First ODBC 3.8-compliant Cassandra driver; takes advantage of features in the latest ODBC 3.8 standard, including asynchronous execution.
  • Cassandra 2.x Compatibility – Leverages the faster performance and improved security of Cassandra V2.x.
  • CQL Pass-through Capability – Delivers native CQL3 or CQL2 data access to clustered Cassandra data, enabling users to create queries in CQL or SQL.
  • Direct BI connectivity to data without extraction.
  • Adds aggregation and join capabilities for queries.
  • Supports dynamic schema generation via intelligent data sampling.

Product Features

  • ODBC 3.8-compliant, offers asynchronous execution
  • Direct SQL query translation to Cassandra Query Language (CQL)
  • Available for Mac, Windows, and Linux
  • Cassandra 2.x-compatible
  • Native CQL3 or CQL2 data access to clustered Cassandra data
  • Powerful SQL Connector allows users to define schemas on the fly on schema-less data
  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Microsoft Excel & Access, Tableau, and more
  • Passes down supported operations for increased performance
  • Provides full driver and query metadata
  • Enterprise support

Product Specifications

  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports Windows, Linux, and Mac platforms
  • Supports ANSI SQL-92
  • Supports dynamic schema generation via intelligent data sampling
  • Connects via Cassandra’s native API

Product FAQ

FREE Trial

ODBC

A password will be emailed to you.

Contact Sales

+1 (604) 633-0008
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar