Business Intelligence

A new whitepaper on code template/knowledge module support in Warehouse Builder has been published on OTN. For those who have followed this blog and other third party discussions of OWB 11gR2 closely, the technical information here may already be familiar, and you may have even dug deeper into the details than this paper can in the space available. But for those looking to get up to speed on what’s been happening with OWB 11gR2, its place in Oracle’s data integration product lineup, and how ODI knowledge module technology figures into OWB, you can download the PDF here.
More white papers on

…click on the title to read the full article…

With Tahoe release of OWB, search functionality is enhanced for a more efficient development process. This includes advanced find and search inside various components. Advanced find enables a user to quickly locate any item inside a graph editor, e.g., a mapping editor. Usually, mappings are used to perform an ETL task. A real world complex mapping can contain hundreds to thousands of objects, including operators, groups and columns. It would be a boring and tedious work for an ETL designer to locate a certain column in the mapping canvas manually. With Advanced Find, tasks like search for a column in

…click on the title to read the full article…

I’m taking some time off at the moment (back next week, no worries) but things still land in my inbox, and I can’t help but look at them and sometimes process them… So when a couple of classic OWB implementations showed up in press releases this week, I figured I had to share them with the blog readership.
Solid, successful implementations that tap into the strengths of Oracle databases and Warehouse Builder no doubt happen all the time, so in that sense it’s not news, but each was important enough to the parties involved for a press release, and we

…click on the title to read the full article…

Oracle University now offers an instructor-led course on OWB11.2 entitled Data Integration and ETL with Oracle Warehouse Builder.
The entire course is 5 days long and is divided into two parts:

Part I is 3 days and covers designing and debugging ETL mappings, performing data cleansing, integrating with OBIEE and other basic ETL functionality included in the Oracle Database license.

Part II is 2 days and covers metadata management, accessing non-Oracle sources (code templates), right-time data warehousing, and the other features in the Enterprise ETL/ ODI EE license.

For a listing of other training resources, including the free OBE’s, see the OWB Training

…click on the title to read the full article…

In OWB 11gR2 the location object has a number of advanced properties for supporting a wide variety of data systems. These properties allow users to specify a range of information from how systems are accessed to the naming convention for temporary objects on the system. We will introduce these properties below.
1.Details
In OWB Design Client, when you open the editor of a location, you will see several tabs such as Details, Advanced, Prefix, Mask and Connection Pool listed on the left panel. Click on the Details tab, the right panel displays the general credential information for a location. Let’s take an

…click on the title to read the full article…

Oracle Warehouse Builder (OWB) Public Views is a relational public interface to OWB repository. It helps users to have a direct access to OWB metadata by using SQL. The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. Compared to other OWB public access methods, such as Scripting Command and OWB Repository Browser, Public Views provides fast, lightweight, secure, multiple-user enabled and remote access to the OWB metadata.
OWB Browser is entirely relying on OWB Public Views to provide metadata support. Many OWB customers, such as data warehouse developers, consultants and administrators, are using OWB

…click on the title to read the full article…

The control center agent, as a runtime middle-tier, is integrated in OWB 11g Release 2 to support heterogeneous access. It is essential for users to get an insight into how to troubleshoot and diagnosis the control center agent. This article describes some common approaches to help users to diagnosis the control center agent.

The Oracle Diagnostic Logging (ODL)

After users deploy and execute a code template map in the design center, they may encounter deployment or execution error. We take a simple code template map as an example. The CT_MAP is a simple TABLE-to-TABLE map. After the CT_MAP is executed,

…click on the title to read the full article…

The OWB 11gR2 New Features eStudy is available! You can use the following URL to enroll in iLearning and play the eStudy:
http://ilearning.oracle.com/ilearn/en/learner/jsp/offering_details_find.jsp?classid=776869450
Thanks to the authors and contributors, hope you find it useful.

Next on the MySQL series, let’s look at bulk extract to file from MySQL. We’ll see how the OWB 11gR2 out of the box functionality can be enhanced to utilize some native MySQL capabilities and boost the performance! All with some baby steps into the code template world…
To make it a little more interesting we will create multiple files from a single map, one with the high bonuses and another with the low bonuses.

The mapping will have 2 execution units and we will utilize the SQL to File integration code template which is shipped with OWB 11gR2. Look at

…click on the title to read the full article…

This is an introduction to the error detection capabilities using the check/control pattern supported in the code template framework and carries on from the previous post on OWB 11gR2’s Open Connectivity using MySQL. The error detection scenario will leverage the mapping from the previous post. The check/control pattern is a generic framework for error handling that is supported out of the box with the supplied code templates, you will see how rules are logically declared and enabled within the mapping.
The framework is incorporated into integration code templates and can be initiated whilst the data is being integrated (flow in image

…click on the title to read the full article…