|Applies To||RSA Product Set: Identity Governance & Lifecycle |
RSA Version/Condition: All
|Issue||This RSA Knowledge Base Article is meant to address some questions that have been asked on how to create an Access Fulfillment Express (AFX) connector to a PostgreSQL database using the Open Database Connectivity (ODBC) driver inside a Generic Database AFX connector template. |
|Resolution||Q: What change in the URL definition is required by the ODBC driver? |
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:
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.