How do I connect to a Netezza database using Windows?
Altair EmployeeInstall a Netezza client (32-bit or 64-bit to match SLC. This example uses 64-bit.
(1) Execute nzodbcsetup.exe
Select English
Click OK
New Dialog. First 'introduction' pane.
Click Next
Select 32bit (or the bit size of your choice).
Set the "Optimize for ASCII character set".
Click Next
Depending on your bit size selection earlier, the relevant Library size choices should be made for you.
Click Next
A summary is presented.
Click Install
After the driver is installed you need to set up a DSN entry using the Windows ODBC utility...
Start the ODBC data sources utility from the Windows Start menu.
Click System DSN (to create a DSN for All Users - requires Administrator privileges) or User DSN (to create a single-user DSN)
Click Add
Select 'NetezzaSQL' from the list.
Click Finish
In the new dialog, set the following values:
Tab 'DSN Options'
Data Source : NETEZZA
Description : <optional value here>
Server : <ip address or hostname of your Netezza server)
Port : <default is 5480>
Database : <your database's name>
User Name : <user>
Password : <password>
Tab 'Advanced DSN Options'
unchecked : Read Only
unchecked : Show System Tables
unchecked : Legacy SQL Tables Behaviour
unchecked : Treat Numeric as Char
unchecked : Return SQL_BIT as 1/0
unchecked : Strip CR/LF
unchecked : Load Round Fraction
Login Timeout : 0
Query Timeout : 0
Load Max Errors : 1
Date format : Off / Off / On
Tab 'SSL DSN Options'
Security Level : Preferred Unsecured
CA Certificate File : <blank>
Tab 'Driver Options'
unchecked : Enable Debug Logging
unchecked : Optimized for ASCII character set
Log File Path : C:\ <optional addition path setting>
Prefetch Count : 256
Socket Buffer Size : 8192