DataStax Enterprise

Progress DataDirect for ODBC for Apache Cassandra Driver

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 8.0 

Certifications

• Certified with Red Hat Enterprise 8.0*
  Driver version 08.00.0101 (B0377, U0256)
• Certified with OpenJDK 11*
  Driver version 08.00.0101 (B0377, U0256)
  
• Certified with OpenJDK 8*
  Driver version 08.00.0101 (B0377, U0256)
• Certified with Red Hat Enterprise 7.3*
  Driver version 08.00.0074 (B0238, U0156)
• Certified with Windows Server 2016*
  Driver version 08.00.0074 (B0238, U0156)
• Certified with DataStax Enterprise 5.0
• Certified with DataStax Enterprise 4.7 and 4.8
• Certified with Apache Cassandra 3.0 and 3.7
• Certified with Apache Cassandra 2.0, 2.1, and 2.2

Enhancements

• The driver has been enhanced to support the Duration data type, which maps to the SQL_VARCHAR ODBC type. Currently, the Duration type is supported only in simple columns, and not in Collection types.*
• The Driver Manager for UNIX/Linux has been enhanced to support setting the Unicode encoding type for applications on a per connection basis. By passing a value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your application can specify the encoding at connection. This allows your application to pass both UTF-8 and UTF-16 encoded strings with a single environment handle.
  The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8 and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.
  This enhancement is available in build 08.02.0449 of the driver manager.

Changed Behavior

• The following Windows platforms have reached the end of their product lifecycle and are no longer supported by the driver*:
  • Windows 8.0 (versions 8.1 and higher are still supported)
  • Windows Vista (all versions)
  • Windows XP (all versions)
  • Windows Server 2003 (all versions)

Features

• Supports SQL read-write access to Apache Cassandra data sources.
• Supports CQL Binary Protocol.
• The driver supports the core SQL-92 grammar.
• The driver supports all ODBC Core functions and some Level 1 and Level 2 features.
  
• Supports user id and password authentication.
• Supports Cassandra data types, including the complex types Tuple, user-defined types, Map, List and Set.
• Generates a normalized view of Cassandra data. Tuple and user-defined types are flattened into a relational parent table, while collection types are mapped as relational child tables.
• Supports Native and Refresh escape sequences to embed CQL commands in SQL-92 statements.
• Supports Cassandra's tunable consistency functionality with the ReadConsistency and WriteConsistency connection options. 
  
• Supports the handling of large result sets through the FetchSize, NativeFetchSize, and ResultMemorySize connection options.
• Supports applications that do not support unbounded data types through the ASCIISize, DecimalPrecision, DecimalScale, VarintPrecision, and VarcharSize connection options.