How to connect to sql server from SAS EG on UNIX/LINUX

Reply
New Contributor
Posts: 2

How to connect to sql server from SAS EG on UNIX/LINUX

Hello All,

Is there any way to connect to sql server from SAS EG based on UNIX/LINUX?

It does not work the same way as it does from PC SAS.

Thanks

PROC Star
Posts: 1,167

Re: How to connect to sql server from SAS EG on UNIX/LINUX

Posted in reply to DarkAngel

Hi, DarkAngel

Yes, this one is tricky. I assume you have the following environment:

1. You are running EG on your Windows PC.

2. Your EG is connecting to a SAS server on Unix/Linux.

3. You want your SAS code on the SAS server to reference a SQL/Server database. Since SQL/Server only runs on Windows, that's the platform it's on.

Microsoft doesn't provide a native client for SQL/Server on Unix/Linux (unlike EVERY OTHER dbms, something you might want to point out to whoever picked SQL/Server for a mixed environment).

I don't have access to the mixed environment anymore, but the last time I did this I used software from a company called DataDirect (which I believe is the one that SAS tests with). There might be others, I'm not an expert in this.

Setting up the environment on the Unix box is a little funky, but once you get it going it works fine. Here are some links to provide more info.

http://www2.sas.com/proceedings/forum2008/135-2008.pdf

http://support.sas.com/techsup/technote/ts685.pdf

http://www.datadirect.com/products/odbc/unix-linux.html

Tom

New Contributor
Posts: 2

Re: How to connect to sql server from SAS EG on UNIX/LINUX

Thanks very much Tom!! I am not sure whether I will be try to this out as I may not have access to DataDirect. But ,I will check out with the platform team if they do support this.

Contributor
Posts: 39

Re: How to connect to sql server from SAS EG on UNIX/LINUX

Posted in reply to DarkAngel

DarkAngel (funny that fits my handle nicely \m/) I was wondering if you made any headway with this as I'm looking to do the same?

Ask a Question
Discussion stats
  • 3 replies
  • 1393 views
  • 4 likes
  • 3 in conversation