Author Archives: admin

OMBPlus How to Add Data Location –Oracle Warehouse Builder

–OMBPlus create db location
puts “connecting to owb_repos_prod”

OMBCONNECT ETL_User/pass@<db_host>:1511:PS1OID

puts “connected”

puts “Changing context to the production project”

OMBCC ‘ETL_EC’

puts “Connecting to the DEFAULT_CONTROL_CENTER”

OMBCONNECT CONTROL_CENTER

OMBCOMMIT

OMBCREATE LOCATION ‘ETL_OPS_LOC’ SET PROPERTIES (more…)