What's new in this release?

For the latest certifications and enhancements, refer to the following:

• Release Notes
• Supported Configurations
• DatatDirect Support Matrices

Changes Since 8.0.0 GA

• Enhancements:
  • 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 has been enhanced to support fetching access and refresh tokens at connection when OAuth2.0 is enabled. When using the new dynamic authorization code grant, you can initiate an authorization code grant flow by specifying login credentials using the login prompt for your service, thereby providing a method to authenticate without fetching access and refresh tokens via the Configuration Manager or third-party application. In addition, the new Enable Login Prompt (EnableLoginPrompt) option has been added to enable this functionality. See Dynamic authorization code grant and Enable Login Prompt 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.

Highlights of 8.0.0 Release

• The driver supports SQL read-write access to list resources on Microsoft SharePoint Online. See Supported SQL statements and extensions for details.
• The driver supports all ODBC Core and Level 1 functions and some Level 1 and Level 2 features.

  Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for additional information.

• The driver supports SharePoint data types through data type inference. See Data types and Introduction to the SharePoint List data model for details.
• The driver supports OAuth 2.0 authentication. See OAuth 2.0 authentication for supported grant type and further details.
• The driver supports the handling of large result sets with paging, and the Fetch Size (FetchSize) connection option. See Fetch Size for details.
• The driver supports optimizing insert, update, and delete operations with the Batch Update Chunk Size connection option.
• On Windows platforms, the driver includes an enhanced setup dialog, the DataDirect ODBC Driver Configuration Manager, for quick configuration and testing of your driver. This Configuration Manager allows you to:
  • Configure data sources
  • Generate and edit connection strings
  • Test connect data sources and connection strings
  • Execute SQL commands for testing
  • Access connection option descriptions and the full product documentation

  See Configuring data sources with the Configuration Manager and Generating connection strings with the Configuration Manager for details.