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:
- Teradata
- Aster Data
- Cloudera Impala
- Datacom
- Greenplum
- Netezza
- Vertica
- Informix
- SAP HANA, SAP R3, SAP ASE, SAP IQ
- DB2
- Oracle and Oracle RDB
- PostgreSQL
- Microsoft SQL Server
- MySQL
- Amazon Redshift
- JDBC
- Spark SQL – SAS Viya
- ODBC
- OLE DB
SAS/ACCESS® for mainframes
- Supported mainframe sources include:
- SAS/ACCESS® Interface to ADABAS
- SAS/ACCESS® Interface to DATACOM/DB
- SAS/ACCESS® Interface to CA IDMS™
- SAS/ACCESS® Interface to IMS-DL/I
SAS/ACCESS® for NoSQL data platforms
- SAS/ACCESS® Interface to the PI System
SAS/ACCESS® for distributed file systems
- One supported distributed file system source is SAS/ACCESS® Interface to Hadoop
SAS/ACCESS® Interface to PC Files
- SAS/ACCESS Interface to PC Files includes access to:
- DBF
- DIF (Unix)
- XLS (Windows)
- WK1
- WK3
- WK4
- XL
- SX
SAS/ACCESS® for nonrelational sources
- SAS/ACCESS® Interface to Big Query
- SAS/ACCESS® Interface to MongoDB
- SAS/ACCESS® Interface to Salesforce
- SAS/ACCESS® Interface to Snowflake
- SAS/ACCESS® Interface to Azure
- SAS/ACCESS® Interface HDInsight