000033869 - Recommendation for RSA Identity Governance & Lifecycle about creating an Access Fulfillment Express (AFX) connector to PostgreSQL using a generic ODBC driver

Document created by RSA Customer Support Employee on Sep 1, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033869
Applies ToRSA Product Set: Identity Governance & Lifecycle (G&L)
RSA Version/Condition:  6.8.1
 
IssueThe requirement is to create an Access Fulfillment Express (AFX) connector to a PostgreSQL database using the Open Database Connectivity (ODBC) driver inside a generic AFX database connector template.  However, this change requires the  definition of the URL with a Data Source Name (DSN) which is required by the ODBC logic.

RSA G&L needs to look into DSN to get the database details. Below are the outstanding queries:


 


  • Where do we have to define the DSN? Is it set at the operating system (OS) level, at the app server level, or somewhere on the AFX server?
  • Do we need to install the ODBC driver for PostgreSQL?
  • Are there any limitations of this ODBC driver within the generic database connector so that an ODBC connection over this connector would not be possible for PostgreSQL?
 
ResolutionQ:  Where do we have to define the DSN? 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 OS. Section 3 of the Installing and configuring postgreSQL and ODBC on Red Hat Linux page from the PostgresSQL page explains how to define DSN for PostgresSQL in Linux.
Q:  Do we need to install the ODBC driver for PostgreSQL?
A:  You have put the ODBC driver of the PostgreSQL inside the connector lib directory. Assuming the connector name is "mydb" then the filepath would be:AFX/mule/apps/AFX-CONN-mydb/lib
Q:  Are there any limitations of this ODBC driver within the generic database connector so that an ODBC connection over this connector would not be possible for PostgreSQL?
A:  There are no known limitations.

Attachments

    Outcomes