IBM PureData System for Analytics, Version 7.1

Installing the ODBC driver for Windows with the GUI

About this task

Follow these steps to install an IBM® Netezza® ODBC driver for Windows by using the GUI. The examples are for a Windows XP system, but the procedure is the same on other Windows systems.

Procedure

Start the installation program by double-clicking the nzodbcsetup.exe executable file in the /drivers directory of the Windows installation kit.
When a language option window opens, accept the default of English and click OK. The language option window controls the language for the installation program.
Review the information and click Next when the Introduction window opens.
If you are given the option to select the bit size of your driver, select 32-bit, 64-bit, or both, and click Next. On 64-bit systems, you are given the option of selecting the bit size of the driver to install. On 32-bit systems, this window is not displayed.
When the Character Translation Option window opens, specify whether you will use only the basic subset of characters, such as letters (a-z or A-Z), numbers (0-9), or punctuation marks in the CHAR and VARCHAR data types. If you use only these characters, select the Optimize for ASCII character set option to improve data transfer performance. However, if you use characters such as the Euro symbol or other characters that are outside the basic set, do not select the optimize option. Setting this option causes the characters that you enter to be converted to the correct encodings so that they display correctly in your query results. Click Next.
Install the Visual Studio 2010 (VS2010) Libraries on the client system.
When the Pre-Installation Summary window opens, page through the previous selections to review selections by using thePrevious. When finished, click Install. The Pre-Installation Summary window summarizes your installation choices
After you click Install, the installation program does the following processing:
- Installs the Netezza ODBC driver. A 32-bit driver on a 32-bit system and a 64-bit driver on a 64-bit system are installed in the \WINDOWS\system32 folder. If installing both 32-bit and 64-bit drivers on a 64-bit system, the 32-bit driver is installed in the \WINDOWS\SysWOW64 folder.
- Places entries in the Windows registry to add your selected ODBC driver to the driver list.
- Places entries in the Windows registry to add the NZSQL data source to the data source list.
When the Installation Complete window opens, click Done to close the program. This window indicates that the installation process completed successfully.
Before trying to access an ODBC data source, you must configure it. The next section describes the configuration procedure.