Vertica Connectivity Issue with Informatica

Moderator: NorbertKrupa

Post Reply
manips1985
Newbie
Newbie
Posts: 1
Joined: Thu Mar 07, 2013 11:45 am

Vertica Connectivity Issue with Informatica

Post by manips1985 » Thu Mar 14, 2013 3:00 pm

Hi Team,

We installed vertica client install for client system having 32 bit .

We have created ODBC connection through ODBC Administrator.

In Informatica when we try to import the vertica database through the ODBC connection created for vertica ,but the error is appearing as below:

specified driver could not be loaded due to system error 182 vertica
We tried with installing informatica plug in provided by vertica,while executing the workflow session is failed and not displaying any error.

And also i have attached another error occurs as set routine for the vertica ODBC . Please let me know if you need further information about this issue.

Kindly help me to resolve this issue.

Thanks & Regards,

Mani
Attachments
set up routine error.docx
Set up routine error
(36.25 KiB) Downloaded 156 times

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

Re: Vertica Connectivity Issue with Informatica

Post by JimKnicely » Thu Mar 14, 2013 3:24 pm

Hi!

What version of Informatica are you running and which version of Vertica's ODBC driver did you install?

Did you test the ODBC connection from the Admin Tools/ODBC Data Source Admin/Configure screen?

Image

Using your own specific settings, you should see the following message when clicking on the "Test Connection" button:

Image
Jim Knicely

Image

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

surbhij
Newbie
Newbie
Posts: 1
Joined: Wed Apr 10, 2013 12:48 pm

Re: Vertica Connectivity Issue with Informatica

Post by surbhij » Thu Apr 11, 2013 7:42 am

Hi,

I am also facing the same error while importing data from Vertica in Informatica through odbc connection on 32-bits windows platform..

Specified driver could not be loaded due to system error 182(Vertica, C:\Program Files\Vertica Systems\lib\vertica_6.0_odbc_3.5.dll)

I am using Informatica 9.1.0 and Vertica 6.0.

Kindly help me in this issue.

Thanks & Regards,
Surbhi

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

Re: Vertica Connectivity Issue with Informatica

Post by JimKnicely » Thu Apr 11, 2013 8:33 pm

Hi!

This is a guess, but I think your issue may be resolved by

1. Uninstall the Vertica 6.0.2 32bit drivers
2. Uninstall the the 32bit (x86) Microsoft Visual C++ 2008 redistributable components from Microsoft available here:
3. Re-install the Vertica 6.0.2 32bit drivers

But, first check if you have the MS components installed :)

Thanks!
Jim Knicely

Image

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

Post Reply

Return to “Informatica PowerCenter”