Page 1 of 1
Connecting Vertica to MS SQL
Posted: Tue Sep 16, 2014 5:00 am
by iw84n01
HI All,
Is there a way (and how) that
Vertica DB can browse or Connect MS SQL Database?
do we need driver ?
Regards,
Re: Connecting Vertica to MS SQL
Posted: Tue Sep 16, 2014 9:03 am
by BoMBaY
I didn't try it but I think the topic on the link below might be helpful for you.
viewtopic.php?f=21&t=1331
Re: Connecting Vertica to MS SQL
Posted: Tue Sep 16, 2014 9:11 am
by iw84n01
thanks for the reply BoMBaY
but I'm still getting an error =(
I think this would works for oracle only
Re: Connecting Vertica to MS SQL
Posted: Tue Sep 16, 2014 10:15 am
by BoMBaY
Can you connect MS SQL from Linux (Vertica server)?
SQL Server ODBC Driver for Linux/Unix Getting Started Tutorial
http://www.easysoft.com/products/data_a ... arted.html
Re: Connecting Vertica to MS SQL
Posted: Tue Sep 16, 2014 1:20 pm
by NorbertKrupa
You can set up a
linked server.
Re: Connecting Vertica to MS SQL
Posted: Wed Oct 01, 2014 7:53 am
by iw84n01
Hi Norbertk,
What I meant is from the Vertica (unix box) going to query / connect to the MS SQL Server
Regards
Re: Connecting Vertica to MS SQL
Posted: Wed Oct 01, 2014 1:16 pm
by NorbertKrupa
If it's not using Vertica, then it's not a Vertica question. My guess is you would need some scripting language and drivers to connect to SQL Server from *nix.