Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2016-08-25
Article Number
000059335
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.