OWB - OMB Data Dictionary / Properties

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

When you need to create OMB script, you need to know the properties that you can modify. The documentation is really difficult to read and sometimes miss some properties. The script below gives you a way to create a dictionary op all properties from all class (object) that contain OWB.

Advertising

3 - What properties can be used

The model page below was first construct with this script.

set model OWB
set classes [OMBDESCRIBE MODEL '$model' GET CLASS_DEFINITIONS]
foreach class $classes {
puts “############### Class: $class ###############”
puts “— Properties:”
set props [OMBDESCRIBE CLASS_DEFINITION '$class' GET PROPERTY_DEFINITIONS]
foreach prop $props {
puts “—— $prop”
}
}

The result is here: OWB - OMB Class Properties Definition

4 - Reference