Page 1 of 1

format for "connect string" to setup vertica

Posted: Fri Oct 18, 2013 8:12 pm
by kkrbalam
I am trying to setup vertica connection in workflow manager relational connection section. There is a field called connect string in this, can some body please let me know, what is the format for that?

Re: format for "connect string" to setup vertica

Posted: Fri Oct 18, 2013 9:18 pm
by JimKnicely
Hi,

Have you tried the Informatica Plugins available for download on Vertica's site? You should also be able to use ODBC once you set up a connection. Once you have a DSN I'd image the connect string is simply the DSN name. See the Programmer's Guide for more info. There is a whole section on Informatica toward the end.