The following tables describe unique properties for SAS Model Manager that the SAS Migration Utility uses when creating a migration analysis report or when building a migration package. To use these properties, add them to your migration utility properties file. In the SAS Deployment Wizard, the database is named “SAS Model Manager Database” for SAS Model Manager 12.3, and it is named “SAS Decision Manager Database” for SAS Model Manager 13.1 and later. For more information, see “Running the Migration Utility Using a Properties File” on page 150.
The values for the SAS Migration Utility properties can be found in SAS Management Console. Select the Folders tab and expand System ð Applications ð SAS Model Manager Mid-Tier. Select the Model Manager Mid-Tier <version> folder, right-click the Model Manager-Mid-Tier <version> application object, and then select Properties ð Configuration. The prefix for the configuration properties that are equivalent to the SAS Migration Utility properties is dbms.mmapi. For more information, see SAS Model Manager: Migration Guide.
This topic contains the following Model Manager migration utility properties:
• mmapi.dbms.data.name
• SMU.mmapi.dbms.userid
• SMU.mmapi.dbms.password
• mmapi.data.dbms.type
• SMU.mmapi.dbms.host
• SMU.mmapi.dbms.port
• SMU.mmapi.jdbc.driver
The following table describes the mmapi.dbms.data.name property:
Table A3.10 mmapi.dbms.data.name Property
Property mmapi.dbms.data.name
The configuration property in SAS Management Console is named dbms.mmapi.name.
Examples mmapi.dbms.data.name=MdlMgrDB
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid database name with which the migration utility can use a JDBC connection to access the database.
The following table describes the SMU.mmapi.dbms.userid property:
Table A3.11 SMU.mmapi.dbms.userid Property
Property SMU.mmapi.dbms.userid
The configuration property in SAS Management Console is named dbms.mmapi.userid.
Examples SMU.mmapi.dbms.userid=myDatabaseUserID
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid user ID with which the migration utility can use a JDBC connection to access the database.
The following table describes the SMU.mmapi.dbms.password property:
CAUTION:
We recommend that you encode any passwords used in a migration utility properties file. The migration utility supports the {sas002} method through PROC PWENCODE. For more information, see “PWENCODE” in Base SAS Procedures Guide.
Table A3.12 SMU.mmapi.dbms.password Property
Property SMU.mmapi.dbms.password Examples SMU.mmapi.dbms.password
={SAS002}DBCC571245AD0B31433834F80BD2B99E16B3C969
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
The password for the user ID with which the migration utility uses a JDBC connection to access the SAS Model Manager database. You can use regular text or encode the password using PROC PWENCODE and the {sas002}
method.
Table A3.13 mmapi.data.dbms.type Property
Property mmapi.data.dbms.type
The configuration property in SAS Management Console is named dbms.mmapi.type.
Examples mmapi.data.dbms.type=oracle
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid database type with which the migration utility can use a JDBC connection to access the database.
Table A3.14 SMU.mmapi.dbms.host Property
Property SMU.mmapi.dbms.host
The configuration property in SAS Management Console is named dbms.mmapi.host.
Examples SMU.mmapi.dbms.host=myDatabaseHost
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid host name with which the migration utility can use a JDBC connection to access the database.
Table A3.15 SMU.mmapi.dbms.port Property
Property SMU.mmapi.dbms.port
The configuration property in SAS Management Console is named dbms.mmapi.port.
Examples SMU.mmapi.dbms.port=1521
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid port number with which the migration utility can use a JDBC
connection to access the database.
Table A3.16 SMU.mmapi.jdbc.driver Property
Property SMU.mmapi.jdbc.driver
The configuration property in SAS Management Console is named dbms.mmapi.jdbc.dir.
Examples SMU.mmapi.jdbc.driver =“C:\SAS\Config\Lev1\Web\Applications
\SASWIPServices9.4\JDBCDrivers\"
SMU.mmapi.jdbc.driver=/data/install/oracle_jdbc
When to Use For use when migrating SAS Model Manager 12.3 or later to the same version or a later version.
To export the SAS Model Manager database to the migration package. Specify a valid directory path to the database JDBC driver JAR files.