![Page 1: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/1.jpg)
April 21, 2023
OWB 10gR2: Late, but Packed with Features!
Nicholas GoodmanBayon Technologies, Inc.
Desktop Conference
Desktop Conference
20062006
You’re Virtu
ally There!
You’re Virtu
ally There!
Desktop Conference
Desktop Conference
20062006
You’re Virtu
ally There!
You’re Virtu
ally There!
![Page 2: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/2.jpg)
April 21, 2023 2
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
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)
![Page 3: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/3.jpg)
April 21, 2023 3
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
Format/Objectives
• Descriptive and Narrative (no demo)• You should be able to
– Describe what OWB is and understand it’s 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)
![Page 4: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/4.jpg)
April 21, 2023 4
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
OWB General – What is OWB?
• Primarily a tool to build, deploy, and run ETL (Extract, Transform, Load)
![Page 5: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/5.jpg)
April 21, 2023 5
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
OWB General – Why OWB?
• You already own it (probably)• Provides considerable value• Beats “scripts” hands down• Embraces important “orphan” of
ETL• Easy to implement @ “Oracle
shop”
![Page 6: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/6.jpg)
April 21, 2023 6
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
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, SQL*Ldr, replication and
imp/exp– Difficulties arise in enrichment,
transformation (ie, turning DATA->information)
• IDEAL SOLUTION FOR THESE DBAs!
![Page 7: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/7.jpg)
April 21, 2023 7
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB - Overview
• Unified Repository• Improved UI• ETL/Pluggable Mappings• Data Profiling• Experts• Impact Analysis• User Defined Objects• Discoverer Integration• Misc
![Page 8: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/8.jpg)
April 21, 2023 8
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
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
![Page 9: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/9.jpg)
April 21, 2023 9
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB - Improved UI
![Page 10: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/10.jpg)
April 21, 2023 10
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB - ETL
NOTE: Screenshots from BETA2 so some operators have been dropped
![Page 11: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/11.jpg)
April 21, 2023 11
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Pluggable Mappings
![Page 12: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/12.jpg)
April 21, 2023 12
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Data Profiling (1)
![Page 13: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/13.jpg)
April 21, 2023 13
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Data Profiling (2)
![Page 14: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/14.jpg)
April 21, 2023 14
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Data Profiling (3)
![Page 15: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/15.jpg)
April 21, 2023 15
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Data Correction
![Page 16: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/16.jpg)
April 21, 2023 16
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Experts (1)
![Page 17: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/17.jpg)
April 21, 2023 17
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Experts (2)
![Page 18: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/18.jpg)
April 21, 2023 18
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Impact Analysis
![Page 19: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/19.jpg)
April 21, 2023 19
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – User Defined Objects
![Page 20: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/20.jpg)
April 21, 2023 20
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Discoverer Integration
• Derive discoverer objects from Dimension, Cubes, and Tables.
• Deployed into an EUL from OWB
• LOV, Sorts, Reports
![Page 21: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/21.jpg)
April 21, 2023 21
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
New OWB – Misc
• User Defined Objects
• Process Flow Improvements
• Scheduling• Security and
Mgmt
• Control Center Runtime/Deploy
• OLAP Enhancements
![Page 22: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/22.jpg)
April 21, 2023 22
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
Where to go for more OWB
• http://www.bayontechnologies.com (Our Work)
• OTN OWB Page• rittman.net (OWB Page)• [email protected]
m• Expected release in the next few
months
![Page 23: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/23.jpg)
April 21, 2023
Thank you!
Nicholas GoodmanBayon Technologies, Inc.
[email protected]+(1) 877-710-3038
Desktop Conference
Desktop Conference
20052005
You’re Virtu
ally There!
You’re Virtu
ally There!
Desktop Conference
Desktop Conference
20052005
You’re Virtu
ally There!
You’re Virtu
ally There!
![Page 24: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/24.jpg)
April 21, 2023 24
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
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
![Page 25: 28 October 2015 OWB 10gR2: Late, but Packed with Features! Nicholas Goodman Bayon Technologies, Inc. Desktop Conference 2006 You’re Virtually There!](https://reader036.vdocuments.us/reader036/viewer/2022062322/56649f055503460f94c19c9d/html5/thumbnails/25.jpg)
April 21, 2023 25
DC2006DC2006You’reYou’re
VirtuallyVirtuallyThere!There!
OWB General – Why OWB?
• Increasing recognition for ability to execute and vision
• Leaders Quadrant• Gartner 2004