topic SAS/Access - Engine in SAS Data Management

SAS/Access - Engine

manasiarora — Thu, 16 Jun 2011 13:58:28 GMT

Hi,

I'm new to SAS. Have recently purchased SAS 9.2 along with SAS/ACCESS for SQL Server and ODBC.

I was wondering if SAS/ACCESS has a SDK that one can use to build a new connector to a custom DB. i do not want to use the ODBC connector provided by SAS as i want to be able to perform some custom tasks that are not generally provided by generic ODBC.

Thanks in advance
Manasi

Re: SAS/Access - Engine

Patrick — Fri, 17 Jun 2011 11:46:42 GMT

Hi

I might be wrong but isn't the SAS ODBC driver for accessing SAS files from other applications via ODBC?

If so then the ODBC provider for a data base would be distributed by the data base vendor and not by SAS.

What the SAS/Access engine to ODBC does is translating SAS code into ODBC syntax, sending this code to the ODBC provider (via a connector possibly) and retrieve the response.

You sure can't modify the SAS/Access engine as this is not open source ....

By the way:
This question is better asked in the SAS Macro Facility.... forum as this is the most technical one.

HTH
Patrick

SAS/Access - Engine

Ksharp — Tue, 28 Jun 2011 07:24:33 GMT

SAS/ACCESS does not has a SDK.But you can use JDBC of SAS for Java to connect to SAS library.

Or If your comany purchase integrated technology ,then you can develop some client software to talk to sas by Java , .NET , VB....

Or If your company has purchased SAS/CONNECT SAS/SHARE ,you also can connect to sas dataset.

Ksharp