format for "connect string" to setup vertica
Moderator: NorbertKrupa
format for "connect string" to setup vertica
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?
-
JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: format for "connect string" to setup vertica
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.
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.