SAS in-database products
integrate SAS solutions, SAS analytic processes, and third-party database
management systems. Using SAS in-database technology, you can run
scoring models, some SAS procedures, DS2 threaded programs, and formatted
SQL queries inside the database. When using conventional processing,
all rows of data are returned from the database to SAS. When using
SAS in-database technology, processing is done inside the database
and thus does not require the transfer of data.
To perform in-database
processing, the following SAS products require additional installation
and configuration:
-
SAS/ACCESS Interface to Aster,
SAS/ACCESS Interface to DB2, SAS/ACCESS Interface to Greenplum, SAS/ACCESS
Interface to Hadoop, SAS/ACCESS Interface to Netezza, SAS/ACCESS
Interface to Oracle, SAS/ACCESS Interface to SAP HANA, and SAS/ACCESS
Interface to Teradata
The SAS/ACCESS interfaces
to the individual databases include components that are required for
both format publishing to the database and for running Base SAS procedures
inside the database.
-
SAS Scoring Accelerator for Aster,
SAS Scoring Accelerator for DB2, SAS Scoring Accelerator for Greenplum,
SAS Scoring Accelerator for Hadoop, SAS Scoring Accelerator for Netezza,
SAS Scoring Accelerator for Oracle, SAS Scoring Accelerator for SAP
HANA, and SAS Scoring Accelerator for Teradata
-
SAS In-Database Code Accelerator
for Greenplum, SAS In-Database Code Accelerator for Hadoop, and SAS
In-Database Code Accelerator for Teradata
-
SAS Analytics Accelerator for Teradata
-
SAS Data Loader for Hadoop
-
SAS Data Quality Accelerator for
Teradata
-
SAS Model Manager In-Database Scoring
Scripts
Note: The SAS Scoring Accelerator
for SPD Server does not require any additional installation or configuration.