What's new in this release?

The highlights of this release are:

• Support for setting the value of undocumented connection options using the setup dialog for the following drivers on Windows:
  • Greenplum Wire Protocol
  • Impala Wire Protocol
  • Progress OpenEdge Wire Protocol
  • Sybase Wire Protocol
• 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.
• Greenplum driver enhancements
  • Support has ended for the DataDirect ODBC Data Source Administrator for Linux. As a result, the Linux ODBC Administrator will no longer be installed with the product. In addition, to avoid exposure to potential security vulnerabilities, the installer program will remove Linux ODBC Administrator files from existing installation directories during updates and new product installations.
  • 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 Allowed OpenSSL Versions (AllowedOpenSSLVersions) connection option has been deprecated as the driver currently supports only version 3.0 of the OpenSSL library.
  • 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.
  • The driver has been enhanced with the new Batch Mechanism (BatchMechanism) connection option, which specifies the preferred mechanism for executing batch insert operations. By setting Batch Mechanism to 2 (MultiRowInsert) or 3 (Copy), the driver can achieve substantial performance gains when performing batch inserts. The default setting is BatchMechanism=1. See Batch Mechanism for details.
  • The driver has been enhanced to support the following data types: Citext, Float, and Tinyint. See Data Types for details.
  • A Power BI connector is now included with the product package. You can use this connector to access your Greenplum data with Power BI. See Accessing Greenplum data with Power BI for details.
  • The new AllowedOpenSSLVersions option allows you to determine which version of the OpenSSL library file the driver uses for data encryption.
  • Added support for Kerberos authentication, including the following connection options:
    • The Authentication Method connection option now allows you to specify the method the driver uses to authenticate the user to the server when a connection is established. See Authentication Method for details.
    • The GSS Client Library connection option now allows you to specify the name of the GSS client library that the driver uses to communicate with the Key Distribution center (KDC). See GSS Client Library for details.
    • The Service Principal Name connection option allows you to specify the service principal name to be used by the driver for Kerberos authentication. See Service Principal Name for details.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled. See CryptoLibName and SSLLibName for details.
  • The new Crypto Protocol Version connection option allows you to specify the cryptographic protocols used when SSL is enabled. See Crypto Protocol Version for details.
  • The new Unbounded Numeric Precision connection option allows you to define the precision for unbounded NUMERIC columns when described within the column, parameter, result set, or table metadata. See Unbounded Numeric Precision for details.
  • The new Unbounded Numeric Scale connection option allows you to define the scale for unbounded NUMERIC columns described within the column, parameter, result set, or table metadata. See Unbounded Numeric Scale for details.
  • The TCP Keep Alive connection option allows you to use TCP Keep Alive to maintain idle TCP connections. See TCP Keep Alive for details.
  • The Max Char Size connection option specifies the maximum size of columns of type SQL_VARCHAR that the driver describes through result set descriptions and catalog functions. See Max Char Size for details.
  • The Max Long Varchar Size connection option specifies the maximum size of columns of type SQL_LONGVARCHAR that the driver describes through result set descriptions and catalog functions. See Max Long Varchar Size for details.
  • The Enable Keyset Cursors connection option enables emulated Keyset cursors to provide scrollable cursors to an ODBC application. See Enable Keyset Cursors for details.
  • The Keyset Cursor Options connection option determines which columns are used to comprise the keyset that the driver uses to create the initial keyset on which cursor operations are based. See Keyset Cursor Options for details.
  • Added support for SSL encryption with Greenplum 4.2 and higher, including the following connection options:
    • The Encryption Method connection option now allows you to encrypt data sent between the driver and the database. See Encryption Method for details.
    • The Host Name In Certificate connection option now allows you to specify the host name for certificate validation when SSL encryption and validation are enabled. See Host Name In Certificate for details.
    • The Key Password connection option now allows you to specify the key password that is used to access the individual keys in the keystore file when SSL and SSL client authentication are enabled on the database server. See Key Password for details.
    • The Keystore connection option now allows you to specify the directory containing the keystore file that is to be used when SSL and SSL client authentication are enabled on the database server. See Keystore for details.
    • The Key Store Password connection option allows you to specify the keystore password that is used to access the keystore file when SSL and SSL client authentication are enabled on the database server. See Keystore Password for details.
    • The Truststore connection option now allows you to specify the directory that contains the truststore file and the truststore file name that is to be used when SSL is enabled and the server authentication is used. See Truststore for details.
    • The Truststore Password connection option now allows you to specify the truststore password that is used to access the truststore file when SSL is enabled and the server authentication is used. See Truststore Password for details.
    • The User Name connection option now allows you to specify the user ID that is used to connect to your database. See User Name for details.
    • The Validate Server Certificate connection option now determines whether the driver validates the certificates that are sent by the database server when SSL encryption is enabled. See Validate Server Certificate for details.
• Impala driver enhancements since General Availability
  • 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 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 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.
  • The BatchMechanism connection option has been added to the driver. When BatchMechanism is set to 2 (MultiRowInsert), the driver executes a single insert for all the rows contained in a parameter array. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts. See Batch Mechanism for details.
  • Added support for SSL encryption, including the following connection options:
    • The CryptoLibName connection option allows you to determine the cryptographic library used when SSL is enabled. See CryptoLibName for details.
    • Crypto Protocol Version connection allows you to specify the cryptographic protocols used when SSL is enabled. See Crypto Protocol Version for details.
    • The Encryption Method connection option now allows you to encrypt data sent between the driver and the database. See Encryption Method for details.
    • The Host Name In Certificate connection option now allows you to specify the host name for certificate validation when SSL encryption and validation are enabled. See Host Name In Certificate for details.
    • The Key Password connection option now allows you to specify the key password that is used to access the individual keys in the keystore file when SSL and SSL client authentication are enabled on the database server. See Key Password for details.
    • The Key Store connection option now allows you to specify the directory containing the keystore file that is to be used when SSL and SSL client authentication are enabled on the database server. See Key Store for details.
    • The Keystore Password connection option allows you to specify the keystore password that is used to access the keystore file when SSL and SSL client authentication are enabled on the database server. See Keystore Password for details.
    • The SSLLibName connection option allows you to determine the SSL library used when SSL is enabled. See SSLLibName for details.
    • The Truststore connection option now allows you to specify the directory that contains the truststore file and the truststore file name that is to be used when SSL is enabled and the server authentication is used. See Truststore for details.
    • The Trust Store Password connection option now allows you to specify the truststore password that is used to access the truststore file when SSL is enabled and the server authentication is used. See Trust Store Password for details.
    • The User Name connection option now allows you to specify the user ID that is used to connect to your database. See User Name for details.
    • The Validate Server Certificate connection option now determines whether the driver validates the certificates that are sent by the database server when SSL encryption is enabled. See Validate Server Certificate 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: The legacy setting for enabling Kerberos Authentication (AuthenticationMethod=1) will continue to be valid for this release; however, it will be disabled in future versions of the product.
  • Support for Kerberos Authentication, which can be configured using the following connection options:
    • Authentication Method specifies the method the driver uses to authenticate the user to the server when a connection is established. See Authentication Method for details.
    • GSS Client Library specifies the GSS client library that the driver uses to communicate with the Key Distribution Center (KDC). See GSS Client Library for details.
    • Service Principal Name specifies the service principal name to be used by driver for Kerberos authentication. See Service Principal Name for details.
  • 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. See Apache Sentry for details.
  • The driver has been enhanced to support the Char, Decimal, and Varchar data types when connected to Impala 2.0 and higher. See Data Types for details.
  • The Array Size configuration 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. See Array Size for details.
• Progress OpenEdge driver enhancements
  • 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 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.
  • The new AllowedOpenSSLVersions option allows you to determine which version of the OpenSSL library file the driver uses for data encryption.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled. See CryptoLibName and Encryption Method for details.
  • The new Crypto Protocol Version connection option allows you to specify the cryptographic protocols used when SSL is enabled. See Crypto Protocol Version for details.
  • The TCP Keep Alive connection option allows you to use TCP Keep Alive to maintain idle TCP connections. See TCP Keep Alive for details.
• Sybase Wire Protocol driver enhancements
  • Support has ended for the DataDirect ODBC Data Source Administrator for Linux. As a result, the Linux ODBC Administrator will no longer be installed with the product. In addition, to avoid exposure to potential security vulnerabilities, the installer program will remove Linux ODBC Administrator files from existing installation directories during updates and new product installations.
  • The Performance Wizard is no longer supported.
  • 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 Allowed OpenSSL Versions (AllowedOpenSSLVersions) connection option has been deprecated as the driver currently supports only version 3.0 of the OpenSSL library.
  • 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.

  • The driver has been enhanced to support Sybase Extended Password Encryption and Sybase Extended Plus Encrypted Password, which use the asymmetrical key type. This provides stronger password encryption for the secure transmission of public key passwords over networks. See Authentication Method for details.

  • The driver has been enhanced to support BINARY and VARBINARY data types when using the bulk load protocol.
  • The new AllowedOpenSSLVersions option allows you to determine which version of the OpenSSL library file the driver uses for data encryption.
  • The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled. See CryptoLibName and Crypto Protocol Version for details.
  • The new Crypto Protocol Version connection option allows you to specify the cryptographic protocols used when SSL is enabled. See Crypto Protocol Version for details.
  • The TCP Keep Alive connection option allows you to use TCP Keep Alive to maintain idle TCP connections. See TCP Keep Alive for details.
• Driver for the Teradata Database enhancements
  • Support has ended for the DataDirect ODBC Data Source Administrator for Linux. As a result, the Linux ODBC Administrator will no longer be installed with the product. In addition, to avoid exposure to potential security vulnerabilities, the installer program will remove Linux ODBC Administrator files from existing installation directories during updates and new product installations.
  • The driver has been enhanced to support the Number data type. See Data Types for details.
• Text driver enhancements
  • Support has ended for the DataDirect ODBC Data Source Administrator for Linux. As a result, the Linux ODBC Administrator will no longer be installed with the product. In addition, to avoid exposure to potential security vulnerabilities, the installer program will remove Linux ODBC Administrator files from existing installation directories during updates and new product installations.
  • The driver has been enhanced to support a maximum character length of 255 characters for table and column names.
• XML driver enhancements
  • The driver has been enhanced to support Microsoft XML parser (MSXML) 6.0. Note that MSXML 6.0 (msxml6.dll) must be installed on your machine for the driver to function correctly.
• New driver DataDirect Connect64 for ODBC
  • Text Driver: A 64-bit version of the driver is now generally available. This driver provides 64-bit support for the features and functionality offered by the earlier DataDirect Connect (32-bit) version of the driver. In addition, for the Connect64 driver, support for HP-UX IPF has been added. See The Text Driver for details.
    Note: The Connect64 Text driver uses a driver-specific installer, instead of the Connect Series installer. Both installers are available on the Progress website.
• New driver DataDirect Connect XE and DataDirect Connect64 XE for ODBC
  • Impala™ Wire Protocol Driver
    • Supports Cloudera Impala database servers and formally certified with the following file formats and storage handlers:
      • File Formats:
        • Parquet
        • TextFile
      • Storage Handlers:
        • HBase
    • Returns result set metadata for parameterized statements that have been prepared by not yet executed.
    • Supports parameter arrays, processing the arrays as a series of executions, one execution for each row in the array.
    • Provides a connection option that allows you to configure the driver to report that it supports transactions, although Impala does not support transactions. This provides a workaround for applications that do not operate with a driver that reports that transcations are not supported.
    • Provides a connection option that allows you to set a default limit for the number of rows returned when an ORDER BY clause is submitted. This provides a workaround for applications that are not compatible with Impala's requirement that ORDER BY clauses limit the number of rows returned.
    • Supports the following standard SQL functionality:
      • Create Index and Create Table
      • Insert, Update, and Delete
      • Drop Index and Drop Table

  See The Impala Wire Protocol Driver for details.