Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle
Originally Published: 2016-08-25
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
Clear Security Question Answers in the User Dashboard Number of Views 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 When configuring Email Notification and Certificate Expiry Notification does 'All Vettors' (or the Vettor(s) selection fo… Number of Views Configure password and security questions chained login for RSA Authentication Manager Prime Kit Self-Service Portal (SSP) Number of Views
Don't see what you're looking for?
