IBM PureData System for Analytics, Version 7.1

Process steps for ODBC, JDBC, and OLE DB

This section summarizes the procedures to set up ODBC, JDBC, and OLE DB, and provides links to the complete steps.

ODBC Setup Summary

To set up an ODBC environment:
  1. Install the appropriate IBM® Netezza® appliance client tools. See Installing and uninstalling client software.
  2. (UNIX only) Download an ODBC driver manager. See ODBC driver managers.
  3. Select the ODBC driver to install. See ODBC driver managers.
  4. Configure the data source. See Installing and configuring ODBC
  5. Test connectivity. See Installing and configuring ODBC.

JDBC Setup Summary

To set up a JDBC environment:
  1. Install the appropriate Netezza appliance client tools. See Installing and uninstalling client software.
  2. Install the JDBC driver. See Installing and configuring JDBC.
  3. Configure the data source. See Installing and configuring JDBC.

OLE DB Setup Summary

To set up an OLE DB environment:
  1. Install the appropriate Netezza appliance client tools. See Installing and uninstalling client software.
  2. Select the OLE DB provider to install. See Installing and configuring the OLE DB provider
  3. Configure the data source. See Installing and configuring the OLE DB provider
Parent topic: General information about ODBC, JDBC, and OLE DB

Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28