How the SAS Scoring Accelerator for Teradata Works
Using
SAS Enterprise Miner, you can generate SAS DATA step code that contains
scoring functions. The SAS Scoring Accelerator for Teradata takes
the scoring model code, the associated property file that contains
model inputs and outputs, and a catalog of user-defined formats, and
deploys, or publishes, them to the Teradata EDW. Inside the Teradata
EDW, one or more scoring functions are created and registered for
use in SQL queries. Figure 1.1 illustrates this process.
Process Flow Diagram
1Install the components that are necessary for in-database processing in the Teradata EDW.
For more information,
see Overview of Deployed Components for In-Database Processing.
2Use SAS Enterprise Miner to create a scoring model,
and use the Score Code Export node to export files that are used to
create the scoring functions to a score output directory.
For more information,
see Exporting the Scoring Model Files from SAS Enterprise Miner.
3Start SAS 9.2 and run the SAS publishing macros, which
create the files that are needed to build the scoring functions and
publish those files to the Teradata EDW.
For more information,
see Publishing the Scoring Model Files.
4After the scoring functions are created, they are available
to use in any SQL expression in the same way that Teradata built-in
functions are used.
For more information,
see Scoring Functions Inside the Teradata EDW.