RDBMS providers: Netezza

Connects to Netezza data warehouse appliances.

• Netezza 7.2, JDBC driver (jdbc native): standard connection method. Requires installation of JDBC drivers available from Netezza. This driver supports SSL for encrypting communication between the Data Management client and Netezza hosts.

• Netezza, ODBC driver (odbc native): standard connection method. Requires installation of ODBC drivers available from Netezza.

ODBC providers have been deprecated in Data Management and may not be supported in future versions.

To enable encrypted connections with the Netezza JDBC driver:

1. Configure the SSL certificate on the Netezza system.

2. Copy the Netezza server’s CA certificate file (typically server-cert.pem) to a location accessible to all Data Management Execution Servers.

3. Configure the Netezza JDBC connection with a Security level of onlySecured, and specify the file you copied in step 2 as the Server CA certificate file.