|Applies To||RSA Product Set: Identity Governance & Lifecycle (G&L)|
RSA Version/Condition: 6.8.1
|Issue||The 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:
|Resolution||Q: 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.