PDA

View Full Version : New open source project: OWBScripts



ngoodman
11-30-2006, 01:16 AM
I hadn’t had a chance to post yet, but Mark made mention of it on his blog (http://www.rittman.net/2006/11/26/new-seminar-dates-new-articles-and-odds-ends/) so I figure it’s about time to post about it.
OMB (http://www.oracle.com/technology/obe/obe_bi/Lesson14_Extending_OWB_through_Scripting/Extending_OWB_through_Scripting.htm) is the TCL based scripting language that comes with Oracle Warehouse Builder (http://www.oracle.com/technology/products/warehouse/index.html) that allows you to do OWB “things” programatically (ie, without the GUI). It is very useful for doing ETL generation, mass updates, deploying mappings, etc. Basically, anything that you are doing repetitively is a good candidate for making into an OMB script. OMB is a cure for “tennis elbow” from clicking hours on end in the OWB GUI.
I’ve released a handful of OMB scripts (http://sourceforge.net/project/showfiles.php?group_id=181793) that I used on consulting gigs, presentations, articles, etc. There is nothing spectacular here, but hey, they’re not doing me any good! If just one or two people find them useful it was worth the time to slap the Apache 2.0 license (http://www.opensource.org/licenses/apache2.0.php) and upload them to http://sourceforge.net.
The release (http://sourceforge.net/projects/owbscripts) (initial and only unless someone else out there wishes to take on the management/augementation) includes scripts to:
a) Generate base SOURCE to STAGING Truncate/Staging mappings and tables.
b) Generate base STAGING to WAREHOUSE Insert/Update mappings, tables, and sequences.
c) Install repository and the standard CIF targets (Staging, Warehouse, AreaMart).
Let me know what you think and I do hope someone, somewhere finds it useful!
PS - I haven’t used OWB for nearly 9 months. For something I used day in day out for YEARS that’s a long time to have not even touched it!


More... (http://www.nicholasgoodman.com/bt/blog/2006/11/26/new-open-source-project-owbscripts/)