Connection Profile to Netezza JDBC Example

dmelcher

This report uses the the JDBCConnectionProfileStore.xml file in the C:JDBC folder as the connection profile to locate the Netezza data source. Within this file, make sure to enter your Netezza username, password and IP address. Also make sure your jarList setting in the file points to your Netezza JDBC jar file. Mine is in the C:JDBC folder. I use this report to test connectivity to Netezza.<br />
<br />
By changing the IP address in the JDBCConnectionProfileStore.xml file, you can easily change from your Netezza development server, to QA, and to production without making any modification to your report designs. <br />
<br />
Even though this example is set up to retrieve Netezza system environment variables, this connection profile technique can be used with any JDBC driver settings.