how to create OMPplus script with parameters
714579Aug 3 2009 — edited Aug 5 2009Hi all. I am trying to parameterize my OMB scripts. For now I am only able to pass one type of parameter, For example in the script below I can parameterize the mapping name. So even If I pass 3 mapping names I will import MDX files and deploy for all 3 mappings.
I want to improve this and I want to pass other parameters such as passwords and schema names also. How would I be able to do that? How can I pass different type of parameters such as schema name, password and mapping name and reference to them separately from the script?
set MAPLIST $argv
OMBCONOMBCONNECT DWPROD/DWPROD@cakir:1521:orcl USE REPOSITORY 'OWBDB_SYS'OMBCC 'MY_PROJECT'
OMBCONNECT CONTROL_CENTER
OMBCOMMIT
foreach mapName $MAPLIST {
OMBIMPORT MDL_FILE 'C:/tfsroot2/Interfaces and Extracts/branches/Interfaces and Extracts1.1/000 - OWB Prototype/deploy/ora.stg/mappings/$mapName.mdx' USE UPDATE_MODE MATCH_BY NAMES OUTPUT LOG TO 'C:/tfsroot2/Interfaces and Extracts/branches/Interfaces and Extracts1.1/000 - OWB Prototype/deploy/ora.stg/mappings/$mapName.log'
OMBCOMMIT
}
OMBALTER LOCATION 'XTRCT_DWEXTRACT_LOC' SET PROPERTIES (PASSWORD) VALUES ('PASSWORD')
OMBALTER ORACLE_MODULE 'XTRCT_DWEXTRACT' ADD REFERENCE LOCATION 'XTRCT_DWEXTRACT_LOC' SET AS DEFAULT
OMBALTER ORACLE_MODULE 'XTRCT_DWEXTRACT' SET PROPERTIES (DB_LOCATION) VALUES ('XTRCT_DWEXTRACT_LOC')
OMBCOMMIT
OMBALTER LOCATION 'XTRCT_DWPROD_LOC' SET PROPERTIES (PASSWORD) VALUES ('PASSWORD')
OMBALTER ORACLE_MODULE 'XTRCT_DWPROD' ADD REFERENCE LOCATION 'XTRCT_DWPROD_LOC' SET AS DEFAULT
OMBALTER ORACLE_MODULE 'XTRCT_DWPROD' SET PROPERTIES (DB_LOCATION) VALUES ('XTRCT_DWPROD_LOC')
OMBCOMMIT
OMBREGISTER LOCATION 'XTRCT_DWEXTRACT_LOC'
OMBCOMMIT
OMBREGISTER LOCATION 'XTRCT_DWPROD_LOC'
OMBCOMMIT
OMBREGISTER LOCATION 'DWEXTRACT_INPUT'
OMBCOMMIT
OMBREGISTER LOCATION 'DWEXTRACT_OUTPUT'
OMBCOMMIT
OMBCC 'XTRCT_DWEXTRACT'
foreach mapName $MAPLIST {
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN '$mapName' ADD ACTION 'MAPPING_DEPLOY' SET PROPERTIES (OPERATION) VALUES ('CREATE') SET REFERENCE MAPPING '$mapName'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN '$mapName'
OMBDROP DEPLOYMENT_ACTION_PLAN '$mapName'
OMBCOMMIT
puts "Mapping $mapName deployed"
}
OMBDISCONNECT