New Apache Cassandra and DataStax ODBC and JDBC Connectors

New Apache Cassandra and DataStax ODBC and JDBC Connectors

December 19, 2016 0 Comments

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
Apache Cassandra Connectors for ODBC 8.0 and JDBC 6.0

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 Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next Top Data Sources & Data Connectivity Landscape [Infographic]
Comments
Comments are disabled in preview mode.