New Apache Cassandra and DataStax ODBC and JDBC Connectors

December 19, 2016 Data & AI

This new release significantly expands The Progress DataDirect NoSQL and Big Data portfolio. What can it do for you?

Our latest release of Progress DataDirect for ODBC for Apache Cassandra Driver Release 8.0, along with our March release of the JDBC 6.0 connector, includes technology to normalize NoSQL data stored in Apache Cassandra. This technology for NoSQL databases is patented by Progress and is the first ODBC 4.0 specification feature to directly pass through native Cassandra Query Language (CQL) to the database.

Customer Use Case

In the data integration space, watch our webinar with Software AG, who distributes our Cassandra and DataStax JDBC connectors with the webMethods platform. Forrester Research recently named Software AG Leader of Leaders in The Forrester Wave™: Hybrid Integration For Enterprises, Q4 2016.

Key Takeaways for the Release

Our Cassandra ODBC and JDBC connectors will primarily be used for applications that support data management and analytics. To complete the analytics story, our Spark SQL connectors provide connectivity for more real-time analytics on Apache Cassandra.

Key highlights for the release include:

  • Drivers include Progress “Day One” support and Security Vulnerability Response policies
  • Drivers support connectivity to Cassandra 2.x and 3.x servers, including DataStax 4.6 and higher
  • Supports UDTs, tuples and other complex types
  • Driver automatically supports normalization to 1 level deep for Cassandra collection data types (list, set, map)
  • Fast performance accessing data using the Cassandra binary protocol
  • Support for executing native CQL via the new ODBC 4.0 spec defined {native} escape syntax

Technical Specs

Progress DataDirect for ODBC for Apache Cassandra Driver Version 8.0

(32 and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

ODBC Version Support

  • Compatible with ODBC 3.8 applications

    Database Support

  • Apache Cassandra, version 2.0 and higher
  • DataStax Enterprise, version 4.6 and higher

Operating System Support for Modern and Legacy Business Platforms

AIX (32 and 64-bit)

  • AIX, version 5.3 and higher HP
  • HP-UX IPF, 11i version 2.0 (B.11.23) and higher
  • HP-UX PA-RISC (32-bit only), 11i version 2.0 (B.11.23) and higher

Linux X86 (32 and 64-bit for AMD and Intel Processors)

  • CentOS Linux x86, version 4.0 and higher
  • Debian Linux x86, version 7.0 and higher
  • Oracle Linux x86, version 4.0 and higher
  • Red Hat Enterprise Linux x86, version 4.0 and higher
  • SUSE Linux Enterprise Server Linux x86, version 10 and higher
  • Ubuntu Linux x86, version 14.04 and higher

Solaris (32 and 64-bit)

  • Solaris x86 version 10 (Solaris 5.10) and higher
  • Solaris on SPARC, version 8 (Solaris 5.8) and higher

Windows (32 and 64-bit)

  • Windows (x86), version 7 and higher
  • Windows Server (x86), version 2003 and higher
  • Windows Vista (x86)
  • Windows XP Professional (x86), SP2 or higher

Driver/Client Software Requirements

  • Java SE 6 or higher

Get Started

Start using powerful ODBC or JDBC connectivity to Cassandra today. Leverage industry-standard ODBC to expose Cassandra data for enterprise grade standard connectivity for NoSQL. Try it all free for 30 days.

Try It Now

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Read next Progress DataDirect Now Connects to Denodo