Installation Note 66084: Updated ODBC drivers are available for DataFlux® Data Management Studio and DataFlux® Data Management Server 2.8 and 2.9
 |  |  |  |  |
SAS is providing and supporting quarterly updates to the embedded Open Database Connectivity (ODBC) drivers for DataFlux Data Management Studio and DataFlux Data Management Server 2.8 and 2.9. The 2024 Q3 update is now available and can be downloaded from the Hot Fix tab in this note. A release announcement for each update will be posted on the SAS Communities Hot Fix Site.
Important Release Notes:
- The PostgreSQL Wire Protocol driver that is included in this update is certified with PostgreSQL 15 and 16.
- The DB2 Wire Protocol driver included in this update is supported with DB2 11.1 and 11.5 on Linux, UNIX, and Microsoft Windows (as well as DB2 12 and DB2 13 for z/OS and DB2 i 7.4). DB2 versions 9 and 10 are not supported with this driver.
- Due to an updated ICU library on AIX, installing this update on AIX 7.1 requires the system to have the IBM XL C++ 16.1 (or later) runtime installed. You can check which release of the runtime is installed by using the following command:
lslpp -l xlC.rteIf the release is earlier than 16.1.0.0, follow the instructions on this page: IBM XL C/C++ Runtime for AIX 16.1 to download and install the runtime for AIX 7.1. Note that AIX 7.2 and later releases do not have any additional requirements.
- The SQL Server Wire Protocol driver that is included in this update is certified with SQL Server 2022.
- The Greenplum Wire Protocol driver that is included in this update is certified with Greenplum 7.0.
- The Oracle Wire Protocol driver that is included in this update is certified with Oracle 23c.
- In July 2023, Progress DataDirect announced the retirement of the Oracle Client ODBC Driver with an EOL date of June 2024. As a result of this change, the Oracle Client driver is no longer included in the quarterly ODBC driver updates that are provided by SAS. In order to maintain a fully supported environment, SAS recommends migrating to the Oracle Wire Protocol driver as soon as possible. For more information, see Progress DataDirect Product End of Life Announcement July 2023.
- Starting with the 2023 Q3 release, the ODBC drivers in the following list use a new version of SSL for secure communications that requires an update to the DataFlux ODBC secure package. If you use any of the affected ODBC drivers with SSL or secure authentication configured, contact SAS Technical Support to obtain the patch that is needed to update the DataFlux ODBC secure package:
- Amazon Redshift Wire Protocol
- Apache Hive Wire Protocol
- DB2 Wire Protocol
- MySQL Wire Protocol
- Oracle Wire Protocol
- PostgreSQL Wire Protocol
- SQL Server Wire Protocol
- The Oracle Wire Protocol driver and the cURL library that are included with this update include fixes for the vulnerabilities described in SAS Note 70169, "The Oracle Wire Protocol driver and the cURL library included with DataFlux® ODBC drivers are affected by vulnerabilities."
- The cURL library that is included in this update includes a fix for the vulnerability described in SAS Note 69989, "The cURL library included with the DataFlux® ODBC drivers is affected by the vulnerability described in CVE-2022-42915."
- The Postgres Wire Protocol driver that is included in this update is certified with Yellowbrick Data Warehouse.
- The Salesforce driver that is included in this update includes a fix for the vulnerability described in SAS Note 69773, "The DataFlux® Salesforce ODBC driver is affected by the remote code execution vulnerability described in CVE-2022-41853."
- The Informix Wire Protocol driver included in this update is supported with Informix 12.1 and 14.1. Informix version 11 and earlier are not supported with this driver.
- With this hot fix, SAS removes support for Apache Spark SQL connectivity through ODBC within SAS® Data Management Platform 2.8 and 2.9. Future releases of SAS® Data Management, including DataFlux Data Management Studio and DataFlux Data Management Server, no longer deliver support for Apache Spark SQL connectivity through ODBC. If this driver was used, you can migrate to ODBC or Java Database Connectivity (JDBC) drivers that are available for free from Spark engine vendors.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| Dataflux | DataFlux Data Management Studio | Microsoft Windows 8 Pro x64 | ||
| Microsoft Windows 8 Pro 32-bit | ||||
| Microsoft Windows 8 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro x64 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | ||||
| Microsoft Windows 8.1 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro 32-bit | ||||
| Microsoft Windows 10 | ||||
| Microsoft Windows 11 | ||||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2008 R2 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Microsoft Windows Server 2012 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Std | ||||
| Microsoft Windows Server 2012 Std | ||||
| Microsoft Windows Server 2016 | ||||
| Microsoft Windows Server 2019 | ||||
| Microsoft Windows Server 2022 | ||||
| Microsoft Windows XP Professional | ||||
| Windows 7 Enterprise 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Millennium Edition (Me) | ||||
| Microsoft® Windows® for x64 | ||||
| Windows Vista | ||||
| Microsoft Windows 8 Enterprise 32-bit | ||||
| Windows Vista for x64 | ||||
| Dataflux | DataFlux Data Management Server | Microsoft Windows 8 Pro x64 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | ||||
| Microsoft Windows 8.1 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro 32-bit | ||||
| Microsoft Windows 8.1 Pro x64 | ||||
| Microsoft Windows 10 | ||||
| Microsoft Windows 11 | ||||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2008 R2 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Microsoft Windows Server 2012 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Std | ||||
| Microsoft Windows Server 2012 Std | ||||
| Microsoft Windows Server 2016 | ||||
| Microsoft Windows Server 2019 | ||||
| Microsoft Windows Server 2022 | ||||
| Microsoft Windows XP Professional | ||||
| Windows 7 Enterprise 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Millennium Edition (Me) | ||||
| Windows Vista | ||||
| Windows Vista for x64 | ||||
| 64-bit Enabled AIX | ||||
| 64-bit Enabled HP-UX | ||||
| 64-bit Enabled Solaris | ||||
| HP-UX IPF | ||||
| Linux | ||||
| Linux for x64 | ||||
| Solaris for x64 | ||||
| Microsoft Windows 8 Pro 32-bit | ||||
| Microsoft Windows 8 Enterprise x64 | ||||
| Microsoft Windows 8 Enterprise 32-bit | ||||
| Microsoft® Windows® for x64 | ||||
A fix for this issue for DataFlux Data Management Server 2.9 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J6K.html#66084A fix for this issue for DataFlux Data Management Studio 2.9 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J6J.html#66084A fix for this issue for DataFlux Data Management Server 2.8 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H3W.html#66084A fix for this issue for DataFlux Data Management Studio 2.8 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H9M.html#66084
This SAS Note enables you to obtain quarterly updates for DataFlux® Data Management Studio and DataFlux® Data Management Server 2.8 and 2.9.
| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2024-10-07 09:21:00 |
| Date Created: | 2020-06-05 03:28:45 |