on Sep 1, 2016Article Content
| Article Number | 000033869 |
| 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: $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. |