About This Document

This document provides conceptual, reference, and usage information for SAS/ACCESS software for data sources for relational database management systems (DBMSs), data warehouse appliances, and Hadoop Distributed File System (HDFS). The information in this document applies to all data sources that SAS/ACCESS software supports.
The availability and behavior of SAS/ACCESS features vary from one interface to another. You should therefore consult the information in both the general and DBMS-specific sections of this document when working with your particular SAS/ACCESS interface. You should also refer to the SAS system requirements and configuration guide documents that are available at http://support.sas.com.
This document is intended for applications programmers and end users with these skills.
  • They are familiar with the basics of their DBMS or data warehouse appliance and its Structured Query Language (SQL).
  • If they are using Hadoop, they are familiar with Hadoop and the Hadoop Distributed File System (HDFS). They have knowledge of fundamental Hadoop library and processing using HDFS. They are also familiar with the basics of Hadoop, Hive, and HiveQL. For details, see the Apache Hadoop and Hive Web sites at http://hadoop.apache.org and https://cwiki.apache.org/confluence/display/Hive.
  • They know how to use their operating environment.
  • They can use basic SAS commands and statements.
Database administrators might also want to read this document to understand how to implement and administer specific interfaces.