000030587 - How to add a collector that connects to a Netezza database

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000030587
Applies ToRSA Product Set: Identity Management and Governance
Product Description: Access Certification Manager
IssueYou have data in a Netezza database and want to connect to it from RSA Access Certification Manager.
ResolutionNetezza 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

Attachments

    Outcomes