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 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 How to manually sync a replica in an RSA Authentication Manager 8.x deployment with one or more replicas Number of Views
Trending Articles
Report preview and/or generation fails with 'java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperrepor… How to set up the REST RSA SecurID Authentication API for Authentication Manager 8.2 SP1 RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Change the Token Lifetime Extension Window in Authentication Manager Using rsautil
Don't see what you're looking for?
