topic Re: what connectors are available for people to get sas data on unix? in SAS Data Management

what connectors are available for people to get sas data on unix?

cellurl — Wed, 30 Sep 2015 17:14:25 GMT

I want to write/buy/steal a connector to read sas data for use in BonitaSoft BPM.

Bonitasoft has connectors for Teradata, Mysql, Oracle,

but they don't have one to SAS.

So what might I do to connect into SAS data?

Can I write a connector or is there a sas program/script that some people use to achieve this?

In my mind, sas could occasionally be treated as a database just as Oracle, etc.

Thanks!

Re: what connectors are available for people to get sas data on unix?

SASKiwi — Wed, 30 Sep 2015 18:54:49 GMT

Does Bonitasoft have a generic ODBC connector ? If so then you may be able to connect to SAS data via ODBC. This assumes you have an operating SAS server environment with the SAS ODBC drivers installed.

Re: what connectors are available for people to get sas data on unix?

mebass — Fri, 02 Oct 2015 14:11:48 GMT

Agreed. If you have SAS/ACCESS software, SAS/ACCESS Interface to ODBC would enable you to connect between SAS and your DBMS. You'll need to have an ODBC driver manager and ODBC-compliant drivers.

Re: what connectors are available for people to get sas data on unix?

LinusH — Sat, 03 Oct 2015 02:28:54 GMT

SAS/ACCESS is for push of data from SAS. My understanding is that the OP wish to pull data from SAS.
Which is handled like @SASKiwi suggests with a SAS server. Typically using SAS/SHARE and a licence for SHARE*NET.
OLEDB might be an alternative if your SAS source is using Intelligence Platform. Search support.Sas.com for relevant documentation.

Re: what connectors are available for people to get sas data on unix?

Patrick — Mon, 05 Oct 2015 23:33:41 GMT

SAS isn't a database but like for a data base in order to access the data you need a SAS server.

Additionally to what @LinusH proposes and depending on SAS components licensed I believe it should also be possible to implement a Web Service which you then call from your application. https://support.sas.com/documentation/cdl/en/itechov/64881/PDF/default/itechov.pdf