Welcome to All Things Warehouse Builder

OWB at ODTUG Conference in the big easy...

Jean-Pierre Dijcks
Master Product Manager


It is ODTUG time again. No beach this time, but hey it will be a crawl

away from the Frensh Quarter, so get ready to have some fun. Of course

we have serious stuff going on as well...

I'm of course quite interested in OWB sessions or in topics that touch on it as like data warehousing, ETL and data quality. So here are some sessions that might be interesting:

A BI and Advanced Analytics Case Study (by Shyan Vran Nath, Citco Technology Management)

This presentation will look at the framework for developing a

data-driven planning application using business intelligence and

advanced analytics. Often the planning, budgeting, and forecasting

involves quantitative details that make the job of the approving

authorities harder. Here we take the domain of K-12 education and look

at how advanced analytics can be used to predict the students who are

"at-risk" of graduation versus those who are likely to succeed. This is

a major U.S. national challenge and the government's "No-Child Left

Behind" initiative addresses that. We look at how K-12 cross-subject

education related data such as attendance, enrollment, achievement,

discipline, etc. can be used to create an education datawarehouse and

can be used for data mining. We will look at the use of Oracle

Warehouse Builder, Oracle Data Mining, OBIEE, other BI tools, and the

development environment in the process. The outcome of the data mining

provides the "actionable" data to the education administrators and

decision-makers via the education dashboards. These in turn help to

initiate data-driven planning that can use the results of predictive

analytics to plan for current and future school years. This

presentation was developed using a real Department of Education BI

project from 2007.

A Next-Generation Oracle BI Architecture (by Mark Rittman, Rittman Mead Consulting)

With the recent acquisitions of Hyperion and Siebel, Oracle now has a

world-class set of BI tools to add to their own Oracle Database, Oracle

Discoverer and Oracle Warehouse Builder. For customers though, the

question now is how to build an effective BI architecture out of these

tools, built around the core of an Oracle database and using the

features of Oracle OLAP, Oracle BI Server, OWB and ODI, Oracle

Dashboards, Oracle Answers, and the performance management tools

provided by Hyperion. This presentation answers the questions around

Oracle's BI strategy, provides a BI development roadmap and sets out an

architecture that leverages the best elements of these tools,

explaining how best to use Oracle's BI and data warehousing for a

variety of customer scenarios.

Oracle BI, Oracle OLAP, Essbase: The Benefits and Cost of Openness (by Dan Vlamis Vlamis Software Solutions)

Companies with heterogeneous environments need to analyze data from

multiple sources, through multiple application servers, in multiple

presentation environments. The "hot pluggable" products work well for

this need: Oracle Data Integrator, Essbase, Real-time Decisions, Oracle

Business Intelligence Enterprise Edition, and BI Applications. But what

if these needs are not paramount in your organization? You can use

Oracle's traditional products: Oracle Warehouse Builder, the OLAP, Data

Mining options to the Oracle Database, Oracle Business Intelligence

Standard Edition, and Daily Business Intelligence. Come and learn which

products are appropriate for your situation, how Oracle's acquisition

strategy led to this situation, and how Oracle's product management

structure propagates this situation. The session will especially focus

on the differences between Essbase and the Oracle OLAP option�both very

capable multi-dimensional databases, but with different goals.

For OWB we will be doing 4 development sessions on the following topics:

Development's Bag of Tricks for Oracle Warehouse Builder

You are using Oracle Warehouse Builder and you see many things you

could do or could do better. See how you can solve some common problems

by using the functionality that OWB provides in 11g.

We will be discussing a set of topics with hands-on examples which will

include, for example, using analytical SQL in OWB (hierarchical

queries, advanced aggregations), dealing with XML data sources and

targets, matching and merging information from different systems, and

extending the product using Experts. This session is intended to deepen

your knowledge about Warehouse Builder and make you, as a developer,

more productive.

Best Practices in Implementing Data Quality Process with Warehouse Builder

We all know it is there, we all know we need to do it, but how do we

apply this data quality stuff in real projects? In this session we go

through a set of examples showing how to implement data quality

policies in an organization using OWB. Topics to expect include

determining survivorship of your master records, householding, and

linking of records. In addition, we will discuss and show how to create

smart auditing and testing of data in a so-called data quality

firewall. This firewall prevents bad data from even entering the

systems being targeted. Last but not least, we will discuss how to

implement a quality assessment and reporting structure on your existing


Warehouse Builder Goes Heterogeneous: What That Means for You

With Warehouse Builder 11g

Release 2 you will get the best of both the OWB and the ODI world in

one tool. Yes, OWB is integrating the ODI heterogeneous concepts and

templates within the familiar OWB functionality. So you now have full

heterogeneous support for both sources and targets included with the

data profiling, data quality, and regular Oracle PL/SQL mappings. On

top of that you will see a unification of the metadata layer in the

database and a unification of the client tool user interfaces (OWB goes

JDev IDE!). In short, if you are interested in ETL and OWB, this

session shows the newest of the newest in OWB land, straight out of

development. See it all in action and ask questions about our direction

in ETL land.

Oracle Warehouse Builder: Web Services and SOA Ready

Web services and SOA are the big buzzwords in today�s world of

loosely-coupled applications. Oracle Warehouse Builder 10gR2 and 11gR1

are ready for today's application architectures. This presentation will

focus on how to handle an XML document as a source or target (using

experts) and how to expose an OWB mapping as a Web service, and call it

from BPEL. Concrete examples will show you how incorporating OWB

functionality in these cases improves developer productivity.

Find all abstracts here (http://www.odtugkaleidoscope.com/abstracts3.html).

As a veteran at the conference (I think this is #6 for me), I would highly recommend it! You will meet experts on Oracle tooling, you will end up knowing some of the experts from the show and bring their network into your network. So see you all at ODTUG!!!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.