OWB at ODTUG Conference in the big easy...


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!!!


Post a Comment:
  • HTML Syntax: NOT allowed

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


« July 2016