8.5.1 Configuring the Investment Configuration Metadata Migration Utility

The <OFSAAI Installed Directory>/database/db_tools/mantas_cfg/install.cfg file contains common configuration information that Investment Configuration Metadata Migration Utility and other utilities require for processing.

The following example provides sample information from the install.cfg file that is specific to this utility. This utility migrates data for the following tables:

• KDD_ACTIVITY_TYPE_CD
• KDD_ACTVY_TYPE_REVIEW_STATUS
• KDD_SCNRO_CLASS_ACTVY_TYPE
• KDD_ACTVY_TYPE_RSTRN
• KDD_ACTVY_CAT_CD
• KDD_CMMNT
• KDD_SCNRO_CLASS_CMMNT
• KDD_CMMNT_CAT_CD
• KDD_REVIEW_STATUS
• KDD_ACTIVITY_RESULT_STATUS
• KDD_EXTRL_REF_SRC
• KDD_FOCUS_ALERT_ASGMT
• KDD_AUTO_CLOSE_ALERT
• KDD_BUS_DMN
• KDD_JRSDCN
• KDD_COUNTER
• KDD_CAL_HOLIDAY
• KDD_CAL_WKLY_OFF
• KDD_REPORT_TEMPLATE
• KDD_REPORT_TEMPLATE_PARAM
• KDD_REPORT_DEFN
• KDD_REPORT_DEFN_PARAM
• KDD_REPORT_TEMPLATE_JRSDCN
• KDD_AVERTED_LOSS_TYPE
• KDD_REG_REPORT_TYPE
• KDD_REG_REPORT_STATUS

#### EXTRACT (These properties are shared by IMCM with the Scenario Migration
      Utility)
# Specify the database
      details for extraction extract.database.username=${utils.database.username}
      extract.database.password=${utils.database.password
 
# Specify the jdbc driver details for connecting to the source database
      extract.conn.driver=${database.driverName
extract.conn.url= jdbc:oracle:oci:@T2O9S8 #Source System Id
extract.system.id= TEST_ENVIORNMENT # File Paths for Extract
#Specify the full path in which to place extracted Correlation Rules
      extract.dirname=/users/oriont/Mantas5.8/database/db_tools/data
#### LOAD (These properties
      are shared by IMCM Utility with the Scenario Migration Utility) #Target System
      ID
load.system.id=
      PROD_ENVIRONMENT
# Specify whether or not to verify the target environment on load

Note:

This script is part of the Database Tools that reside in the <OFSAAI Installed Directory>/database/db_tools/bin directory.