Monday Jul 15, 2013


The OWB 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. 

Monday Jan 09, 2012

OWB 11gR2 - Dimensional Modeling Paper

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.

Wednesday Dec 14, 2011

OWB 11gR2 – Windows and Linux 64-bit clients on OTN

The OWB 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 ( 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.

Monday Nov 28, 2011

OWB 11gR2 - Windows and Linux 64-bit clients available

In addition to the integrated release of OWB in the Oracle database distribution, the following 64-bit standalone clients are now available for download from Oracle Support.

  • OWB Standalone client for Windows 64-bit - 13365470
  • OWB Standalone client for Linux X86 64-bit - 13366327

This is in addition to the previously released 32-bit client on Windows.

  • OWB Standalone client for Windows 32-bit - 13365457

The support document Major OWB New Features Summary has details for OWB which include the following.

Exadata v2 and oracle Database 11gR2 support capabilities;
  • Support for Oracle Database 11gR2 and Exadata compression types
  • Even more partitioning: Range-Range, Composite Hash/List, System, Reference
  • Transparent Data Encryption support
  • Data Guard support/certification
  • Compiled PL/SQL code generation
Capabilities to support data warehouse ETL best practices;
  • Read and write Oracle Data Pump files with external tables
  • External table preprocessor
  • Partition specific DML
  • Bulk data movement code templates: Oracle, IBM DB2, Microsoft SQL Server to Oracle

Integration with Fusion Middleware capabilities;

  • Support OWB's Control Center Agent on WLS

Lots of interesting capabilities in and the availability of the 64-bit client I'm sure is welcome news for many!

Tuesday Oct 11, 2011

Generating XML with Experts

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;

<Department name=’ACCOUNTING’/>
<Department name=’RESEARCH’/>

rather than multiple documents like (where Department is the route node);

<Department name=’ACCOUNTING’/>
<Department name=’RESEARCH’/>

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.

Monday Jun 06, 2011

Book: Oracle Warehouse Builder 11g R2: Getting Started 2011

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:


Monday May 09, 2011

OWB 11gR2 - Model of Runtime Audit Data

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.


« August 2016