Skip to main content

Unable to connect to vertica database through informatica

  • December 15, 2016
  • 2 replies
  • 21 views

saiteja02

Hi ,

Iam using power center 9.5.1 and i have installed vertica client recently .

Iam not able to find vertica data base in Relational connection browser (in workflow manager while selecting the connection name).

 

Capture.PNG

 

 

But ,I could import vertica tables in designer 

 

please advice what i need to do to get the connection and let me know if i need to provide any information to resiove this issue.

 

Thanks in advance

2 replies

ckotsidimos
Forum|alt.badge.img+1
  • Participating Frequently
  • December 16, 2016

Try ODBC. 

I do not have any experience in Informatica


Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • January 3, 2017

 

 

Use the  Vertica Plug-In for Informatica.

 

 You als have plenty of info here : INFA Integration