How to add a collector that connects to a Netezza database
3 years ago
Originally Published: 2015-06-17
Article Number
000067430
Applies To
RSA Product Set: Identity Management and Governance
Product Description: Access Certification Manager
Issue
You have data in a Netezza database and want to connect to it from RSA Access Certification Manager.
Resolution
Netezza is a database product that is currently owned by IBM.

IBM provides a jdbc driver so that 3rd party applications such as RSA Access Certification Manager can connect to their database. 

RSA does not provide a copy of IBM's Netezza jdbc driver out of the box.  To connect to Netezza from RSA Access Certification Manager you will need to acquire a jdbc version that is compatible with your version of Netezza from IBM's website.

NOTE:  Make sure to acquire the correct architecture is obtained (Linux x64).

Once you have the driver (example nzjdbc.jar or nzjdbc3.jar) you copy it to the deployed WEB-INF/lib directory.
For example on our appliance the path would be:
/home/oracle/jboss-4.2.2.GA/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/lib

After the jdbc jar has been placed in lib ACM must be restarted for the jar to be recognized.

Now in the ACM Administration Console you can define a collector with type database and define the connection using IBM's jdbc URLs.  Syntax that is correct at the time of this KB being written is:
jdbc:netezza://192.168.1.200:5480/databasename