An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Refer to the following resources for additional information:

• Product Compatibility Guide: Provides the latest data source and platform support information. 
• Fixes: Describes the issues resolved since general availability.  

Version 6.0.0 

Enhancements

• The driver has been enhanced to use proxy server settings defined in the JVM system properties by default. If no proxy settings are defined in the connection string or data source, the driver will attempt to use the values of the http.proxyHost and http.proxyPort JVM system properties to connect to the database.*

Changed Behavior

• The installer program now requires you to install a JRE that is Java SE 11 or higher before running the installer. In earlier versions, the JRE used by the installer program was included in the product. However, to avoid potential security vulnerabilities, the installer program no longer includes a JRE. Instead, the installer program uses the JRE in your environment to allow for the most secure version of a JRE to be used.*
  Note: This change does not affect the JVM requirements for the driver. For the latest driver requirements, refer to the Product Compatibility Guide.
  Available: July 3, 2024

Features

• Supports SQL read-only access to HubSpot. Refer to Supported SQL statements and extensions for details.
  
• Supports JDBC core functions. Refer to JDBC support in the Progress DataDirect for JDBC Drivers Reference.
  
• Supports HubSpot data types through data type inference. Refer to Data types and getTypeInfo() for details.
  
• Supports OAuth 2.0 and API key authentication. Refer to OAuth 2.0 authentication and API key authentication for details.
  
• Accesses a number of endpoints that are currently in the beta stage of development
  
• Supports the handling of large result sets with paging and the FetchSize connection property. Refer to FetchSize for details.
  
• Includes Interactive SQL for JDBC (JDBCISQL). It is a command-line interface that supports connecting your driver to a data source, executing SQL statements, and retrieving results in a terminal. This tool provides a method to quickly test your drivers in an environment that does not support GUIs.
  
• Includes the Progress DataDirect GitHub Configuration Manager for quick configuration and testing of your driver in a web browser. The tool allows you to: 
  • Generate and edit connection URLs
  • Test connect your connection URLs
  • Execute SQL commands for testing 
  • Access connection property descriptions and the full product documentation

  Refer to Generating connection URLs with the Configuration Manager for details.