topic Re: How to test SAS Share from local machine? in SAS Data Management

How to test SAS Share from local machine?

wbaldwin — Mon, 12 Aug 2019 12:50:33 GMT

We have SAS 9.4M5 running on Linux environment with SAS Share installed/configured. I'm trying to test to see if our SAS Share library is available outside of SAS tools (third party software). I have downloaded the SAS Share JDBC Drivers for Windows 64 to my local machine already. Now, I'm trying to figure out way to test Share connections... I want to test from my local laptop using jdbc driver I downloaded/install and test if my jdbc url is working/correct. Any suggestion on how I can accomplish this? Thank You!

Re: How to test SAS Share from local machine?

TomKari — Mon, 12 Aug 2019 13:10:34 GMT

My first thought is Microsoft Access; my second thought is Excel.

Tom

Re: How to test SAS Share from local machine?

AnandVyas — Mon, 12 Aug 2019 13:19:35 GMT

Hi @wbaldwin,

Link below to sgf paper has steps on how you can use java applications to invoke SAS using SAS/SHARE Driver for JDBC.

http://support.sas.com/resources/papers/proceedings10/017-2010.pdf

Thanks!

Re: How to test SAS Share from local machine?

LinusH — Wed, 14 Aug 2019 13:56:01 GMT

Not sure about JDBC connections, but for ODBC connections, you need the additional SAS license SHARE*NET.