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