I am trying to create a connection from Denodo to Informatica PowerCenter. I tried connecting with DataDirect 7.0 PostgreSQL Wire Protocol driver which was unsuccessful(the connection works locally and I was able to import Denodo data source in mapping designer ans see the preview data, but session fails in workflow level with error-Connection refused. Verify Host Name and Port Number). But then, I found a Denodo KB article that says there is a known issue with this approach which leads to a datatype incompatibility and that the recommended driver would be DenodoODBC driver. So now, I need to install DenodoODBC driver in our Informatica server which is Linux and update odbc.ini and odbcinst.ini files accordingly.
If anyone has been successful in establishing Denodo-Informatica PWC connection using DenodoODBC(or any other driver), could you please share the steps that you followed and a sample entry in odbc.ini and odbcinst.ini files for this driver?