Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle
Originally Published: 2016-08-25
Last Modified: 2023-10-06
Article Number
Applies To
RSA Version/Condition: All
Issue
Resolution
A: The URL definition must include a Data Source Name (DSN).
Q: Where is the DSN defined? Is it set at the operating system (OS) level, at the app server level, or somewhere on the AFX server?
A: Define the DSN in the Operating System. See your PostGreSQL documentation on defining the DSN.
Q: Where does the ODBC driver for PostgreSQL need to be installed?
A: The ODBC driver for PostgreSQL needs to be installed in the connector lib directory. This directory is located at:
$AFX_HOME/esb/apps/AFX-CONN-{connector-name}/lib.
Q: Are there any known limitations of the PostgreSQL ODBC driver that would prevent an ODBC connection to a PostgreSQL endpoint when using the Generic Database connector?
A: There are no known limitations.
Related Articles
How to modify security questions for the RSA Authentication Manager Self-Service Console Number of Views Questions on the security of offline authentication data in the RSA SecurID Authentication Agent for Microsoft Windows Number of Views Clear Security Question Answers in the User Dashboard Number of Views When configuring Email Notification and Certificate Expiry Notification does 'All Vettors' (or the Vettor(s) selection fo… Number of Views Frequently Asked Questions for the Admin MFA Trial Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
