The SAS Model
Manager In-Database Scoring Scripts product must be installed before
the database administrator (DBA) can prepare a database for use with
SAS Model Manager. Additional configuration steps are required to
prepare the database for publishing and scoring in SAS Model Manager.
During the installation
and configuration of SAS 9.3 products, the SAS Model Manager In-Database
Scoring Scripts product is installed on the middle-tier server or
another server tier using a custom plan file.
The location of the
SAS installation directory is specified by the user. Here is the default
installation location for the SAS Model Manager In-Database Scoring
Scripts product on a Microsoft Windows server:
C:\Program
Files\SASHome\SASModelManagerInDatabaseScoringScripts
In the script installation
directory, includes a directory that specifies the version of SAS
Model Manager, which is currently 3.1. The files and subdirectories
that are needed to prepare a database for use by SAS Model Manager
are located in the version directory. The
Utilities
subdirectory
contains two SQL scripts for each type of database: a Create Tables
script and a Drop Tables script. The DBA needs these SQL scripts to
create the tables needed by the SAS Model Manager to publish scoring
functions.
Note: The database tables store
SAS Model Manager metadata about scoring functions.