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.
Connector to connect SSIS with Vertica
Moderator: NorbertKrupa
-
- Newbie
- Posts: 5
- Joined: Thu Aug 01, 2013 12:44 am
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Connector to connect SSIS with Vertica
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.
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
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.
-
- Newbie
- Posts: 5
- Joined: Thu Aug 01, 2013 12:44 am
Re: Connector to connect SSIS with Vertica
Thanks for the reply. I will try that out.