While Hybrid Data Pipeline supports JDBC, ODBC, and OData client application access to Snowflake data stores, the Hybrid Data Pipeline server uses the Progress DataDirect for JDBC for Snowflake driver to connect to Snowflake data sources. Therefore, the following documentation resources include information from Progress DataDirect driver guides.

Resource Description

Connection properties

With the exception of OData parameters, Snowflake parameters are based on the JDBC driver's connection properties. Therefore, for details on parameters, refer to these connection property descriptions in the Progress DataDirect for JDBC for Snowflake User's Guide.

Note:
  • Hybrid Data Pipeline supports only a subset of JDBC connection properties for each data store.
  • Hybrid Data Pipeline may not support all the valid values for a connection property.
  • In some cases, the default value of a Hybrid Data Pipeline parameter may differ from the default value of the JDBC connection property.
  • Hybrid Data Pipeline parameter names may differ from JDBC connection property names. For example, the Encryption Method parameter is referred to as the EncryptionMethod connection property in the JDBC driver documentation.

OData configuration

See this resource for details on configuring a Hybrid Data Pipeline data source for OData connectivity.

OAuth 2.0 authorization

See this resource for details on integrating Hybrid Data Pipeline with an OAuth 2.0 data store.

Key-pair authentication

For descriptions of required parameters, refer to this resource in the Progress DataDirect for JDBC for Snowflake User's Guide.

For information on setting up key-pair authentication, refer to Key-pair authentication and key-pair rotation in the Snowflake user guides.

Important: When using the Data Sources API to configure Snowflake for key-pair authentication, the multiline format of the private key must be modified for the JSON request payload. See Configuring Snowflake key-pair authentication using the API for details. Note that the format of the private key should not be changed when configuring the data source in the Web UI.

JDBC data types

For information on supported JDBC data types, refer to this resource in the Progress DataDirect for JDBC for Snowflake User's Guide.

ODBC data types

For information on supported ODBC data types, refer to this resource in the Progress DataDirect for ODBC for Snowflake User's Guide.

SQL support

For information on SQL support, refer to this resource in the Progress DataDirect for JDBC for Snowflake User's Guide.