Page 1 of 1

Vertica lookup in Informatica

Posted: Thu Sep 27, 2012 5:03 pm
by sean
Hi,

Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?

Thanks.

Re: Vertica lookup in Informatica

Posted: Thu Sep 27, 2012 5:07 pm
by jpcavanaugh
Which connection to Vertica are you using from informatica?

Re: Vertica lookup in Informatica

Posted: Thu Sep 27, 2012 5:25 pm
by sean
To load data, I'm created a connection of type "VerticaConnection" in the workflow manager and that worked when inserting data into Vertica. However, I added a lookup to the mapping, but that connection does not show up in the list for the lookup

The vertica drivers I have is version 5.1.4