Connector to connect SSIS with Vertica

Forum to discuss topics related to accessing and using Vertica with SSIS

Moderator: NorbertKrupa

Post Reply
Ranjith.chowdary
Newbie
Newbie
Posts: 5
Joined: Thu Aug 01, 2013 12:44 am

Connector to connect SSIS with Vertica

Post by Ranjith.chowdary » Mon Aug 12, 2013 11:39 pm

Hello Everyone,

Do we have a connector which we can use to connect SSIS with Vertica?.

Also one more question,

Can my architecture look like SQL Server -- > SSIS --> Vertica using SSIS as a ETL tool. Am a newbie to both SQL Server and Vertica. Let me know if i have to rephrase my questions.

Thanks in Advance.

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

Re: Connector to connect SSIS with Vertica

Post by JimKnicely » Tue Aug 13, 2013 1:15 pm

Hi,

You can download the Vertica Windows Client package or the ado.net driver from here https://my.vertica.com/downloads. You can use either the ODBC driver (included in the package) or the ado.net driver to connect SSIS to Vertica.
Jim Knicely

Image

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

Ranjith.chowdary
Newbie
Newbie
Posts: 5
Joined: Thu Aug 01, 2013 12:44 am

Re: Connector to connect SSIS with Vertica

Post by Ranjith.chowdary » Tue Aug 13, 2013 5:22 pm

Thanks for the reply. I will try that out.

Post Reply

Return to “Microsoft SQL Server Integration Services (SSIS)”

Who is online

Users browsing this forum: No registered users and 1 guest