|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:
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: