5-10 20751-12 Rev.5
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide
Finish the Configuration A successful connection message indicates that you have success-
fully configured an entry for the system data source. To end the configuration process,
close all the open dialog boxes.
Configuring ODBC for UNIX/Linux
This section describes the process for configuring ODBC and your Netezza appliance data
source for UNIX/Linux.
You can access the files you need for the Netezza ODBC drivers and the ODBC driver instal-
lation from the Netezza FTP support site, or from the Netezza Client CD. The installation
program (see Chapter 3, “Installing and Uninstalling Client Tools”) installs the Netezza
tools and ODBC libraries on your system, and creates a NetezzaSQL system data source
entry (NZSQL) with appropriate default values.
After the ODBC driver is installed, the next step is to configure the environment variables to
enable the ODBC Driver to locate the proper configuration files. Then you will configure the
data sources.
ODBC Driver Configuration for UNIX/Linux
The driver manager and the Netezza ODBC drivers use a configuration file named
.odbcinst.ini to get information about ODBC drivers. During the Netezza ODBC driver
configuration process, you supply configuration information for the Netezza ODBC driver by
modifying entries in the .odbcinst.ini file.
Note: The period precedes the file name only when the file is located in the user’s home
directory as a hidden file. For a description of hidden and non-hidden files and how they
are used, refer to Appendix A, “ODBC Configuration Files.”
The following shows the contents of a 32-bit file named odbcinst.ini.sample. This
file is in the nz/lib directory (ordinarily /usr/local/nz/lib), after you have installed
the Netezza driver. Use the contents of the sample file to configure your own .odbcinst.ini
file.
[ODBC Drivers]
NetezzaSQL = Installed
[ODBC Connection Pooling]
PerfMon = 0
Retry Wait =
[NetezzaSQL]
Driver = /usr/local/nz/lib/libnzodbc.so
Setup = /usr/local/nz/lib/libnzodbc.so
APILevel = 1
ConnectFunctions = YYN
Description = Netezza ODBC driver
DriverODBCVer = 03.51
DebugLogging = false
LogPath = /tmp
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch = 256
Socket = 8192
[ODBC]
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais