How to test SAS Share from local machine?

[wbaldwin]

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! 

[TomKari]

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

Tom

[AnandVyas]

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!

[LinusH]

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