Connecting Vertica to MS SQL

Moderator: NorbertKrupa

Post Reply
iw84n01
Newbie
Newbie
Posts: 9
Joined: Tue Dec 03, 2013 4:10 am

Connecting Vertica to MS SQL

Post by iw84n01 » Tue Sep 16, 2014 5:00 am

HI All,

Is there a way (and how) that Vertica DB can browse or Connect MS SQL Database?

do we need driver ?
:!: :!: :!: :?: :?: :?:


Regards,

User avatar
BoMBaY
Beginner
Beginner
Posts: 26
Joined: Tue Jul 16, 2013 5:45 am

Re: Connecting Vertica to MS SQL

Post by BoMBaY » Tue Sep 16, 2014 9:03 am

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
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)

Image
ImageImage

iw84n01
Newbie
Newbie
Posts: 9
Joined: Tue Dec 03, 2013 4:10 am

Re: Connecting Vertica to MS SQL

Post by iw84n01 » Tue Sep 16, 2014 9:11 am

thanks for the reply BoMBaY

but I'm still getting an error =(

I think this would works for oracle only

User avatar
BoMBaY
Beginner
Beginner
Posts: 26
Joined: Tue Jul 16, 2013 5:45 am

Re: Connecting Vertica to MS SQL

Post by BoMBaY » Tue Sep 16, 2014 10:15 am

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
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)

Image
ImageImage

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Connecting Vertica to MS SQL

Post by NorbertKrupa » Tue Sep 16, 2014 1:20 pm

You can set up a linked server.
Checkout vertica.tips for more Vertica resources.

iw84n01
Newbie
Newbie
Posts: 9
Joined: Tue Dec 03, 2013 4:10 am

Re: Connecting Vertica to MS SQL

Post by iw84n01 » Wed Oct 01, 2014 7:53 am

norbertk wrote:You can set up a linked server.
Hi Norbertk,

What I meant is from the Vertica (unix box) going to query / connect to the MS SQL Server

Regards

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Connecting Vertica to MS SQL

Post by NorbertKrupa » Wed Oct 01, 2014 1:16 pm

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.

Post Reply

Return to “ODBC”