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 Configure password and security questions chained login for RSA Authentication Manager Prime Kit Self-Service Portal (SSP) Number of Views Questions on the security of offline authentication data in the RSA SecurID Authentication Agent for Microsoft Windows Number of Views Dumpreader and dumptool questions about functionality in RSA Authentication Manager Number of Views
Trending Articles
How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
