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 Clear Security Question Answers in the User Dashboard Number of Views Questions on the security of offline authentication data in the RSA SecurID Authentication Agent for Microsoft Windows Number of Views Frequently Asked Questions for the Admin MFA Trial Number of Views When configuring Email Notification and Certificate Expiry Notification does 'All Vettors' (or the Vettor(s) selection fo… Number of Views
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle How to Download and Reinstall the AFX Server Archive in RSA Governance & Lifecycle
Don't see what you're looking for?
