format for "connect string" to setup vertica

Moderator: NorbertKrupa

Post Reply
kkrbalam
Newbie
Newbie
Posts: 1
Joined: Fri Oct 18, 2013 7:28 pm

format for "connect string" to setup vertica

Post by kkrbalam » Fri Oct 18, 2013 8:12 pm

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?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: format for "connect string" to setup vertica

Post by JimKnicely » Fri Oct 18, 2013 9:18 pm

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.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Informatica PowerCenter”