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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
