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 RSA Governance & Lifecycle LDAP Novell eDirectory Connector Guide Number of Views Cloud Administration Enable FIDO Authenticator API Number of Views Pending accounts which resolve to no known user attribute are expected to be orphaned once collections occur but instead a… Number of Views Customizing Secure Communication Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide "No decryption codes were found in the zip file" error when decrypting RSA SecurID tokens
Don't see what you're looking for?
