IBM SPSS Modeler Configuration uses the Netezza database

Installation

1. Download the latest support Netezza installer from Netezza homepage

2. Log on to system as root user.

3. Uncompress the install, for example:

# tar ZXVF nz-linuxclient-v7.0.3.tar.gz

4. The permission of the uncompressed files and execute unpack, for example:

# chmod 777 Nz-linuxclient-v7.0.3.tar.z

#./unpack

5. Accept The default installation directory-/USR/LOCAL/NZ and enter to complete installation.

Configuration

1. Go to/usr/local/nz/lib64

2. Open odbc.ini.sample and copy the template into the Odbc.ini under SDAP installation

3. Edit Odbc.ini file to set the following parameters:

Driver=/usr/local/nz/lib64/libnzodbc.so

Servername=< IP address of Netezza server>

Port=5480

database=<netezza Database name>

For example,

[Nz_7]

driver= /usr/local/nz/lib64/libnzodbc.so

description= Netezzasql ODBC

Servername=<ip_address>

port=5480

database=<database_name>

Username=

password=

readonly= false

showsystemtables= false

legacysqltables= false

logintimeout= 0

querytimeout= 0

Dateformat= 1

Numericaschar= false

sqlbitonezero= false

stripcrlf= false

SecurityLevel = preferredunsecured

CACertFile =

4. Edit odbc.sh file under SDAP:

-Add the Netezza driver location into ld_library_path:

Ld_library_path=/qatest/sdap/lib:/usr/local/nz/lib64/

-Add The following in the odbc.sh file

nz_odbc_ini_path=/qatest/sdap/

Export Nz_odbc_ini_path

If This variable was not defined, the following error would be a given when connecting to Netezza server:

Error:cannot Find Netezza Server

5. Edit Odbcinst.ini file under SDAP:

Netezza7=installed

[Netezzasql]

Driver =/usr/local/nz/lib64/libnzodbc.so

Setup =/usr/local/nz/lib64/libnzodbc.so

APILevel = 1

ConnectFunctions = YYN

Description = Netezza ODBC Driver

DriverODBCVer = 03.51

Debuglogging = False

LogPath =/tmp

Unicodetranslationoption = UTF8

Charactertranslationoption = All

PreFetch = 256

Socket = 16384

If you encounter error of "unexpected protocol character". Please pass BSO Firewall using telnet command First, then configure your remote Netezza database. No telnet command? Raise IT ticket.

More information, refer to "Configuring Modeler Server on Unix\linux to connect to Netezza databases via ODBC" page Below

http://www-01.ibm.com/support/docview.wss?uid=swg21679968

IBM SPSS Modeler Configuration uses the Netezza database