By default, during deployment
of SAS Model Manager 12.1 on SAS 9.3, the SAS Deployment Wizard creates
and configures the SAS Model Manager database (MdlMgrDB) to use the
SAS Framework Data Server. The database type, user ID, and password
are configured to be the same as the SAS Web Infrastructure Platform
Services (SharedServices or ShrdSvcs) database. The SAS Model Manager
database is used to store operational, historical, and auditing data
for SAS Model Manager.
If you prefer, you can
choose to use a third-party database. There are six types of databases
that SAS Model Manager 12.1 supports. For the SAS Framework Data Server,
MySQL, and Microsoft SQL Server database types, the SAS Model Manager
database is created automatically during the installation and configuration
process, if you chose to automatically configure the database. For
the remaining three database types, PostgreSQL, Oracle, and DB2, the
SAS Model Manager database (MdlMgrDB) must be created manually by
the DBA before completing the Software Deployment Wizard configuration
step.
The SAS Deployment Wizard
can create the tables that are needed by SAS Web Infrastructure Platform
Services and SAS Model Manager. Select the
Automatically
create tables and load data check box to use this feature.
If you prefer to create the tables yourself for the SAS Model Manager
database, then clear the check box and submit the SQL statements after
the wizard finishes running. The SQL statements are in the file CreateMMTables.sql,
which is located in the
SAS-installationdirectory\
SASModelManagerMidTier\12.1\Config\Deployment\Content\dbscript\<database-type>\ directory.
SAS Framework Data Server
cannot be configured manually. But you can choose to configure MySQL
and Microsoft SQL Server manually. Here are the versions of the alternative
databases for SAS Model Manager 12.1 that were used for testing in
SAS 9.3:
-
-
PostgreSQL 8.7, 9.0 and 9.1
-
-
-
Microsoft SQL Server 2008 and 2008
R2
If you prefer to use
a third‐party vendor database instead of SAS Framework Table
Server, then the SAS Model Manager database must be configured with
the tables and data that are needed by SAS Model Manager. The JDBC
connection information for the database must be provided to the SAS
Deployment Wizard. The following information must be provided for
the SAS Model Manager database:
-
Host name of the database server
-
Port number of the database server
or listener
-
Database name or Oracle System
Identifier (SID)
Note: Some databases, such as PostgreSQL
are case sensitive. The database name must be
MdlMgrDB.
-
User ID, password, and schema (if
applicable)
Note: The database user ID, password,
and schema must be the same as they are for the database for SAS Web
Infrastructure Platform Services.
-
Directory location of JDBC drivers
for the database
Note: The SAS Model Manager configuration
uses the same values as the SAS Web Infrastructure Platform Services
database prompts for the SAS Model Manager database, except for the
database name.
For database-specific
information about configuring a database, see the
Configuring
an Alternative Database for SAS® Web Infrastructure Platform
Services Configuration Guide, available at