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
user
16-12-2019 09:25:35 -0500

1 Answer

Hi, I noticed that the [How To Access to VDP from Informatica PowerCenter through ODBC](https://community.denodo.com/kb/view/document/How%20To%20Access%20to%20VDP%20from%20Informatica%20PowerCenter%20through%20ODBC?category=Northbound+Connections) KB article applies to Denodo 5.0 and 5.5. I would follow the [steps](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_in_linux_and_other_unix/set_up_a_dsn_on_linux_and_other_unix#install-the-denodo-odbc-driver-on-linux) 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