Accessing DBMS Data with SAS/ACCESS

A Brief Overview

The SAS/ACCESS interface engine is a tool that enables you to transfer data between a database management system (DBMS) and SAS. SAS can access a variety of DBMS, such as Teradata, Oracle, SQL Server, Greenplum, and so on. This particular interface engine has transparent Read and Write access capabilities, so you might be reading Teradata data and not even realize it.
SAS/ACCESS offers interface engines that enable you to read third-party data. For example, if you need to read data in DB2, there is a SAS/ACCESS Interface engine to DB2. If you need to read Oracle, there is a SAS/ACCESS Interface to Oracle, and an Oracle engine.
Figure 6.1 SAS/ACCESS Technology
When using SAS and working ...

Get SAS Certified Professional Prep Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.