Setting up an ODBC environment

This topic provides an overview of setting up an ODBC environment and provides links to the detailed tasks.

About this task

Note: As compared to IBM® PureData® System for Analytics, 11.x drivers are based on RHEL 7 and require GLIBC_2.14.

Install the appropriate Netezza Performance Server system client tools. See Installing and uninstalling the client tools software.
UNIX and Linux operating systems only: Install an ODBC driver manager. See ODBC driver managers.
Install an ODBC driver. See Installing and configuring ODBC.
Configure the driver and data source. See the applicable topics:
- Windows operating systems: Configuring the ODBC data source and driver (Windows)
- UNIX and Linux operating systems: Configuring the ODBC driver (UNIX and Linux), followed by Configuring the ODBC data source (UNIX and Linux)
UNIX and Linux® operating systems only: Validate connectivity. See Validating ODBC connectivity (UNIX and Linux).
On Windows systems, you validate connectivity as part of the task of configuring the data source.