You can translate the question and the replies:

Denodo to Informatica PowerCenter through DenodoODBC driver

Hi, 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? Thanks, Navami
16-12-2019 09:25:35 -0500

1 Answer

Hi, I noticed that the [How To Access to VDP from Informatica PowerCenter through ODBC]( KB article applies to Denodo 5.0 and 5.5. I would follow the [steps]( of the Denodo7 documentation to setup the Denodo ODBC driver on linux. I hope this helps.
Denodo Team
17-12-2019 22:19:18 -0500
You must sign in to add an answer. If you do not have an account, you can register here