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:
Manually configuring the Netezza JDBC Connection
For details on how to manually configure the Netezza JDBC connection, see the following
Manual Netezza JDBC Configuration