Category Archives: OWB Knowhow

Oracle Warehouse Builder Knowhow, ODI

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…)

Set up view for OWB processing

——————————————————–
—  DDL for View ETL_WB_RT_AUDIT_PARAMETERS
——————————————————–

CREATE OR REPLACE FORCE VIEW “USER_NAME”.”ETL_WB_RT_AUDIT_PARAMETERS” (“AUDIT_PARAMETER_ID”, “AUDIT_EXECUTION_ID”, “PARAMETER_NAME”, “PARAMETER_TYPE”, “PARAMETER_KIND”, “PARAMETER_MODE”, “PARAMETER_SCOPE”, “VALUE_MODE”, “BOUND_TO_ID”, “IS_REQUIRED”, “IS_FIXED”, “PARAMETER_UOID”, “VALUE_KIND”, “CLOB_VALUE”, “VALUE”, (more…)