The
SAS Model Manager database is used to store operational, historical,
and auditing data for SAS Model Manager. By default, during deployment
of SAS Model Manager 12.3 on SAS 9.4, the SAS Deployment Wizard creates
and configures the SAS Model Manager database to use the SAS Web Infrastructure
Platform Data Server. You can use another third-party database server
with SAS 9.4. In SAS 9.4 the following third-party database management
systems are supported for the SAS Model Manager database: IBM DB2,
MySQL, Oracle, PostgresSQL, and Microsoft SQL Server. SAS Web Infrastructure
Platform Data Server cannot be configured manually. All of the third-party
database servers must be installed manually. For information about
the versions of the alternative databases that are supported,
see Reviewing Third-Party Database Requirements in SAS Intelligence Platform: Installation and Configuration Guide. The SAS Model Manager
database is created automatically during the installation and configuration
process for the SAS Web Infrastructure Platform Data Server, MySQL,
and Microsoft SQL Server database types. The default name for the
SAS Model Manager database is
MdlMgrDB.
The default database name cannot be changed when using the SAS Web
Infrastructure Platform Data Server, but can be changed when using
a third-party database type. For the remaining database types, PostgreSQL,
Oracle, and IBM DB2, the SAS Model Manager database must be created
manually by the database administrator before completing the Software
Deployment Wizard configuration step.
For the SAS Web Infrastructure
Platform Server, the SAS Model Manager database tables are automatically
created and loaded when the database is created. For third-party database
types, the SAS Deployment Wizard can create and load the tables that
are needed by SAS Web Infrastructure Platform Services and SAS Model
Manager. When using a third-party database type, 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 when using a third-party database type, 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.3\Config\Deployment\Content\dbscript\<database-type>\ directory.
If you prefer to use
a third‐party vendor database instead of SAS Web Infrastructure
Platform Data 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.
-
User ID, password, and schema (if
applicable)
-
Directory location of JDBC drivers
for the database