How to add a collector that connects to a Netezza database
Originally Published: 2015-06-17
Last Modified: 2023-10-06
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 Distribute One Software Token Using Dynamic Seed Provisioning Number of Views Checking the data dependencies of a security domain in RSA Authentication Manager 8.x Number of Views Dynamic Seed provisioning using QR Code Number of Views Distribute One Software Token Using Dynamic Seed Provisioning Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
