Progress DataDirect Connect for JDBC for Snowflake

    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 modified to map Snowflake data types for fixed-point numbers to the Numeric data type by default. In addition, the IntegerFieldMapping connection property has been added to the driver. This connection property allows you specify whether fixed-point numbers are mapped to Numeric or BigInt. Refer to IntegerFieldMapping and Data Types.*
      Available: Driver version 6.0.0.001266 (C5756.F002097.U001111)
    • The driver has been enhanced to support the refresh token grant for OAuth 2.0 authentication. To support it, a new connection property, RefreshToken, has been added. Refer to the user's guide for details. Refer to RefreshToken for details.*
      Available: Driver version 6.0.0.001101 (C5325.F001946.U001044)
    • The driver has been enhanced to fall back to JSON query format when the arrow format is not properly initialized. The driver uses a high-speed arrow transfer that requires the restricted APIs from java.nio package. When the JVM is not correctly configured for Java SE 16 and higher, an exception is returned when the driver executes a query. To allow you to continue executing queries in this scenario, you can configure the new ArrowFallbackToJson property to switch to the JSON query format. Refer to ArrowFallbackToJson for details.
    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
    GA Release Features
    • Supports JDBC core functions. Refer to JDBC support in the Progress DataDirect for JDBC Reference.
    • Supports the core SQL-92 grammar
    • Supports Snowflake data types through data type inference. Refer to Data types and getTypeInfo() for details.
    • Supports the handling of large result sets with paging and the FetchSize connection property. Refer to FetchSize for details. 
    • Supports the following authentication methods:
       - UserID/Password 
       - OAuth 2.0 
       - Browser-based SSO (Microsoft Windows) 

      Refer to Authentication for details.

    • Supports using the COPY command for loading and unloading data from local 
      file systems and cloud platforms, such as Amazon S3, Google Cloud, and 
      Microsoft Azure. Refer to Using Copy command for details.
    • Supports proxy server connections. Refer to Proxy server 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. Refer to Interactive SQL for details.
    • Includes the Progress DataDirect Snowflake Configuration Manager for 
      quick configuration and testing of your driver. This tool allows you to: 
      - Generate and edit connection URLs
      - Test connect connection URLs  
      - Execute SQL commands for testing 
      - Fetch OAuth 2.0 tokens
      - Access connection property descriptions and the full product
        documentation  

      Refer to Generating connection URLs with the Configuration Manager and Testing connections and queries.

Connect any application to any data source anywhere

Explore all DataDirect Connectors

A product specialist will be glad to get in touch with you

Contact Us