Automate OWB Metadata export with OMB+
I regularly make exports of Warehouse Builder Metadata to files. I do this at least once a day. When there are a lot of changes to OWB objects I make the export multiple times a day. I prefer this over snapshots as these exports to file do not fill up the OWB repository. Regular exports are useful to re-import changed objects and to keep track of changes to your objects.
I have written a script to automatically export Warehouse Builder Metadata. The script can be scheduled via Windows AT command.
Adapt the following to your environment and save as OWB_export.tcl
|
1 2 3 4 5 6 7 8 |
OMBCONNECT owb rep_owner/pwd@host:port:service set OMBLOG c:\temp\log.txt set systemTime [clock seconds] set systemTimeFormat [clock format $systemTime -format %Y%M%d-%H%M%S] OMBEXPORT MDL_FILE 'c:\temp\my_project_$systemTimeFormat.mdl' FROM PROJECT 'MY_PROJECT' OUTPUT LOG 'c:\temp\my_project_$systemTimeFormat.log' OMBDISC |
Now open a command prompt and type:
|
1 |
AT 23:30 /EVERY:m,t,w,th,f C:oracleproducts10.2.0owb_1owbbinwin32OMBPlus.bat c:OWB_Export.tcl |
This will schedule to run the script every weekday at 23:30.
