The Progress DataDirect Hybrid Data Pipeline Driver for ODBC may be used with an ODBC application to connect to Hybrid Data Pipeline. In turn, Hybrid Data Pipeline provides access to supported data stores. The information that the driver needs to connect to Hybrid Data Pipeline may be stored in an ODBC data source or passed in a connection string. The connection options set in the ODBC data source, or passed in a connection string, apply only to the connection between the application and Hybrid Data Pipeline.1

The ODBC driver supports three types of data sources described by the ODBC specification: user data sources, system data sources (not a valid type on Linux), and file data sources. On Windows, user and system data sources are stored in the registry of the local computer. The difference is that only a specific user can access user data sources, whereas any user of the machine can access system data sources. On all platforms, file data sources, which are simply text files, can be stored locally or on a network computer.

When you define and configure an ODBC data source, you store default connection values for the driver that are used each time you connect to Hybrid Data Pipeline. You can change these defaults by modifying the data source. See the following topics for more information on configuring and connecting with the ODBC driver.

Note: Refer to the Progress DataDirect Hybrid Data Pipeline Deployment Guide for information on installing the ODBC driver.
1 In contrast to an ODBC data source, a Hybrid Data Pipeline data source defines the connection between Hybrid Data Pipeline and a supported data store, such as Oracle or Salesforce.