IBM Netezza connection through the IBM Data Server Driver for JDBC and SQLJ

IBM® Netezza® clients can use the IBM Data Server Driver for JDBC and SQLJ to connect to a database server. Minimal client-side configuration is needed when switching from an nzjdbc3 driver to the IBM Data Server Driver for JDBC and SQLJ

The IBM Data Server Driver for JDBC and SQLJ readily accepts Netezza configuration settings:
  • The Class.forName method will accept the Netezza driver: 
    Class.forName("org.netezza.Driver");
  • The JDBC Connection URL will accept the "netezza" subprotocol: 
    jdbc:netezza://host:port/databaseName
  • You can use the org.netezza.datasource.NzDataSource class to construct a DataSource for acquiring connections to the server.

The IBM Data Server Driver for JDBC and SQLJ uses a default port number of 50,000 when connecting an IBM Netezza client.

Compatible properties

Certain Netezza driver properties can be used to establish connection settings with the IBM Data Server Driver for JDBC and SQLJ. The following Netezza driver properties will be recognized by the IBM Data Server Driver for JDBC and SQLJ. They can be used in place of corresponding IBM Data Server Driver for JDBC and SQLJ properties with similar functionality if specified in camel case, all lowercase, or all uppercase letters.

Table 1. The following table lists several common Netezza driver properties that can be used in Netezza client applications instead of similar IBM Data Server Driver for JDBC and SQLJ properties.
Netezza Driver Property IBM Data Server Driver for JDBC and SQLJ Property
applicationName clientProgramName
autocommit autoCommit
batchSize fetchSize
caCertFile sslCertLocation
clientHostName clientWorkstation
clientUser clientUser
database databaseName
description description
host serverName
logDirPath traceDirectory
loginTimeout loginTimeout
name dataSourceName
password password
port portNumber
readonly readOnly
schema currentSchema
securityLevel sslConnection

Security specifications

Set the Netezza securityLevel property to "preferredSecured" or "onlySecured" if you would like to enable SSL connections in the application. Any other value for securityLevel will disable SSL connections.

Incompatibilities

  • The IBM Data Server Driver for JDBC and SQLJ will not throw an error if you use a Netezza driver property other than the aforementioned compatible properties.
  • The IBM Data Server Driver for JDBC and SQLJ will use empty functions in the case of unsupported application programming interfaces.
  • The Netezza logLevel property is not supported with the IBM Data Server Driver for JDBC and SQLJ. Implement a driver logging mechanism to evaluate IBM Data Server Driver for JDBC and SQLJ traceLevel settings to learn which trace settings best match your needs.