OWB 10g Release 2 Codename: Paris - PowerPoint PPT Presentation

About This Presentation
Title:

OWB 10g Release 2 Codename: Paris

Description:

Codename: Paris. Format/Objectives. Descriptive and Narrative (no demo) You should be able to ... Codename: Paris. OWB General What is OWB? ... – PowerPoint PPT presentation

Number of Views:84
Avg rating:3.0/5.0
Slides: 28
Provided by: nicholas84
Category:
Tags: 10g | owb | codename | paris | release

less

Transcript and Presenter's Notes

Title: 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-information)
  • 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
Write a Comment
User Comments (0)
About PowerShow.com