SAS Model Manager enables
you to publish models that are associated with the
Data
Step score code type to a configured database. When you
publish a scoring function for a project, SAS Model Manager exports
the project's champion model to the SAS Metadata Repository. The SAS
Scoring Accelerator then creates scoring functions in the default
version that can be deployed inside the database based on the project's
champion model score code. The scoring function can be validated automatically
against a default train table to ensure that the scoring results are
correct. A scoring application or SQL code can then execute the scoring
functions in the database. The scoring functions extend the database's
SQL language and can be used in SQL statements in the same way as
other database functions.
For more
information, see Publish Scoring Functions in SAS Model Manager: User's Guide.
This tutorial shows
you the tasks that are involved in publishing a project champion 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 scoring function.
Note: The examples that are used
in this tutorial are for publishing a scoring function to a Teradata
database. You can also use this tutorial to publish a scoring function
to a DB2, Greenplum, or Netezza database.