IBM SPSS Modeler 配置使用 Netezza 数据库

fairyguo

Installation
1. Download the latest support Netezza installer from Netezza homepage
2. Log on to system as root user.
3. Uncompress the install package, for example:
     # tar zxvf nz-linuxclient-v7.0.3.tar.gz
4. Change 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 is not defined, the following error will be 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, please 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