Answer

For the MSTR configuration wizard to recognize the DSN entry for Netezza, you must add a line to the odbc.ini file that is located in /var/opt/Microstrategy.

The following is an example of the odbc.ini file contents.

[ODBC Data Sources]

[NZSQL]
Driver                = /usr/local/nz/lib/libnzsqlodbc3.so
Description           = NetezzaSQL ODBC
NZSQL                 = Microstrategy ODBC Driver for Netezza Wire Protocol
Servername            = <ip address>
Port                  = 5480
Database              = <database name>
Username              =
Password              =
ReadOnly              = false
ShowSystemTables      = true
LegacySQLTables       = true
LoginTimeout          = 0
QueryTimeout          = 0
DateFormat            = 1
NumericAsChar         = false
SQLBitOneZero         = false
StripCRLF             = false
securityLevel         = preferredUnSecured
caCertFile            =



After saving your changes to the odbc.ini file, you should be able to choose the NZSQL DSN name from the drop down menus in the Microstrategy interface.

The typical steps to connect to Netezza from Linux are:

1. Verify that the correct ODBC driver is installed (cli.package.tar.z)
2. Update the odbc.ini file in the MicroStrategy installation directory to include the sample DSN found in the odbc.ini.example.  This is just a copy and paste.  The DSN needs to be updated to include the path to the Netezza driver, the proper IP address, and the database name. 
3. Update the odbcinst.ini to include the proper path to the Netezza driver.  This file is in the same directory as the odbc.ini file.
4. Test the connection from the MicroStrategy ODBC Test tool (found in the bin directory of the MicroStrategy install).
5. Restart any I-Server that was running before the DSN was created.  This is needed to pick up the changes made since the last start-up (this might not be needed but is good practice as the I-Server reads from an sh file that sets environment variables like the NZ_ODBC_INI_PATH)