OWB 11gR2 – Collections

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.

image

You will then get prompted for the collection name.

image

Which then creates the collection with the shortcuts to the selected objects.

image

I can then add in other arbitrary objects into the collection by selecting and adding to the existing named collection.

image

I can then select the collection in the tree, and use File->Export->Warehouse Builder Metadata and export to file for example.

image

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.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today