SAS Model Manager enables
you to publish the project champion model and challenger models that
are associated with the
DATA Step score code
type to a configured database. Publishing PMML models to a database
is not supported. SAS Model Manager uses the SAS Scoring Accelerator
and
SAS/ACCESS interface to the database to publish models to the
database. The Scoring Accelerator takes the models from SAS Model
Manager and translates them into scoring files or functions that can
be deployed inside the database. After the scoring functions are published
using the
SAS/ACCESS interface to the database, the functions extend
the database’s SQL language and can be used in SQL statements
such as other database functions. After the scoring files are published,
they are used by the SAS Embedded Process to run the scoring model.
The SAS administrator
can enable the
Publish Scoring Options setting
in SAS Management Console to indicate that the metadata tables be
populated in the target database when publishing a scoring function.
If this setting is enabled and the scoring function publish method
is chosen, the scoring metadata tables in the database are populated
with information about the project and pointers to the scoring function.
This feature enables users to review descriptions and definitions
of the published model. The audit logs track the history of the model's
usage and any changes that are made to the scoring project.
This tutorial shows
you the tasks that are involved in publishing a project champion model
or challenger model to a database. It contains examples and step-by-step
directions about preparing a database for use with SAS Model Manager
and publishing a model.
Note: The examples that are used
in this tutorial use the Teradata database type for publishing a model
to a database. You can also use this tutorial to publish a model to
a DB2, Greenplum, Oracle, or Netezza database.