HI All,
Is there a way (and how) that Vertica DB can browse or Connect MS SQL Database?
do we need driver ?
Regards,
Connecting Vertica to MS SQL
Moderator: NorbertKrupa
Re: Connecting Vertica to MS SQL
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
viewtopic.php?f=21&t=1331
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)
Re: Connecting Vertica to MS SQL
thanks for the reply BoMBaY
but I'm still getting an error =(
I think this would works for oracle only
but I'm still getting an error =(
I think this would works for oracle only
Re: Connecting Vertica to MS SQL
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
SQL Server ODBC Driver for Linux/Unix Getting Started Tutorial
http://www.easysoft.com/products/data_a ... arted.html
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Connecting Vertica to MS SQL
You can set up a linked server.
Checkout vertica.tips for more Vertica resources.
Re: Connecting Vertica to MS SQL
Hi Norbertk,norbertk wrote:You can set up a linked server.
What I meant is from the Vertica (unix box) going to query / connect to the MS SQL Server
Regards
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Connecting Vertica to MS SQL
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.
Checkout vertica.tips for more Vertica resources.