000033869 - Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Sep 1, 2016Last modified by RSA Customer Support on Oct 31, 2019
Version 4Show Document
  • View in full screen mode

Article Content

                                       
Article Number000033869
Applies ToRSA Product Set: Identity Governance & Lifecycle 
RSA Version/Condition:  All
 
IssueThis 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.  
 
ResolutionQ: 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.

Attachments

    Outcomes