OWB 10g Release 2 Codename: Paris

1
Oracle Warehouse Builder 10g r2 (OWB)

• How you can leverage the new features of OWB
  Paris release

2
Presenter

• Nicholas A. Goodman
• Principal BI Consultant and Founder of bayon
  technologies, inc.
• Certified Business Intelligence Professional
• Oracle Partner
• Expert OWB consultant

3
Format/Objectives

• Descriptive and Narrative (no demo)
• You should be able to
• Describe what OWB is and understand its general
  applicability (General OWB)
• Understand the new features of OWB and how they
  can be used in real life situations (New OWB)
• Know where to go for more information

4
OWB General Why OWB?

• You already own it (probably)
• Provides considerable value
• Beats scripts hands down
• Embraces important orphan of ETL
• Cost Effective
• Easy to implement if youre already an Oracle
  shop

5
OWB General Why OWB?

• Increasing recognition for ability to execute and
  vision
• Leaders Quadrant
• Gartner 2004

6
OWB General What is OWB?

• Primarily a tool to build, deploy, and run ETL
  (Extract, Transform, Load)

7
OWB General - Applicability

• Small and Large installations
• DBAs are commonly charged with helping business
  understand their data
• Build a reporting area, with some report writing
  tools
• Custom SQL scripts, SQLLdr, replication and
  imp/exp
• Difficulties arise in enrichment, transformation
  (ie, turning DATA-gtinformation)
• IDEAL SOLUTION FOR THESE DBAs!

8
OWB General Concepts

• Design and Runtime

Graphicfrom rittman.net
9
OWB General - Installation
RED OWB
ORACLE MACHINE
OWB RT SYS
OWB REPOSITORYSCHEMA
OWBINSTALL
BLACK TARGETS
REPORTINGSCHEMA
STAGINGSCHEMA
10
New OWB - Overview

• Improved UI
• ETL/Pluggable Mappings
• Data Profiling
• Real Time BI (right time BI, and CDC)
• Experts
• Impact Analysis
• Misc

11
New OWB - Improved UI
12
New OWB - ETL
13
New OWB Pluggable Mappings
14
New OWB Data Profiling (1)
15
New OWB Data Profiling (2)
16
New OWB Data Profiling (3)
17
New OWB Data Correction
18
New OWB Right Time BI
19
New OWB CDC (1)
20
New OWB CDC (2)
21
New OWB CDC (3)
22
New OWB CDC (4)
23
New OWB Experts (1)
24
New OWB Experts (2)
25
New OWB Impact Analysis
26
New OWB Misc

• User Defined Objects
• Personalities
• Process Flow Improvements
• Scheduling
• Data Mining
• Security and Mgmt

• Control Center Runtime/Deploy
• Better Integration with Discoverer
• OLAP Enhancements

27
Where to go for more OWB

• http//www.bayontechnologies.com (Our Work)
• OTN OWB Page
• rittman.net (OWB Page)
• ngoodman_at_bayontechnologies.com
• Expected release this year