Support and certification

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

Changes Since 6.0.0 GA

  • Enhancements:

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

    • The driver has been enhanced to comply with FIPS standards for data encryption. As part of this enhancement, the driver was tested with FIPS 140-3 enabled using a Red Hat OpenJDK 21 on a Red Hat Universal Base Image 9 instance. See FIPS (Federal Information Processing Standard) for details.
    • 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 CrossCompany connection property. See CrossCompany 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 WSTimeout connection property. See WSTimeout for more information.

  • Changed Behavior
    • The connection property SpyAttributes has been updated to exclude the attribute load=classname, which was previously used to load the driver specified by the given class name. See SpyAttributes for details.

Highlights of 6.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 ERP apps
    Customer Service Finance
    Field Service Human Resources
    Marketing Retail
    Project Service Automation Supply Chain Management
    Sales

  • The driver supports JDBC core functions. For details, refer to JDBC support in the Progress DataDirect for JDBC Drivers Reference.

  • The driver supports the core SQL-92 grammar.
  • The driver supports Dynamics 365 data types through data type inference. See Data types and getTypeInfo() for details.
  • The driver supports OAuth 2.0 authentication. See OAuth 2.0 authentication for supported grant types and further details.
  • The driver supports NTLM authentication. See NTLM authentication for details.
  • The driver supports the handling of large result sets with paging, and the FetchSize connection property.
  • The driver supports optimizing insert, update, and delete operations with the BatchUpdateChunkSize connection property.
  • The driver includes the DataDirect JDBC Driver Configuration Manager for quick configuration and testing of your driver. This Configuration Manager allows you to:
    • Generate and edit connection URLs
    • Test connect connection URLs
    • Execute SQL commands for testing
    • Fetch OAuth tokens and configure OAuth
    • Access connection property descriptions and the full product documentation