How to add a collector that connects to a Netezza database
Originally Published: 2015-06-17
Article Number
Applies To
Product Description: Access Certification Manager
Issue
Resolution
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
Related Articles
IMG - How to add additional options to approvals/fulfillments Number of Views How to add a new admin to RSA Web Express Number of Views How to add a static route in RSA Authentication Manager 8.x Number of Views How to Add HSTS headers to Authentication Manager, AM service responses, even for invalid URLs which return error such as 404 Number of Views How to add users, contacts, colleagues to RSA Community Account to access knowledge articles and certain software downloads Number of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 Downloading RSA Authentication Manager license files or RSA Software token seed records AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and mule_e… RSA Authentication Manager 8.7 SP1 Patch 1 Hotfix 1 RSA Authentication Manager 8.8 Security Configuration Guide
Don't see what you're looking for?
