The SAS
providers for OLE DB implement data access interfaces that conform
to the OLE DB specification from Microsoft, which is built on the
OLE Component Object Model (COM).
-
The SAS local provider supports
access to Base SAS data sets that are stored on a Windows system.
If you can find a Base SAS data set by using the Windows Explorer,
then you can read it by using the SAS local provider. The local provider
is available in 32-bit and 64-bit versions. On a Windows x64 system,
you can install both versions.
-
The
SAS/SHARE provider supports
access to Base SAS data sets and Scalable Performance Data (SPD) server
data sets via a
SAS/SHARE server, as well as third-party relational
data sources (with licensed
SAS/ACCESS engines). The
SAS/SHARE provider
is available in 32-bit and 64-bit versions. On a Windows x64 system,
you can install both versions.
-
The SAS IOM provider supports access
to Base SAS and SPD Server data sets that are managed by SAS Workspace
Servers, as well as third-party relational data sources (with licensed
SAS/ACCESS engines). The IOM provider is available in 32-bit and 64-bit
versions. On a Windows x64 system, you can install both versions.
-
The SAS OLAP provider implements
the OLE DB for OLAP (ODBO) interface to enable access to cubes that
are managed by SAS OLAP Servers. The OLAP provider is available in
32-bit and 64-bit versions. On a Windows x64 system, you can install
both versions.
-
The Base SAS provider supports
access to Base SAS data sets available through a local installation
of Base SAS, as well as third-party relational data sources (with
licensed
SAS/ACCESS engines). In this context, the Base SAS installation
functions as a local, single-user server. The Base SAS provider is
available in 32-bit. If access is needed to data sets with a local
installation of SAS from a 64-bit application, then, SAS recommends
using the 64-bit version of the
SAS/SHARE provider instead.