Getting started with the ODBC Driver

Progress DataDirect Hybrid Data Pipeline Driver for ODBC works with the Hybrid Data Pipeline connectivity service to provide SQL access to supported cloud data stores from any ODBC-compliant application.

Information that the driver needs to connect to a database is stored in a data source. The ODBC specification describes three types of data sources: user data sources, system data sources (not a valid type on UNIX/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, and are accessible to other machines.

When you define and configure a data source, you store default connection values for the driver that are used each time you connect to a particular database. You can change these defaults by modifying the data source.

For information on installing the driver, refer to the Progress DataDirect Hybrid Data Pipeline Installation Guide.

See Configuring an ODBC data source on UNIX and Linux systems for information on setting environment variables, configuring a data source in the system information file, and setting up DSN-less connections.

See Configuring and testing an ODBC data source on Windows for information on defining a data source in the ODBC Administrator.

Application considerations provides information on verifying the driver version number, retrieving data type information, and supported ODBC API functions and scalar functions.