ODBC Connectors Release Notes History

This page presents the latest features of the Progress DataDirect for ODBC drivers, according to data source in alphabetical order. An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release. For release notes archives, click the appropriate data source on the sidebar. For fixes information, refer to the fixes.txt file in the product installation directory.

For JDBC connector release notes, see JDBC Connectors Release Notes History.

For All SSL-Enabled Drivers*

The drivers have been updated with OpenSSL library version 1.0.2k, which addresses the following security vulnerabilities:

  • Truncated packet could crash via OOB read (CVE-2017-3731)
  • BN_mod_exp may produce incorrect results on x86_64 (CVE-2017-3732)
  • Montgomery multiplication may produce incorrect results (CVE-2016-7055)

Version 1.0.2k also addresses the following vulnerabilities resolved by earlier versions of the library:

  • "Missing CRL sanity check" (CVE-2016-7052)
  • "OCSP Status Request extension unbounded memory growth" (CVE-2016-6304)
  • "SWEET32 Mitigation" (CVE-2016-2183)
  • "OOB write in MDC2_Update()" (CVE-2016-6303)
  • "Malformed SHA512 ticket DoS" (CVE-2016-6302)
  • "OOB write in BN_bn2dec()" (CVE-2016-2182)
  • "OOB read in TS_OBJ_print_bio()" (CVE-2016-2180)
  • "Pointer arithmetic undefined behaviour" (CVE-2016-2177)
  • "Constant time flag not preserved in DSA signing" (CVE-2016-2178)
  • "DTLS buffered message DoS" (CVE-2016-2179)
  • "DTLS replay protection DoS" (CVE-2016-2181)
  • "Certificate message OOB reads" (CVE-2016-6306)
  • "Padding oracle in AES-NI CBC MAC check" (CVE-2016-2107)
  • "EVP_EncodeUpdate overflow" (CVE-2016-2105)
  • "EVP_EncryptUpdate overflow" (CVE-2016-2106)
  • "ASN.1 BIO excessive memory allocation" (CVE-2016-2109)
  • "EBCDIC overread" (CVE-2016-2176)
  • "missing Memory allocation success checks in doapr_outch function in 
       crypto/bio/b_print.c" (CVE-2016-2842)
  • "Cross-protocol attack on TLS using SSLv2 (DROWN)" (CVE-2016-0800)
  • "memory issues in BIO_*printf functions" (CVE-2016-0799)
  • "Memory leak in SRP database lookups" (CVE-2016-0798)
  • "Double-free in DSA code" (CVE-2016-0705)
  • "Side channel attack on modular exponentiation" (CVE-2016-0702)
  • "Logjam" (CVE-2015-4000)
  • "SSLv2 doesn't block disabled ciphers" (CVE-2015-3197)
  • "BN_mod_exp may produce incorrect results on x86_64" (CVE-2015-3193)
  • "Certificate verify crash with missing PSS parameter" (CVE-2015-3194)
  • "X509_ATTRIBUTE memory leak" (CVE-2015-3195)

For more information on these vulnerabilities, refer to the corresponding OpenSSL announcements at https://www.openssl.org/news/openssl-1.0.2-notes.html.

By default, the drivers use library version 1.0.2k; however, characteristics of this version may cause connections to certain databases to fail. To reduce the risk associated with upgrading to OpenSSL 1.0.2k, the driver also installs earlier versions of the OpenSSL library. Refer to the readme that is included with the product for a description of these libraries.

Amazon EMR Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.

Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • Amazon Elastic MapReduce (Amazon EMR) 2.1.4, 2.24-3.1.4 , 3.2-3.3.1, 3.2-3.7
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

Amazon Redshift

Progress DataDirect for ODBC for Amazon Redshift Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0053 (B0259, U0174))
  • Certified with Windows Server 2016 (driver version 07.16.0114 (B0316, U0209))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0106 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0106 (B0302, U0201))
Enhancements
  • The driver is now compiled using Visual Studio 2015 for improved security.
  • Support for connecting to a proxy server through an HTTP connection. HTTP proxy support is configurable with five new connection options: Proxy Host, Proxy Mode, Proxy password, Proxy Port, and Proxy User.  
  • The driver has been enhanced to support the TimestampTZ data type.
  • The new Fetch TSWTZ as Timestamp option allows you to determine whether the driver returns column values of the TimestampTZ data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.
  • The driver has been enhanced to support the HOUR, MINUTE, MONTH, QUARTER, SECOND, WEEK, and YEAR ODBC functions for improved support of third-party applications such as Tableau.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.  Refer to the Windows Quick Start for details.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • Changed Behavior
    • The default value for Crypto Protocol Version has been updated to

      TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.

Apache Cassandra

Progress DataDirect for ODBC for Apache Cassandra Driver
Version 8.0

Operating System Certifications
  • 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))
Certifications
  • Certified with Apache Cassandra 3.0 and 3.7
  • Certified with Apache Cassandra 2.0, 2.1, and 2.2
  • Certified with DataStax Enterprise 5.0
  • Certified with DataStax Enterprise 4.7 and 4.8
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.

Apache Hadoop Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • The new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.

Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

Apache Spark SQL

Progress DataDirect for ODBC for Apache Spark SQL Wire Protocol Driver
Version 8.0.2

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.01.0169 (B0259, U0174))
  • Certified with Windows Server 2016* (driver verision 08.01.0144 (B0239, U0156))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 08.01.0088 (B0138, U0095))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 08.01.0088 (B0138, U0095))
Certifications
  • Certified with Spark SQL 2.0* (driver verision 08.01.0144 (B0239, U0156))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.

Clipper

Progress DataDirect Connect for ODBC dBase Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Windows Server 2016 (driver version 07.14.0035 (b0053, U0105, F0038)
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.14.0035 (b0053, U0105, F0038))  
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

Cloudera CDH Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Cloudera (CDH) 5.11, 5.12* (driver version 08.00.0081 (B0241, U0158))
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
  • Certified with Cloudera (CDH) 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.

Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • Cloudera's Distribution Including Apache Hadoop (CDH) 4.0, 4.1, 4.2, 4.5, 5.0, 5.1, 5.2, 5.3
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

Cloudera Impala

Progress DataDirect Connect XE and Connect64 XE for ODBC Impala Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0296 (B0319, U0212))
  • Certified with Windows Server 2016* (driver version 07.16.0296 (B0319, U0212))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.15.0261 (B0251, U0174))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.15.0261 (B0251, U0174)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Certifications
  • Certified with Cloudera Impala Server 2.2*, 2.3*, 2.4*, 2.5*, 2.6*
  • Certified with Apache Sentry for Impala 1.1 and higher. Sentry enables administrators to control access to data and metadata stored on an Hadoop cluster by defining user roles and permissions.

Enhancements
  • Support for Kerberos Authentication.
  • Support the Char, Decimal, and Varchar data types when connected to Impala 2.0 and higher.
  • The ArraySize connection option has been refreshed to allow specifying the number of cells retrieved instead of rows. By determining the fetch size based on the number of cells, the driver can avoid out of memory errors when fetching from tables containing a large number of columns.
Changed Behavior
  • The AuthenticationMethod connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.

Database.com

Progress DataDirect Connect XE and Connect64 XE for ODBC Salesforce Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0233 (B0362, U0241))
  • Certified with Windows Server 2016* (driver version 07.16.0218 (B0325, U0217))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0210 (B0307, U0205))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0210 (B0307, U0205))
Certifications
  • Certified with Salesforce API Version 38* (driver version 07.16.0233 (B0362, U0241))
  • Certified with Salesforce API Version 33, 34.
Changed Behavior
  • The Salesforce driver has been updated to require a JVM that is version Java SE 7 or higher. This change is being implemented to maintain compatibility with Salesforce services as native TLS 1.0 support is disabled. For more information, refer to the readme in the product installation directory and the Salesforce announcement.*

DataStax

Progress DataDirect for ODBC for Apache Cassandra Driver
Version 8.0

Operating System Certifications
  • 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))
Certifications
  • 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
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.

dBase

Progress DataDirect Connect for ODBC dBase Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Windows Server 2016* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.14.0035 (b0053, U0105, F0038)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

Force.com

Progress DataDirect Connect XE and Connect64 XE for ODBC Salesforce Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0233 (B0362, U0241))
  • Certified with Windows Server 2016* (driver version 07.16.0218 (B0325, U0217))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0210 (B0307, U0205))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0210 (B0307, U0205))
Certifications
  • Certified with Salesforce API Version 38* (driver version 07.16.0233 (B0362, U0241))
  • Certified with Salesforce API Version 33, 34.
Changed Behavior
  • The Salesforce driver has been updated to require a JVM that is version Java SE 7 or higher. This change is being implemented to maintain compatibility with Salesforce services as native TLS 1.0 support is disabled. For more information, refer to the readme in the product installation directory and the Salesforce announcement.*

FoxPro

Progress DataDirect Connect for ODBC dBase Driver
Version 7.1.6 

Operating System Certifications
  •  Certified with Red Hat Enterprise 7.3* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Windows Server 2016* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.14.0035 (b0053, U0105, F0038))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.14.0035 (b0053, U0105, F0038)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

Hortonworks Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
  • Certified with Hortonworks (HDP) 2.4, 2.5
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.

Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • Hortonworks Distribution for Apache Hadoop 1.3, 2.0, 2.1, 2.2
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

IBM DB2

Progress DataDirect Connect and Connect64 for ODBC DB2 Wire Protocol Driver
Version 7.1.6

Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0275 (B0365, U0243))
  • Certified with DB2 12 for z/OS (driver version 07.16.0273 (B0364, U0243))
  • Certified with DB2 I 7.3* (DB2 UDB V7R3 for iSeries) (driver version 07.16.0262 (B0346, U0229))
  • Certified with Windows Server 2016* (driver version 07.16.0262 (B0346, U0229))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0253 (B0314, U0208))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0253  (B0314, U0208))  
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.
  • The new MinLongVarcharSize connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.

IBM BigInsights

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
  • Certified with IBM BigInsights v4.2
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.
Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • IBM BigInsights 3.0
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

IBM Informix

Progress DataDirect Connect and Connect64 for ODBC Informix Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0079 (b0106, U0218))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.15.0061 (b0081, U0150))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.15.0061  (b0081, U0150))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

The Progress DataDirect Connect for ODBC Informix Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.10.0004 (b0008, U0011))
  • Certified with Windows Server 2016* (driver version 07.10.0004 (b0008, U0007))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.12.0015 (b0028, U0051))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.12.0015 (b0028, U0051)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

MapR Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with MapR 5.2* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.

Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • MapR Distribution for Apache Hadoop 1.2, 2.0
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

Microsoft SQL Server

Progress DataDirect Connect and Connect64 for ODBC SQL Server Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  •  Certified with Red Hat Enterprise 7.3* (driver version 07.16.0361 (B0363, U0242))
  • Certified with Microsoft SQL Server 2016* (driver version 07.16.0292 (B0299, U0201))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0300 (B0314, U0208))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0300 (B0314, U0208))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Enhancements
  • The driver has been enhanced to support Always On Availability Groups. Introduced in SQL Server 2012, Always On Availability Groups is a replica-database environment that provides a high-level of data availability, protection, and recovery. To support this enhancement, the following updates have been made to the driver:*
    • The Host Name option has been updated to support the virtual network name (VNN) of the availability group listener as a valid value. To connect to an Always On Availability group, you must specify the VNN using this option.
    • The new Application Intent option allows you to control whether the driver requests read-only routing, thereby improving efficiency by reducing the workload on read-write nodes. For details, refer to the product readme. 
    • The new MultiSubnetFailover option allows the driver to attempt parallel connections to all the IP addresses associated with an availability group when the primary listener is unavailable. This offers improved response time over traditional failover, which attempts connections to alternate servers one at a time. For details, refer to the product readme. 
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

Progress DataDirect Connect and Connect64 for ODBC SQL Server Legacy Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3 (driver version 07.16.0076 (b0103, U0212))
  • Certified with Windows Server 2016* (driver version 07.16.0063 (b0102, U0211))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.14.0049  (b0059, U0115))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.14.0049 (b0059, U0115))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Certifications
  • Certified with Microsoft SQL Server 2016* (Windows driver version 07.16.0063 (b0102, U0211)) (UNIX/Linux driver version 07.16.0076 (b0103, U0212))

Microsoft Windows Azure SQL Database

Progress DataDirect Connect and Connect64 for ODBC SQL Server Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0361 (B0363, U0242))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0300 (B0314, U0208))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0300 (B0314, U0208))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

MongoDB

Progress DataDirect for ODBC for MongoDB Driver
Version 8.0.1 

Certifications
  •  Certified with Red Hat Enterprise 7.3* (driver version 08.01.0156 (B0251, U0167)
  • Certified with MongoDB 3.4* (driver version 08.01.0156 (B0251, U0167, J000272))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 08.01.0115 (B0167, U0120))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 08.01.0115 (B0167, U0120))
  • Certified with MongoDB 3.2* (driver version 08.01.0102  (B0131, U0094, J000198))
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
  • Certified with Windows 10.
Driver Enhancements 
  • The driver has been enhanced to resolve naming conflicts that can occur when exposing native objects using unquoted, uppercase identifiers (the default behavior). To avoid conflicts, the driver appends an underscore separator and integer (for example, _1) to identifiers that differ only by case. 
  • The DefaultVarcharSize config option has been enhanced to generate dynamic default lengths for VARCHAR columns when specifying a multiplier value (for example, 2x) for the option. When specifying a multiplier value, the default length for a VARCHAR column is determined by multiplying the value specified by the size of the largest value detected in that column. This results in a default length that is proportionate to the size of the data within the column, which can improve the memory efficiency within the driver and application. The default value for this option has been updated to 1.5x.

    In addition, you can further define the default length for VARCHAR columns by tuning the new MaxVarcharSize and MinVarcharSize config options. These options allow you to specify maximum and minimum size limits for the default length generated by the DefaultVarcharSize config option. When tuned for your data, MaxVarcharSize and MinVarcharSize can improve memory efficiency and avoid the undesired truncation of VARCHAR values.

  • The new KeywordConflictSuffix config option allows you to specify the suffix that is appended to object and field names that conflict with SQL engine keywords.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your MongoDB data with Tableau.
  • The driver uses the MongoDB aggregation framework to improve performance in the execution of SQL queries using LIMIT, ORDER BY, or TOP clauses.
  • The RELOAD MAP and REFRESH MAP commands have been added to the driver.
    • RELOAD MAP reloads the schema definition and associated files. RELOAD MAP updates your relational view of native data while the driver is connected to the data store. RELOAD MAP does not discover changes made to the native data store.
    • REFRESH MAP discovers native objects that have been added to the native data store since connection or since the last refresh. REFRESH MAP incorporates newly discovered objects into your relational view of native data. It also  incorporates any configuration changes made to your relational view by  reloading the schema definition and associated files. REFRESH MAP is an expensive query since it involves the discovery of native data.
  • The driver has been enhanced to improve the handling of large result sets and reduce the likelihood of out-of-memory errors through the modification of the Fetch Size connection option and the introduction of the Result Memory Size connection option.
  • The driver has been enhanced to further ensure data integrity when mapping inconsistent data types to a relational schema. 

MySQL

Progress DataDirect Connect and Connect64 for ODBC MySQL Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0205 (B0362, U0241))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0187 (B0314, U0208))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0187 (B0314, U0208))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

Oracle

Progress DataDirect and for ODBC Oracle Wire Protocol Driver
Version 8.0.1 

Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.01.2073 (B0259, U0174))
  • Certified with Oracle 12c R2* (12.2) (driver version 008.01.2067 (B0252, U0168))
  • Debian Linux 7.11, 8.5 (driver version 07.15.0159 (B0270, U0182))
  • Ubuntu Linux 14.04, 16.04 (driver version 07.15.0159 (B0270, U0182))
  • macOS  v10.12.x (Sierra)  (driver version 08.01.1068 (B0000, U1068))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • Support for the Oracle 12 and 12a authentication protocols, which provide improved security.
  • Support for returning implicit result sets from stored procedures.
  • The driver is now compiled using Visual Studio 2015 for improved security.
  • The new SDU Size connection option allows you to specify the size in bytes of the Session Data Unit (SDU) that the driver requests when connecting to the server.
  • The new Support Binary XML connection option enables the driver to support XMLType with binary storage on servers running Oracle 12c and higher. 
  • The new LOB Prefetch Size connection option allows you to specify the size of prefetch data the driver returns for BLOBs and CLOBs for Oracle database versions 12.1.0.1 and higher. With LOB prefetch enabled, the driver can return LOB meta-data and the beginning of LOB data along with the LOB locator during a fetch operation. This can have significant performance impact, especially for small LOBs which can potentially be entirely prefetched, because the data is available without having to go through the LOB protocol.
Changed Behavior
  • Support for the following platforms has been deprecated:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit) 
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The Enable N-CHAR Support connection option has been deprecated, and the driver behavior has been updated to always provide support for the N-types NCHAR, NVARCHAR2 and NCLOB. For compatibility purposes, the EnableNcharSupport attribute can still be manually specified for this release, but will be deprecated in subsequent versions of the product. 
  • The Enable Timestamp with Timezone connection option has been deprecated, and the driver behavior has been updated to always expose timestamps with timezones to the application. For compatibility purposes, the EnableTimestampwithTimezone attribute can still be manually specified for this release, but it will be deprecated in subsequent versions of the product.
  • The default value for the Data Integrity Level connection option has been updated to 1 (Accepted). By default, a data integrity check can now be made on data sent between the driver and the database server, if the server request or requires it. This change allows the driver to connect to servers requiring Oracle Advanced Security data integrity checks using the default configuration.
  • The default value for the Encryption Level connection option has been updated to 1 (Accepted). By default, encryption is now used on data sent between the driver and the database server if the database server requests or requires it. This change allows the driver to connect to servers requiring Oracle Advanced Security encryption using the default configuration. 

Progress DataDirect Connect and Connect64 Oracle Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0161 (B0365, U0243))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0276 (B0312, U0207))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0276 (B0312, U0207))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12

Oracle Service Cloud

Progress DataDirect for ODBC for Oracle Service Cloud Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 007.15.0115 (B0214, U0150))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.15.0115 (B0214, U0150))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.15.0115 (B0214, U0150))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Certifications
  • Certified with Oracle RightNow CX API version 1.2 against sites whose version is:

    • May 2016* (driver version 07.15.0132 (B0252, U0174, J000135))
    • May 2015
Enhancements
  • The new NamedIDBehavior config option allows you to determine whether the Name attribute of NamedID fields is exposed in the relational map. This option can be used to avoid "poor performing query" errors by reducing the size of result sets. For details, refer to the product readme file.*
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.

Pervasive.SQL (Btrieve)

Progress DataDirect Connect for ODBC Btrieve Driver Version 7.1.6

Operating System Certifications
  • Certified with Windows 10

Pivotal Greenplum

Progress DataDirect Connect XE and Connect64 XE for ODBC Greenplum Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0277 (B0364, U0243))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0250 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0250 (B0302, U0201)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.
  • Support for Kerberos Authentication.

Pivotal HDB (HAWQ)

Progress DataDirect Connect XE and Connect64 XE for ODBC Greenplum Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0277 (B0364, U0243))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0250 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0250 (B0302, U0201)) 
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Certifications
  • Certified with Pivotal HDB (HAWQ) 2.0* (driver version 07.16.0250 (B0302, U0201))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.
  • Support for Kerberos Authentication.

Pivotal HD Hive

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.0

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
Certifications
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
Enhancements
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • he new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The drivers have been updated with OpenSSL library version 1.0.2j.
Changed Behavior
  • Support has been deprecated for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • Pivotal Enterprise HD 2.0.1, 2.1
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

PostgreSQL

Progress DataDirect Connect and Connect64 for ODBC PostgreSQL Wire Protocol Driver
Version 7.1.6 

Operating System Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0280 (B0364, U0243))
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0251 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0251 (B0302, U0201))
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
Certifications
  • Certified with PostgreSQL 9.5*, 9.6* (driver version 07.16.0252 (B0304, U0205))
Changed Behavior
  • The OpenSSL library was upgraded to version 1.0.2k.*
  • The OpenSSL library was upgraded to version 1.0.2j.*
  • The OpenSSL library was upgraded to version 1.0.2h.*
  • The OpenSSL library was upgraded to version 1.0.2g.*
  • The OpenSSL library was upgraded to version 1.0.2f.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.
  • Support for Kerberos Authentication.
  • Progress OpenEdge

    Progress DataDirect Connect and Connect64 for ODBC Progress OpenEdge Wire Protocol Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0175 (B0296, U0197))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0175 (B0296, U0197))
    • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0175 (B0296, U0197))
    • Certified with Windows 10
    • Certified with Red Hat Enterprise 7.1
    • Certified with CentOS Linux 7.1
    • Certified with Oracle Linux 7.1
    • Certified with SUSE Enterprise Server 12
    Certifications
    • Certified with Progress OpenEdge 11.6* (driver version 07.16.0175 (B0296, U0197))
    Enhancements
    • The OpenSSL library was upgraded to version 1.0.2k.*
    • The OpenSSL library was upgraded to version 1.0.2j.*
    • The OpenSSL library was upgraded to version 1.0.2h.*
    • The OpenSSL library was upgraded to version 1.0.2g.*
    • The OpenSSL library was upgraded to version 1.0.2f.
    • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

    Salesforce Driver

    Progress DataDirect Connect XE and Connect64 XE for ODBC Salesforce Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0233 (B0362, U0241))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0210 (B0307, U0205))
    • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0210 (B0307, U0205))
    Certifications
    • Certified with Salesforce API Version 38* (driver version 07.16.0233 (B0362, U0241))
    • Certified with Salesforce API Version 33, 34.
    Changed Behavior
    • The Salesforce driver has been updated to require a JVM that is version Java SE 7 or higher. This change is being implemented to maintain compatibility with Salesforce services as native TLS 1.0 support is disabled. For more information, refer to the readme in the product installation directory and the Salesforce announcement.*

    SAP Sybase Adaptive Server Enterprise 

    Progress DataDirect Connect and Connect64 for ODBC Sybase Wire Protocol Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0209 (B0364, U0243))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.15.0158 (B0208, U0145))
    • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.15.0158 (B0208, U0145))  
    • Certified with Windows 10
    • Certified with Red Hat Enterprise 7.1
    • Certified with CentOS Linux 7.1
    • Certified with Oracle Linux 7.1
    • Certified with SUSE Enterprise Server 12
    Enhancements
    • The OpenSSL library was upgraded to version 1.0.2k.*
    • The OpenSSL library was upgraded to version 1.0.2j.*
    • The OpenSSL library was upgraded to version 1.0.2h.*
    • The OpenSSL library was upgraded to version 1.0.2g.*
    • The OpenSSL library was upgraded to version 1.0.2f.
    • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

    SAP HANA

    Progress DataDirect for ODBC for SAP HANA Wire Protocol Driver
    Preview Version

    Features
    • The driver supports SAP HANA 1.0.
    • The driver supports all ODBC Core, Level 1, and some Level 2 functions.
    • The driver supports the core SQL-92 grammar.

    SAP Sybase IQ

    Progress DataDirect Connect XE and Connect64 XE for ODBC Sybase IQ Wire Protocol Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0194 (B0362, U0241))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0210 (B0307, U0205))
    •  Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0210 (B0307, U0205)) 
    • Certified with Windows 10
    • Certified with Red Hat Enterprise 7.1
    • Certified with CentOS Linux 7.1
    • Certified with Oracle Linux 7.1
    • Certified with SUSE Enterprise Server 12

    Teradata

    Progress DataDirect Connect XE and Connect64 XE for ODBC Driver for Teradata
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0095 (b0116, U0241))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0078 (b0098, U0205))
    • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0078 (b0098, U0205)) 
    • Certified with Windows 10
    • Certified with Red Hat Enterprise 7.1
    • Certified with CentOS Linux 7.1
    • Certified with Oracle Linux 7.1
    • Certified with SUSE Enterprise Server 12
    Certifications
    • Certified with Teradata 15.10* (driver version 007.16.0078 (b0098, U0205))
    Enhancements
    • The driver has been enhanced to support the Number data type.

    Text Driver

    Progress DataDirect Connect for ODBC Text Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Red Hat Enterprise 7.3* (driver version 07.16.0095 (b0116, U0241))
    • Certified with Debian Linux 7.11*, 8.5* (driver version 07.14.0040 
        (b0060, U0116, F0043))
    • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.14.0040 (b0060, U0116, F0043))   
    • Certified with Windows 10
    • Certified with Red Hat Enterprise 7.1
    • Certified with CentOS Linux 7.1
    • Certified with Oracle Linux 7.1
    • Certified with SUSE Enterprise Server 12

    XML Driver

    Progress DataDirect Connect for ODBC XML Driver
    Version 7.1.6 

    Operating System Certifications
    • Certified with Windows 10
    patch-whats-new

    Read Next

    What's new