OWB 10g Release 2
Download
Report
Transcript OWB 10g Release 2
Oracle Warehouse
Builder (OWB)
10g R2
Realize the benefits of true
“End to End” Metadata
Management
OWB 10g Release 2
Codename: Paris
Presenter
Nicholas A. Goodman
Principal
BI Consultant and Founder of bayon
technologies, inc.
Certified Business Intelligence Professional
Oracle Certified Professional
Bayon Technologies, Inc.
Consulting,
Training, Tools
OWB 10g Release 2
Codename: Paris
Who are you?
DBA/DW Architect/Developer
Who uses OWB 10gR1?
Impact Analysis?
User
Defined Properties?
Who uses OWB 10gR2?
Plan
to?
Wait and see?
Who uses Informatica/DTS/etc?
OWB 10g Release 2
Codename: Paris
Overview
Context
OWB and Metadata
BI: Soup to Nuts
Pre-Paris vs Paris Metadata
User Defined Objects (Classes/Objects)
Next Steps…
OWB 10g Release 2
Codename: Paris
What is OWB?
Extract / Transform / Load (ETL)
OWB is a CODE GENERATOR
PL/SQL,
XPDL, CTL files
OWB 10g Release 2
Codename: Paris
What is OWB?
=
OWB 10g Release 2
Codename: Paris
OWB : Metadata
Metadata is central in OWB architecture
A working solution requires one to:
Build ETL “logically”
2. Build PL/SQL from “design model”
3. Execute actual ETL (runtime)
1.
“Orphan” of data warehousing
Operational and Contextual Benefits
OWB 10g Release 2
Codename: Paris
Operational : Logic AND Code
BUSINESS LOGIC CAPTURED
OWB 10g Release 2
Codename: Paris
Operational : Impact Analysis
What’s the possible impact of a change to
the CATEGORY DATAFILE in my SALES
application?
OWB 10g Release 2
Codename: Paris
Contextual : Company XYZ
You have a
Data Mart that
produces
“Sales”
reports
BUT WHAT
DOES IT
MEAN!?!?
OWB 10g Release 2
Codename: Paris
Contextual : Lineage
Does the SALES cube include data from
the OE Schema?
OWB 10g Release 2
Codename: Paris
BI : Soup to Nuts
Source (MVC) and DB / Extract Files
Data Warehouse (staging/DW)
Data Marts (star schema)
Reports (configuration, calculations)
Custom user and shared reports
BPM Alerts, Dashboards, Closed-Loop
OWB 10g Release 2
Codename: Paris
XYZ : Soup to Nuts
An “Order” travels through all these pieces
Created,
validated, transformed, calculated,
aggregated, summarized, etc.
Changing something on the JSP in the CSR
application could affect the Product Mgr Dashboard
OWB 10g Release 2
Codename: Paris
Metadata : Pre-Paris
Limited to objects that OWB “uses”
User Defined Properties (UDP) a start
Knows only about “middle section”
Tables,
Views, Sequences, Functions, etc
OWB 10g Release 2
Codename: Paris
Metadata : Pre-Paris
OWB 10g Release 2
Codename: Paris
Metadata : Paris
Can extend the OWB
Repository to include
your own Classes and
Objects
User Defined Objects:
Class
: SoftwareXReport
Objects :
WidgetXReport,
WidgetYReport
OWB 10g Release 2
Codename: Paris
Metadata : Paris
Note : Possible, not “out of the box”
OWB 10g Release 2
Codename: Paris
UDOs : Implementation
First : Classes
Create
Iconsets
Create Classes, Associations, Folders
Second : Objects
Programmatically
OWB
(OMBPlus/Java)
Client
OWB 10g Release 2
Codename: Paris
UDO Classes : Step 1
Create Iconset
OWB 10g Release 2
Codename: Paris
UDO Classes : Step 2
Create CLASS DEFINITION
Done in OMBPlus in Single User Mode
Requires Knowledge of
First,
Second, Third class objects in OWB
Repository
Folder Definitions
Association Definitions
“Non-trivial” to say the least
OWB 10g Release 2
Codename: Paris
UDO Classes : Step 2 (syntax)
NOT exact syntax
Oracle should provide “reference” TCL
Bayon will publish scripts/information
when Paris is released (maybe an Expert)
OMBDEFINE MODULE CLASS_DEFINITION ‘MY_MODULE’
OMBDEFINE FIRST_CLASS_OBJECT CLASS_DEFINITION ‘EXCEL’ ...
OMBREDEFINE CLASS_DEFINITION ‘MY_MODULE’ ADD CHILD_TYPE ‘EXCEL’
OMBDEFINE SECOND_CLASS_OBJECT CLASS_DEFINITION ‘WORKSHEET’
OMBREDEFINE CLASS_DEFINITION ‘EXCEL’ ADD CHILD_TYPE ‘WORKSHEET’
OMBDEFINE ASSOCIATION_DEFINITION ...
OWB 10g Release 2
Codename: Paris
UDO Objects : Programmatically
OWB 10g Release 2
Codename: Paris
UDO Objects : OMBPlus
Swiss Army Knife of OWB
TCL
scripting, easy access to OWB Rep
Simple pseudo code:
For
x in [ file with values ] {
create/update JSP objects (values)
}
Java for more “advanced” needs
OWB 10g Release 2
Codename: Paris
UDO Objects : Programmatically
BUSINESS OBJECTS
REPOSITORY
EXTRACT REPORT
DATA FROM BO REP
.TCL SCRIPTS
GENERATE TCL
FROM DATAFILES
REPORT
DEFINITIONS
OWB 10g Release 2
Codename: Paris
OWB
REPOSITORY
UDO Objects : Manually
OWB 10g Release 2
Codename: Paris
Other Noteworthy Items
Exp/Imp/Snapshots/etc work
Public Metadata Views
ALL_IV_GENERIC_ASSOCIATIONS
ALL_IV_GENERIC_FCOS
ALL_IV_GENERIC_FOLDERS
ALL_IV_GENERIC_MODULES
ALL_IV_GENERIC_SCOS
Use UD_ so OWB can identify USER
DEFINED Classes
OWB 10g Release 2
Codename: Paris
Where to go for more OWB
http://www.bayontechnologies.com
(Our Work)
EMAIL ME:
[email protected]
OTN OWB Page
http://rittman.net
Expected release CY 2006
OWB 10g Release 2
Codename: Paris
Open Discussion
Discoverer : Product to “keep the two in sync?”
Can we automate the “Lineage” graphs from
OWB to HTML help site for reporting app?
Can we help those “developers” keep their data
in order?
Provide
impact analysis as a service to other
departments?
Can experts be used to simplify UDO
maintenance?
OWB 10g Release 2
Codename: Paris