OWB 10gR2: Late, but Packed with Features

1
OWB 10gR2 Late, but Packed with Features!
Desktop Conference 2006Youre Virtually There!

• Nicholas Goodman
• Bayon Technologies, Inc.

2
Presenter

• Nicholas A. Goodman
• Principal BI Consultant and Founder of bayon
  technologies, inc.
• Certified Business Intelligence Professional
• Oracle ACE
• Bayon provides focused consulting
• OWB (Install, Migrations, Change Mgmt,
  Integration, Implementation)
• Open Source BI and DW (Pentaho, OLAP, ETL, DW
  Tuning for open source DBs)

3
Format/Objectives

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

4
OWB General What is OWB?

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

5
OWB General Why OWB?

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

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

7
New OWB - Overview

• Unified Repository
• Improved UI
• ETL/Pluggable Mappings
• Data Profiling
• Experts
• Impact Analysis
• User Defined Objects
• Discoverer Integration
• Misc

8
New OWB Unified Repository

• Design and Runtime are in the same repository by
  default now
• Sufficient for many locations
• Installs in less than 5 minutes
• Simple developer install with DB already
• Can be split

9
New OWB - Improved UI
10
New OWB - ETL
NOTE Screenshots from BETA2 so some operators
have been dropped
11
New OWB Pluggable Mappings
12
New OWB Data Profiling (1)
13
New OWB Data Profiling (2)
14
New OWB Data Profiling (3)
15
New OWB Data Correction
16
New OWB Experts (1)
17
New OWB Experts (2)
18
New OWB Impact Analysis
19
New OWB User Defined Objects
20
New OWB Discoverer Integration

• Derive discoverer objects from Dimension, Cubes,
  and Tables.
• Deployed into an EUL from OWB
• LOV, Sorts, Reports

21
New OWB Misc

• User Defined Objects
• Process Flow Improvements
• Scheduling
• Security and Mgmt

• Control Center Runtime/Deploy
• OLAP Enhancements

22
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 in the next few months

23
Thank you!
Desktop Conference 2005Youre Virtually There!

• Nicholas Goodman
• Bayon Technologies, Inc.
• ngoodman_at_bayontechnologies.com
• (1) 877-710-3038

24
Want to learn more about Oracle Collaboration
Suite?

• Visit us at http//www.oracle.com/collabsuite
• Sign up for a free trial of Oracle Web
  Conferencing
• Go to www.oracle.com/start
• Enter Keyword OWTrial
• Learn how to build collaboration-enabled
  applications! Visit us at the Oracle Technology
  Network http//otn.oracle.com

25
OWB General Why OWB?

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