What's new in this release?

Support and Certifications

Changes Since 8.0.1 GA

• Driver Enhancements
  • The default version of the OpenSSL library has been upgraded to 3.5.6. As part of this upgrade, earlier version of the OpenSSL 3.0 library continues to be supported to provide the best protection for your data. The upgrade is available in the following OpenSSL library files:
    • Windows: ivopenssl.dll and ddopenssl.dll
    • Unix: ivopenssl.so and ddopenssl.so
  • The driver is now compiled with a Visual Studio 2022 compiler for the Windows platforms. As a result, you must have Microsoft Visual C/C++ runtime version 14.40.33810 or higher on your machine to run the driver.
  • The driver now supports describing Char and Varchar columns as either SQL_CHAR and SQL_VARCHAR types or SQL_WCHAR and SQL_WVARCHAR types in the metadata. You can use the new Use Unicode Char Types (UseUnicodeCharTypes) connection option to configure how the driver maps Char and Varchar columns. See Use Unicode Char Types for details.
  • The default version of the OpenSSL library has been upgraded to 3.0. As part of this upgrade, earlier versions of the OpenSSL library are no longer supported to provide the best protection for your data. The upgrade is available in the following OpenSSL library files: xxopenssl30.dll (for Windows) and xxopenssl30.so [.sl] (for UNIX/Linux).

    The OpenSSL 3.0 library uses a set of shared libraries called providers to implement different types of cryptographic algorithms. The driver supports the following OpenSSL 3.0 providers: FIPS and default. See TLS/SSL server authentication and TLS/SSL client authentication for details.

  • The driver has been enhanced to support the Windows certificate store for TLS/SSL server authentication. See TLS/SSL server authentication for details.
  • The driver has been enhanced to support TLS/SSL server authentication for the applications deployed in a serverless environment. The driver stores the TLS/SSL certificates in memory and lets applications use TLS/SSL server authentication without storing the truststore file on the disk. To use this enhancement, specify the content of the certificate in the refreshed Trust Store (Truststore) connection option or the new SQL_COPT_INMEMORY_TRUSTSTORECERT pre-connection attribute. See Truststore and Using SQL_COPT_INMEMORY_TRUSTSTORECERT for details.
  • A Password Encryption Tool, called ddencpwd, is now included with the product package. It encrypts passwords for secure handling in connection strings and odbc.ini files. At connection, the driver decrypts these passwords and passes them to the data source as required. See Password Encryption Tool (UNIX/Linux only) for details.
  • A Power BI connector is now included with the product package. You can use this connector to access your Hive data with Power BI. See Accessing data in Power BI (Windows only) for details.
  • The driver has been enhanced to include timestamp in the internal packet logs by default. If you want to disable the timestamp logging in packet logs, set PacketLoggingOptions=1. The internal packet logging is not enabled by default. To enable it, set EnablePacketLogging=1.
  • The new AllowedOpenSSLVersions option allows you to determine which version of the OpenSSL library file the driver uses for data encryption.
  • The driver has been enhanced to support ACID operations for Inserts, Updates, and Deletes on servers that are configured to use them. See Limitations on Apache Hive functionality for more information on limitations and restrictions.
  • The driver has been enhanced to support Apache ZooKeeper, which can be configured using the refreshed Host Name connection option and the new ZookeeperDiscovery and ZookeeperNamespace connection options. See Apache ZooKeeper, Host Name, Zookeeper Discovery, and Zookeeper Namespace for details.

    Also, the driver supports Kerberos authentication for Apache ZooKeeper. See Configuring Apache ZooKeeper for Kerberos authentication for details.

• Changed Behavior
  • The String Describe Type (StringDescribeType) connection option now supports describing String columns as SQL_LONGVARCHAR and SQL_VARCHAR as well, in addition to SQL_WLONGVARCHAR and SQL_WVARCHAR. To support this behavior, two new valid values have been added to the connection option: -1 (SQL_LONGVARCHAR) and 12 (SQL_VARCHAR). See String Describe Type for details.
  • The Allowed OpenSSL Versions (AllowedOpenSSLVersions) connection option has been deprecated.
  • The product no longer includes version 1.1.1 of the OpenSSL library. The library will reach the end of its product life cycle in September 2023 and will not receive any security updates after that. Note that continuing to use the library after September 2023 can potentially expose you to security vulnerabilities.
    Note: As a result of this change, when installing a new version of the product, the installer program will automatically remove version 1.1.1 of the library from the install directory, which will impact all the DataDirect ODBC drivers installed on a machine. Therefore, if you are using multiple drivers, upgrade all your drivers to the latest version.
  • The product no longer includes version 1.0.2 of the OpenSSL library. The library has reached the end of its product life cycle and is not receiving security updates anymore. Note that continuing to use the library could potentially expose you to security vulnerabilities.
    Note: As a result of this change, when installing a new version of the driver, the installer program will automatically remove version 1.0.2 of the library from the install directory.
  • The crypto protocol versions prior to TLSv1 are no longer supported.

Changes for 8.0.1 GA

• Driver Enhancements
  • The driver has been enhanced to support HTTP mode, which allows you to access Apache Hive data stores using HTTP/HTTPS requests. HTTP mode can be configured using the new Transport Mode and HTTP Path connection options. See HTTP mode, Transport Mode, and HTTP Path for details.
  • The driver has been enhanced to support session cookie based authentication for HTTP connections. Cookie based authentication can be configured using the new Enable Cookie Authentication and Cookie Name connection options. See Enable Cookie Authentication, and Cookie Name.
  • The driver has been enhanced to support HTTP connections to Apache Knox gateways. See Apache Knox for details.
  • The new Array Insert Size connection option provides a workaround for memory and server issues that can sometimes occur when inserting a large number of rows that contain large values. See Array Insert Size for details.
• Changed Behavior
  • The Array Size (ArraySize) connection option has been renamed Array Fetch Size (ArrayFetchSize). The ArraySize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product. See Array Fetch Size for details.

Changes for 8.0.0 GA

• Driver Enhancements
  • 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. See Min Long Varchar Size for details.
  • 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. See Varchar Threshold for details.
  • 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. See Max String Size for details.
  • 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. See Catalog Mode for details.
  • 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.

  • Refer to Character encoding in the odbc.ini and odbcinst.ini files in Progress DataDirect for ODBC Drivers Reference for details.

• Changed Behavior
  • 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. See Catalog Mode for details.
  • 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. See Max String Size for details.
  • 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. See Authentication Method for details.
    Note: Specifying the legacy setting for enabling Kerberos (AuthenticationMethod=1) will return an error message at connection.
  • 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. See Crypto Protocol Version for details.
  • 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)

    See String Describe Type for details.