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

Important: When running Hybrid Data Pipeline in FIPS mode and connecting to a PostgreSQL 14 or later database using scram-sha-256 authentication, the user password must be greater than 112 bits in length (equivalent to 14 UTF-8 Latin block characters). If this requirement is not met, the product will time out or return the error org.bouncycastle.crypto.fips.FipsUnapprovedOperationError: password must be at least 112 bits.
Resource Description

Connection properties

With the exception of OData parameters, PostgreSQL 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 PostgreSQL Driver 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.

JDBC data types

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

ODBC data types

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

SQL support

Hybrid Data Pipeline supports the core SQL-92 grammar.