Apache Cassandra ODBC Driver

SQL access made easy.
Overview
Features
Specifications
Documentation

The only ODBC driver available for direct SQL access to Apache™ Cassandra™ database clusters.

Apache Cassandra ODBC Driver Connector Diagramcassandra_logoSimba’s Cassandra ODBC driver with SQL Connector powers users to define schemas on the fly. With Cassandra data being schema-less, Simba’s ODBC driver provides the only direct, universal data access solution for Apache Cassandra. Connect direct to data without extraction and query capabilities by connecting straight to Cassandra’s native API. The built-in Collaborative Query Execution (CQE) passes down filters and aggregations to provide high-performance access to Cassandra. Simba’a 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.52 data standard, the driver adds important functionality such as Unicode and 32- and 64-bit support. This provides high-performance, distributed computing environments and delivering full application functionality and real-time analytic capabilities to users allowing any traditional, SQL-based BI or analytics tool can easily connect.

Product Highlights

  • Only direct, universal ODBC 3.52 data access solution for Apache Cassandra
  • Direct BI connectivity to data without extraction
  • Adds aggregation and join capabilities for queries
  • Supports dynamic schema generation via intelligent data sampling
  • Leverages Cassandra’s native filtering and aggregation capabilities

Product Features

  • 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, SAP Crystal Reports, 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.52 specification
  • Supports Unicode
  • Supports Windows
  • Supports ANSI SQL-92
  • Supports dynamic schema generation via intelligent data sampling
  • Connects via Cassandra’s native API

Product FAQ

FREE Trial

A password will be emailed to you.

Contact Sales

+1.604.633.0008 ext. 2
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar