-- Phase UAT4_MDM Environment Variables Update
-- Date: 23-07-2019
-- Author: Pooja

-- Navigation key: Menu -> Admin Menu -> 'N' -> 'Navigation Key'
UPDATE mdmadm.CI_MD_NAV SET URL_OVRD='http://uat4.mdm.energy.coop.local/mdm/cm/MDMUAT4.gif' WHERE NAVIGATION_KEY='CM_logoImage';

-- Menu -> Admin Menu -> 'F' -> 'Feature Configuration' -> 
UPDATE mdmadm.CI_WFM_OPT SET WFM_OPT_VAL='http://uat4.ccb.energy.coop.local/ccb/loginPage.jsp' WHERE WFM_NAME='CM-GENSYSCFG';

-- Menu -> Admin Menu -> 'M' -> 'Master Configuration' -> Click on 'Migration Assistant Configuration' (pencil)
UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<configuration><exportDirectory>/u02/ouaf/ouafoutput/MDMUAT4/CCB240_THORCFG/cma/export</exportDirectory><importDirectory>/u02/ouaf/ouafoutput/MDMUAT4/CCB240_THORCFG/cma/import</importDirectory><fileExtension>txt</fileExtension></configuration>' WHERE BUS_OBJ_CD='F1-MigrationAssistantConfig';

-- Menu -> Admin Menu -> Master Configuration -> Generic BI Configuration -> File Path needs to be updated to reflect the environment.
UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<description>Master Configuration for BI</description><generalMasterConfiguration><filePath>/u01/ouaf/ouafoutput/MDMUAT4/D1ExtractFiles</filePath><characterEncoding>UTF-8</characterEncoding></generalMasterConfiguration>' WHERE BUS_OBJ_CD='F1-BIGeneralMasterConfig';

-- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.139:7950' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';		
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7951' WHERE XAI_JNDI_SVR_ID = 'CCB_JNDI';		
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7953' WHERE XAI_JNDI_SVR_ID = 'SGG_JNDI';
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7972' WHERE XAI_JNDI_SVR_ID = 'DM_BOL_JNDI';
UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:7950' WHERE XAI_JNDI_SVR_ID = 'MDM_JMS';