Netezza Connection Help

RazorSQL can connect to Netezza databases via either JDBC or ODBC. RazorSQL does not ship with drivers for Netezza. The drivers need to be obtained before connecting to Netezza. The drivers for Netezza do not appear to be publicly available. As such, they need to be obtained from Netezza support.

Connecting to Netezza via JDBC

After obtaining the Netezza JDBC drivers, select the JDBC (Netezza JDBC Driver) connection type from the connection type list. Enter any login information if applicable, and then enter the host or ip address of the Netezza server, and the port Netezza is listening on. Browse to the location of the location of the Netezza JDBC driver jar file for the Driver Location field.

Connecting to Netezza via ODBC

To connect to Netezza via ODBC, a Netezza ODBC driver must be downloaded and installed. Next, an ODBC data source must be set up via the Windows data sources control panel. See the following link for more information on how to set up an ODBC data source:

ODBC Setup

Manually configuring the Netezza JDBC Connection

For details on how to manually configure the Netezza JDBC connection, see the following

Manual Netezza JDBC Configuration