Home Services Partners Company

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.2j, which addresses the following security vulnerabilities:

  • "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)

Version 1.0.2j also addresses the following vulnerabilities resolved by earlier versions of the library.

Originally resolved by the version 1.0.2h upgrade:

  • "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)

Originally resolved by the version 1.0.2g upgrade:

  • "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)

Originally resolved by the version 1.0.2.f upgrade:

  • "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.2j; however, characteristics of this version may cause connections to certain databases to fail. To reduce the risk associated with upgrading to OpenSSL 1.0.2j, the driver also installs earlier versions of the OpenSSL library. Refer to the readme that is packaged with the product for a description of these libraries.

Amazon EMR Hive

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

Operating System Certifications
  • 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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

Amazon Redshift

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

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

Apache Hadoop Hive

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

Operating System Certifications
  • 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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

Apache Spark SQL

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

Operating System Certifications
  • 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))
Enhancements
  • 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 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 Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6

Operating System Certifications
  • 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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
  • Certified with Cloudera (CDH) 5.3, 5.4
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

Cloudera Impala

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

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

dBase

Progress DataDirect Connect for ODBC dBase Driver
Version 7.1.6 

Operating System Certifications
  • 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 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 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 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 Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6

Operating System Certifications
  •  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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
  • Certified with Hortonworks 2.3, 2.4* (driver version 07.15.0350 (B0261, U0178))
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

IBM DB2

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

Operating System Certifications
  • 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.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 Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6

Operating System Certifications
  • 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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
  • Certified with IBM BigInsights v3.0, v4.0, v4.1
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

IBM Informix

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

Operating System Certifications
  • 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 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 Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6

Operating System Certifications
  • 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))
  • 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 Hive 1.0.0, 1.1.0, 1.2.0
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

Microsoft SQL Server

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

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

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 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.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 

Operating System Certifications
  • 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 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.
Certifications
  • Certified with MongoDB 3.2* (driver version 08.01.0102  (B0131, U0094, J000198))
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 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.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.0 

NEW PROGRESS DATADIRECT FOR ODBC FOR ORACLE WIRE PROTOCOL DRIVER ON MAC OS X PLATFORMS
  • Operating System Certifications
    • Mac OS X v10.11.x (El Capitan)
    • Mac OS X v10.10.x (Yosemite)
    • Mac OS X v10.9.x (Mavericks)
  • Database Certifications
    • Oracle 12c R1 (12.1)
    • Oracle 11g R1, R2 (11.1, 11.2)
    • Oracle 10g R1, R2 (10.1, 10.2)
    • Oracle9i R2 (9.2)
    • Oracle8i R3 (8.1.7)
  • Features 
    • Support for iODBC Driver Manager, version 3.52.7 and higher
    • The driver supports all ODBC Core and most Level 1 functions.
    • The driver supports the core SQL 92 grammar.
    • The driver supports advanced security features, including SSL data 
        encryption and Kerberos authentication.
    • The driver supports failover.
    • The driver supports the storage of client information. 

Note: The 8.0 version of the Progress DataDirect for ODBC for Oracle Wire Protocol Drivers currently supports only on Mac OS X platforms. Windows and UNIX versions of the drivers are available as part of the 7.1.6 versions of the Connect and Connect64 products. 

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

Operating System Certifications
  • Certified with Debian Linux 7.11*, 8.5* (driver version 07.15.0159 (B0270, U0182))
  • Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.15.0159 (B0270, U0182))
  • 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
Changed Behavior
  • 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 Oracle Driver
Version 7.1.6 

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

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 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.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 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.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 Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6

Operating System Certifications
  • 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))
  • 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 HD Enterprise 2.1, 3.0
Enhancements
  • 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 driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to
    designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • 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.

PostgreSQL

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

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