OWB - OMB (Oracle Meta Base) Language

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

1 - About

OMB is :

2 - Article Related

Advertising

3 - IDE

4 - Snippet

5 - Useful Command

Useful Commande Goal Example
[lindex $argv 0] To pass parameter to a OMBPlus Script See expert article for an example
set OMBCONTINUE_ON_ERROR true; To continue on error
set systemTime [clock seconds];
OMBCOMMIT/OMBROLLBACK To Commit or Rollback
Advertising

6 - Code Modularity

To modularize the OMB code, you can use:

  • use the source command to launch an external tcl script (source MyTclScript.tcl)
  • define the procedures in the Procedure Declaration panel of a common expert, and then add the expert into another (nest it), then call the procedure (for example if the expert define procedure PX is defined EX1, and the top level is called EX2, add EX1 into EX2, then in some OMB of EX2, call EX1_ns::PX)

To get a filtered list for instance of all table with KWI in their name:

OMBLIST TABLES '.*KWI.*'

More: Using OMB*Plus to Navigate Repositories - Sample with :

  • OMBCC
  • and OMBDCC

8 - Documentation, Example, Model

Advertising

9 - Reference