Setting up a JDBC environment

Learn about the procedure to set up a JDBC environment and find links to the detailed instructions.

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.

Procedure

  1. Install the appropriate Netezza Performance Serversystem client tools. See Installing and uninstalling the client tools software.
  2. Install the JDBC driver. See Installing the JDBC driver (Windows) or Installing the JDBC driver (UNIX and Linux).
  3. Configure the data source. See Configuring the JDBC data source by using an nzjdbc.ini file (Windows) or Configuring the JDBC data source by using an nzjdbc.ini file (UNIX and Linux).
    Note: Suffixes are not supported in the JDBC logs. For example, if version 11.2.1.7-IF1 specified in the configuration file, the logs print 11.2.2.7 instead. As a result, the drivers fail.