SAS/ACCESS® Software Features

Seamless, transparent data access

  • Broad access to data through an intuitive interface, regardless of where it’s stored.
  • Support for a wide range of databases and platforms, including big data databases, relational stores, data warehouses, mainframe sources and PC files.
  • Easy integration with popular platforms without detailed knowledge of the database or SQL.
  • Option of working in SAS or SQL with automatic generation of the appropriate SQL statements, passed through to the database for execution.
  • Support for integration standards outside of the dedicated SAS/ACCESS module, including SAS/ACCESS Interface to ODBC, SAS/ACCESS Interface to JDBC and SAS/ACCESS Interface to OLE DB.
  • Ability to execute procedural language, complementing SQL-based statement logic.
  • High level of security with native database security mechanisms.
  • Option to import or export data from a PC file to a SAS data set, as well as the ability to read and write directly to PC files.
  • DBMS metadata can be accurately maintained within the SAS Metadata Repository for metadata reuse.

Flexible query language support

  • Seamlessly access data with minimal knowledge of the data or the SQL required to surface it.
  • Take more control by using your own customer SQL statements to modify or maintain automatically generated SQL.
  • Map SAS specific statements or functions to database-specific statements or functions and process SQL statements directly inside the database for optimal performance.
  • Enlist a SAS extension to process the appropriate query logic using the SAS or database engine.

Performance tuning options

  • Take advantage of a multithreaded read interface, as well as threaded kernel technology and native APIs to Oracle, DB2 Spark and Teradata.
  • Enable federated views through optimized read and write, including buffering, compression, threading, chunking, and sort and join performance.
  • Join processing is automatically pushed into the database.
  • Boost performance with temporary table support.
  • Work effortlessly with seamless interfaces to loaders and utilities without an in-depth understanding of each loader.
  • Use PROC TRANSPOSE pushdown capability for Teradata and Hadoop.
  • Use PROC pushdown capability for Amazon Redshift, Postgres, Microsoft SQL Server and metadata integration.
  • Maintain DBMS metadata within the SAS metadata repository, and reuse data jobs.
  • Use jobs across a variety of SAS solutions, including SAS® Enterprise Guide® and SAS Data Management.
  • Use native storage options, including support for temporary tables, materialized views and partitioned tables.
  • Make use of native database types that translate the source database to the appropriate SAS data type.
  • Increase database performance with processor threads, placing data into a memory buffer between reads.
  • National language support.

Optimization features for better performance

  • Use pipeline read to increase database read performance by up to 30 percent via a processor thread that reads data from a database and places it into a memory buffer. Pipeline read is available in SAS/ACCESS Interface to DB2 (non-z/OS), SAS/ACCESS Interface to Greenplum, SAS/ACCESS Interface to Oracle and SAS/ACCESS Interface to Teradata.
  • Improve efficiency with native storage options, including temporary tables, materialized views and partitioned tables.
  • Speed processing with native database types, which are automatically translated to the appropriate SAS data type.

SAS/ACCESS® for databases

  • SAS/ACCESS interfaces to relational databases and database appliances include:
    • Amazon Aurora (MySQL engine)
    • Amazon Aurora (Postgres engine)
    • Amazon RDS MariaDB
    • Amazon RDS Microsoft SQL Server
    • Amazon RDS MySQL
    • Amazon RDS Oracle
    • Amazon RDS PostgreSQL
    • Amazon Redshift
    • Azure Database for MySQL
    • Azure Database for PostgreSQL
    • DB2
    • Google BigQuery
    • Google Cloud Platform Cloud SQL for PostgreSQL
    • Google Cloud Platform Cloud SQL MySQL
    • Greenplum
    • Hive
    • IBM Integrated Analytics System (IIAS)
    • Informix
    • JDBC
    • MariaDB
    • MemSQL
    • Microsoft Azure SQL Database
    • Microsoft Azure SQL Database managed instance
    • Microsoft SQL Server
    • MySQL
    • Netezza
    • ODBC
    • OLE DB
    • Oracle
    • Oracle Cloud Platform Oracle
    • PostgreSQL
    • SAP ASE
    • SAP HANA
    • SAP R3
    • Snowflake
    • Teradata
    • Teradata Database on Amazon Web Services
    • Teradata Database on Microsoft Azure
    • Teradata Database on VMware
    • Vertica

SAS/ACCESS® for mainframes

  • Supported mainframe sources include:
    • SAS/ACCESS® Interface to IMS-DL/I

SAS/ACCESS® for distributed file systems

  • SAS/ACCESS® Interface to Hadoop
  • Amazon EMR
  • Cloudera Distribution of Hadoop
  • Hortonworks Data Platform
  • MapR
  • Microsoft Azure HDInsight

SAS/ACCESS® Interface to PC Files

  • SAS/ACCESS® Interface to PC Files includes access to:
    • DBF
    • DIF (Unix)
    • SX
    • WK1
    • WK3
    • WK4
    • XL
    • XLS (Windows)

SAS/ACCESS® for nonrelational sources

  • SAS/ACCESS® Interface to MongoDB
  • SAS/ACCESS® Interface to the PI System
  • SAS/ACCESS® Interface to Salesforce