OWB 11gR2 – Collections
By David Allan on Jul 27, 2010
There's a quick way to build up a collection of objects in OWB 11gR2 its worth mentioning. My repository projects are as unorganized as my desktop (its very messy, but I can just about see the Yosemite photo), so using collections is a way I can quickly add some organization for use in a variety of ways; from an organization of content perspective to performing actions on those objects (MDL export, deploy etc.).
So now you can simply multi select the objects you want in the tree and add to a new collection or an existing one, below I am selecting 3 modules and adding into a new collection.
You will then get prompted for the collection name.
Which then creates the collection with the shortcuts to the selected objects.
I can then add in other arbitrary objects into the collection by selecting and adding to the existing named collection.
I can then select the collection in the tree, and use File->Export->Warehouse Builder Metadata and export to file for example.
For me this is much nicer than before (where there was a dialog with a shuttle, go find your stuff, painful), so I like it and thought its worth sharing - besides the fact that the documentation is wrong.