By David Allan on Jul 15, 2013
The OWB 18.104.22.168 Cumulative Patch 3 has just been released, the bug/patch number is 16568042. This cumulative patch wraps a number of bugs from customers using the OWB 11gr2 release. See the patch readme for details.
At the recent DOAG conference in November 2011, Maren Eschermann from Trivadis presented a session on Dimensional Modeling with OWB 11gR2. Maren has kindly posted an English translation of the presentation and paper, both well worth reading where she provides some valuable opinions on the features and how to get the most from them.
There’s a lot of useful stuff in there, thank you for sharing Maren!
There were a lot of OWB sessions at DOAG, another interesting geographic statistic is from the ‘owbland’ Sourceforge project, if you look at the download statistics there have been 2300 downloads of files from that project in the past 14 months, not bad….good job Oleg. Also interesting statistics on the top countries with downloads, no surprises…Germany and Netherlands!
So quite some activity, if you get time have a read through the paper and presentation on Dimensional Modeling with OWB 11gR2, and thanks again Maren.
The OWB 22.214.171.124 clients for Windows and Linux 64-bit clients are now on OTN for download at the link below;
You should now see a line for the Oracle Warehouse Builder 11g Release 2 (126.96.36.199.0) Standalone Software and links for Linux and Windows 64-bit downloads.
The software can also be downloaded from Oracle Support as described in this post.
In addition to the integrated release of OWB in the 188.8.131.52 Oracle database distribution, the following 64-bit standalone clients are now available for download from Oracle Support.
This is in addition to the previously released 32-bit client on Windows.
The support document Major OWB 184.108.40.206 New Features Summary has details for OWB 220.127.116.11 which include the following.Exadata v2 and oracle Database 11gR2 support capabilities;
Integration with Fusion Middleware capabilities;
Lots of interesting capabilities in 18.104.22.168 and the availability of the 64-bit client I'm sure is welcome news for many!
The leveraging XDB post (here) from a few years ago is one of the most actively read posts, since that was done there have been a few more updates on the expert posted within it. One of the updated areas was in the generation of XML using the Oracle Database using the expert., the areas include supporting generated a single document vs multiple documents and the ability to include/exclude attributes from the content, plus whether to create the attributes as XML properties or XML elements.
A recent query was regarding how the ‘Create XML from objects’ menu option gets created. This is added just by enabling the expert on the ‘Tables’ node in the tree, here we see the sequence of actions to do this in OWB 11gR2, you must first import the expert’s MDL, then add the expert to the tree as follows.
First right click on Tables node and select ‘Maintain Creation Experts Here' (you can add any of your own custom experts to parts of the tree also);
Then in the XML_ETL folder within public experts, enable the CREATE_XML_FROM_OBJECTS expert;
That’s it! Now you can run the expert from the tree. For example now click on the Tables node, you will see the ‘Create XML from objects’ option.
This then runs the expert, the dialog was enhanced to include a ‘Generate Root’ option – this was added so that all generated XML fragments are wrapped in a single element rather than created as XML documents. Using this lets you generate one document like;
rather than multiple documents like (where Department is the route node);
So let’s select ‘Generate Root’ and see how it works….
As before we get to enter the name of the pluggable map that gets generated.
We then choose the tables for or document, and order the master to the detail, we will have departments and the employees nested inside the department;
We then can define the element name for the root (because we selected generate root), and the dept and emp tables.
For each table we can then define the XML element/attribute names for the columns also, we can also define whether to exclude attributes, or define an element name for the attribute rather than a property name.
For the EMP XML element details we will exclude the foreign key column DEPTNO, and provide nice business names for the properties.
After this, the pluggable mapping is generated. We can use the table function from the earlier post and the pluggable mapping to write the XML to file, for example we generate the following from the SCOTT schema.
Fairly simple example of leveraging the database along with experts to generate based on some basic inputs from the guided expert.
There's a revised edition of the Bob Griesemer OWB book from Packt Publishing - Oracle Warehouse Builder 11gR2: Getting Started 2011. It's a good book for beginners and leads you through the basics of building an OWB project using OWB 11gR2 with a mixture of data sources including Oracle and Microsoft SQL Server. Its easy to follow and is essentially a tutorial for those new to the tool. Its always interesting reading different users views on what they use and what is important. The book includes updated information including the new user interface and code template mappings amongst others.
The book is here: https://www.packtpub.com/oracle-warehouse-builder-11g-r2/book
Here’s a data model of the OWB runtime audit views, useful to see the relationships of the audit information recorded in OWB when looking at the runtime audit views documentation.
A high level overview as you see, useful to pick up the basics.
ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.