SAS/ACCESS Software

An out-of-the-box solution for integrating SAS^® and third-party databases.

Support business decisions with data that's complete, consistent, up-to-date and accurate.

Give technical and business users fast, easy access to the data they need.

SAS connectivity provides seamless access to more than 60 data sources. With our out-of-the box solution, business users can use the technology with minimal training. Technical users who want more control can interact directly with the data source using native interfaces, such as SQL. The software passes database queries, joins and other functions to the target data source, reducing network traffic and speeding data processing times. Native bulk-load utilities enable even faster load times.

Get direct, secure access with native interfaces and integration standards.

Get easy, highly secure access to source data – no custom coding or expertise in SQL or other query languages required. The software honors the native security of the target data source and provides transparent access by making data sources appear as though they are a native SAS data type. This facilitates integration across sources and with SAS procedures, SAS DATA step and SAS solutions. The SAS connectivity engines are tightly integrated and used by all SAS solutions for third-party data integration. Supported integration standards include ODBC, JDBC and OLE DB.

Key Features

Seamless, transparent read, write and update access to data, regardless of source or platform.

View detailed features list

View data sources

Seamless, transparent data integration

Access the most popular databases on common platforms without detailed knowledge of the database or SQL.

Flexible SQL support

Supports two native integration methods – LIBNAME engine and pass-through facility. Both map SAS statements or functions to source database-specific statements or functions, and process all appropriate SQL directly inside the database for optimal performance.

Temporary table support

Multiple SAS processes can create and access temporary tables, providing performance gains when the same data is repeatedly required for different steps in a single session.

Bulk loading & other performance features

Supports multiple options for moving refined data from SAS into third-party data stores, including bulk loading, support for automatic partitioning, ability to pass functionality to the database and ability to directly control processing. Where SAS embedded process is deployed in selected databases, it can provide fast parallel movement of data into SAS Viya for advanced analytical processing.

Metadata integration

Supports easy reuse of DBMS metadata for multiple analytical purposes.

Data integrity & security

Accepts encoded DBMS passwords so they don't appear as clear text in SAS programs. Supports single sign-on (SSO) authentication in many of the listed data sources – for example, through Azure Active Directory.