Additional configuration steps are required to prepare
a data management system (database or file system) for publishing
and scoring in SAS Model Manager if you plan to use the scoring function
(MECHANISM=STATIC) publish method or the SAS Embedded Process (MECHANISM=EP)
publish method. If you want to store the scoring function metadata
tables in the database, then 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.
During the installation
and configuration of SAS 9.4 products, the SAS Model Manager In-Database
Scoring Scripts product is installed on the middle-tier server or
another server tier if it is included in the 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
The script installation
directory includes a directory that specifies the version of SAS Model
Manager (currently 14.2). 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.
If your system is configured
for Kerberos authentication for Hadoop or Teradata, each user must
have a valid Kerberos ticket. You must also complete post-installation
configuration steps to enable users to publish models from the SAS
Model Manager web application. For more information, see
SAS Model Manager: Administrator’s Guide.