Support and Certifications

Visit the following web pages for the latest support and certification information.

Changes Since 8.0.0 Release

  • Enhancements:

    • The Show Name Columns option has been added to the driver. This option allows you to expose name columns for Choice, Yes/No, and Lookup field types in Dynamics CRM apps.

    • The driver has been enhanced to use entity type names instead of the default entity set names. You can configure this functionality using the new Use Entity Type Names (UseEntityTypeNames) connection option. See Use Entity Type Names for more information.
    • 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 data from all the companies to which the user has access. Earlier, it supported fetching data only from the default company of the user. You can configure this functionality using the new Cross Company (CrossCompany) connection option. See Cross Company for more information.
    • The driver has been enhanced to allow you to configure whether requests to web services timeout when the service is unresponsive. You can configure this functionality using the new Web Service Timeout (WSTimeout) connection option. See Web Service Timeout for more information.
    • 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.

  • Changed Behavior:

    • The following connection options have been removed from the driver: Connection Retry Count (ConnectionRetryCount), Connection Retry Delay (ConnectionRetryDelay), LoginTimeout (LoginTimeout), and Query Timeout (QueryTimeout).

Highlights of 8.0.0 Release

  • Supports SQL read-write access to the following Microsoft Dynamics 365 CRM and ERP apps. (See also Supported SQL statements and extensions.)

    • CRM apps
      • Customer Service
      • Field Service
      • Marketing
      • Project Service Automation
      • Sales
    • ERP apps
      • Finance.
      • Retail
      • Supply Chain Management
      • Talent
  • 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.

  • Supports Dynamics 365 data types through data type inference. See Data types for details.
  • Supports OAuth 2.0 authentication. See OAuth 2.0 authentication for supported grant types and further details.
  • Supports NTLM authentication. See NTLM authentication for details.
  • Supports the handling of large result sets with paging, and the Fetch Size (FetchSize) connection option. See Fetch Size for details.
  • Supports optimizing insert, update, and delete operations with the Batch Update Chunk Size (BatchUpdateChunkSize) connection option. See Batch Update Chunk Size for details.
  • Includes the DataDirect ODBC Driver Configuration Manager for quick configuration and testing of your driver on Windows platforms. This Configuration Manager allows you to:
    • Configure data sources
    • Generate and edit connection URLs
    • Test connect data sources and connection URLs
    • Execute SQL commands for testing
    • Fetch OAuth tokens and configure OAuth
    • 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.