Challenges I faced during PostgreSQL connection creation in IICS

 Here are some common challenges faced during PostgreSQL connection creation in IICS 

(Informatica Intelligent Cloud Services) and tips to resolve them, especially from an MDM or data integration perspective:

1. Data Source Not Found.

•          [IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0)

This error can be due to either incorrect data source name or The DSN is not configured on the Secure Agent machine — especially for ODBC-based connections

Fix: 

Verify that System DSN has this data source configured.

1. login to secure agent machine
2.select start->ODBC Data sources->System DSN
3. Check if this DSN is configured and test the connection.

Select the data source and click on configure. 

Test if this is working or not. If test fails , you need to check connection details.
If System DNS is not configured , create DNS.

2. Architecture Mismatch Error

The connection test failed because of the following error: [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (0)


This error will be when 32 bit ODBC driver used with 64bit platform.

Fix:

start->odbc data sources(64 bit)->create system DNS.
Use this new DNS in connection data sources.

\

3. User does not have login access

 The connection test failed because of the following error: [08001] connection to server at "localhost" (::1), port 5432 failed: FATAL: role "testuser" is not permitted to log in (101)


This error can be due to user which is configured in IICS connection is not configured with login privileges.
Go to pgAdmin->login/group roles->select user->properties->Previleges

if "can login' is disabled , user will not be able to login.

Fix:

Enable can login? option.