ODI ST Partnership

1
(No Transcript)
2
Oracle Warehouse BuilderProduct
UpdateMichelle BirdSenior Product Manager,
Oracle Warehouse BuilderMay 20, 2009
3
Agenda

• An abbreviated history
• OWB 11.2 beta overview
• Oracles roadmap for ETL
• Unifying the ODI and OWB products
• New OWB pricing
• How to join the beta program

4
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into
any contract. It is not a commitment to deliver
any material, code, or functionality, and should
not be relied upon in making purchasing
decisions.The development, release, and timing
of any features or functionality described for
Oracles products remains at the sole discretion
of Oracle.
5
Agenda

• An abbreviated history ?
• OWB 11.2 beta overview
• Oracles roadmap for ETL
• Pricing and Packaging
• How to join the beta program

6
Oracle Warehouse BuilderThe ETL and DQ tool
shipped with Oracle Database

• Oracle Database as transformation engine
• Oracle Database as metadata repository

Oracle Database 11g
Oracle Warehouse Builder 11.1
HeterogeneousData Integration
In-lineData Quality
SmartData Modeling for Oracle
Unified Metadata
Unified Metadata
7
What can OWB do for you? Leverage Oracle like no
one else

• Improved productivity over hand coding
• easy to change your environment
• use the latest features without rewriting your
  code
• Leverage your Oracle investments like no one else
• skills, people and technology
• better performance than anyone else
• Shorten your project times while improving data
  quality
• discover problems up-front with data profiling
• improve data quality in a declarative way

OWB HOME PAGE http//www.oracle.com/technology/pro
ducts/warehouse/index.html
8
Product Highlights An abbreviated history of OWB
Most new features priced option(s)
Features licensed with Oracle Database
2000
Release 2.0.4
Basic ETL functionality
Mapping Editor
3,000 companies Compete against Informatica
and Ascential
Set and row based code generation
10,000 companies
Recognized as a leader in Gartner Magic Quadrant
Recognized as a leader in Forrester Enterprise
ETLWave
9
The upcoming release OWB 11.2
2009
Release 11.2
Flexible access to non-Oracle sources
Integration with Oracle BI EE
Enhanced web services/SOA support
Orphan management
Recognized as a leader in Gartner Magic Quadrant
New UI Usability enhancements
DB ETL features
Productivity enhancements
Recognized as a leader in Forrester Enterprise
ETLWave
10
OWB 11gR1Oracle-centric data integration platform

Oracle Database 11g
Oracle Warehouse Builder 11.1
HeterogeneousData Integration
In-lineData Quality
SmartData Modeling for Oracle
Unified Metadata
Unified Metadata
11
Agenda

• An abbreviated history
• OWB 11.2 beta overview ?
• Oracles roadmap for ETL
• Pricing and Packaging
• How to join the beta program

12
OWB 11gR2 (BETA)Plays well with others
BI Tool Integration
OBI EE (Enterprise Edition) design deploy
UDML
Discoverer (Standard Edition) design deploy
EUL
Databases
Databases
Non-Oracle BI design leverage Oracle objects

Oracle Database 11g
Applications
Applications
Connectivity
Oracle Warehouse Builder 11.2
Connectivity
Odbc / Gateways
Odbc / Gateways
HeterogeneousData Integration
In-lineData Quality
SmartData Modeling for Oracle
Files
Files
Connectors
Connectors
CDC Queues / Streams/ Third Party
CDC Queues / Streams/ Third Party
Messages
Messages
SQLLoader/ Ex Table
Knowledge Module Framework
Analytics
Analytics
Unified Metadata
Unified Metadata
Semi-Structured
Semi-Structured
Web Services
Web Services
13
Leveraging the Oracle Database New Database
features exposed in OWB 11.2

• Advanced Compression
• Virtual columns
• New partitioning methods
• Data Pump
• Cube MVs for summaries
• And more

Easy upgrade to OWB 11.2

• Import existing OWB design to OWB 11.2
• Select new feature e.g., Cube MVs
• Regenerate code

14
Integrating with OBI EE How its done in OWB 11.2

1. In OWB, derive the model from the dimensional
   model

1. In OWB, generate the metadata for all 3 layers of
   OBI EE

1. In Oracle Answers, browse the data

15
Flexible access to non-Oracle sources Enabled by
knowledge module framework

• Knowledge modules are snippets of code you can
  run, compile code in non-Oracle environments
• Choose from a library of existing knowledge
  modules (KMs)
• Write your own or edit existing KMs
• Originally developed by Sunopsis, now Oracle Data
  Integrator (ODI)

OWB knowledge modules 1st big step in
integrating OWB and ODI
16
Knowledge Modules for flexible access Limited
only by the code you write or find in the library

• Access any new source type relational,
  non-relational, message based and content sources
• Rich support of ERP, CRM and MDM on any database
  platform
• Rich library of Knowledge Modules

17
Viewing and Editing the KM code Increased
Flexibility

1. Modify template
2. Regenerate the code
3. Reuse the template

18
Using KMs in mappingsEasily change the
connectivity methods for a single logical design

• Complete the logical design (or import an
  existing mapping)

Logical view
Execution view

1. Define execution units for each type of source
   ( 3 shown here)

1. Select the best connectivity method for each
   execution unit (connectivity can be through ODBC,
   Gateways, Knowledge Modules, etc.)

19
OWB 11g R2Benefits for OWB customers

• More flexible data access to a larger set of
  sources  
• Increased developer productivity
• enhanced declarative design
• advanced in-line data quality features
• Increased flexibility in deployments
• alternative connectivity methods for a single
  logical design
• flexible use of different knowledge modules
• tighter control over implemented code
• Extended SOA support for data integration
  processes
• Unparalleled support for Oracle
• seamless upgrade to the newest DB features
• support for Oracle BI Enterprise Edition
• support for Oracle Hyperion Essbase

20
Agenda

• An abbreviated history
• OWB 11.2 beta overview
• Oracles roadmap for ETL ?
• Pricing and Packaging
• How to join the beta program

21
Oracle Roadmap for its ETL tools

• Long Term Direction Deliver an integrated data
  integration product
• Short TermDeliver stand-alone releases with
  first integration steps
• Shared knowledge module framework (OWB 11.2)
• Runtime interoperability (future releases)
• Same user interface framework (future releases)
• Protect investments for the entire customer base

http//www.oracle.com/technology/products/warehous
e/pdf/owb_roadmap.pdf
22
High-Level Roadmap (part 1)Unified platform that
is a superset of OWB and ODI

• OWB/ODI investments are fully protected
• No forced migrations
• Natural upgrade path
• No regressions in functionality
• Training and support to continue for both
  product releases

10gR2
11gR1
10gR1
11gR2
OWB
Oracle Data Integration 12g
ODI
11gR2
11gR1
10gR3
23
Agenda

• An abbreviated history
• OWB 11.2 beta overview
• Oracles roadmap for ETL
• Pricing and Packaging ?
• How to join the beta program

24
Common PricingODI EE pricing bundle ODI
product and OWB Enterprise ETL option
DATA INTEGRATOR
ENTERPRISE EDITION

• One license at 23k/cpu
• ODI and OWB EETL option are removed from
  pricelist
• Both are only available in ODI EE
• Two separate installations
• Implement one or both

WAREHOUSE BUILDER
DATA INTEGRATOR
ENTERPRISE ETL
OWB EETL
ODI
Flagship Data
Flagship
Integration Product
ETL Product
Heterogeneous, High-Performance Data Integration
Extensible Metadata Management
Wizards for Slowly Changing Dimensions
Modern Java/SOA Architecture
Interactive Lineage and Impact Analysis
Flexible Knowledge Module framework
25
OWB Product OfferingsThis pricing applies to OWB
10.2 and 11.1 releases
APPLICATION ADAPTERS
DATA INTEGRATOR
ORACLE DATABASE
DATA PROFILING QUALITY
ENTERPRISE EDITION
FOR WAREHOUSE BUILDER
2,300/cpu
DBEE17.5k/cpu
23k/cpu
OWB EETL in
OWB EETL
ODPQ
DB
ADAPT
ODI EE
Data quality
Extensible
Reveals
Extensible
Mapping Editor Debugger
algorithms run in Oracle Database
Metadata Framework
business views of application data
Metadata Framework
Profile file, table, application data in place or
stage the data.
Out of the box support for Slowly Changing
Dimensions
Basic dependency management with Process Flows
Natively access SAP R/3 hosted on any database
OWB in
Read from and write to eBusiness Suite,
PeopleSoft, or Siebel
Auto- detect data rules. Audit, auto-correct
incoming data.
Interactive Lineage and Impact Analysis
Robust scripting language APIs

Fuzzy match/ merge and NameAddress cleansing
DATA WATCH REPAIR
ODPQ23k
DWR
Data quality
for Oracle MDM Siebel UCM, PIM, CDH
26
Warehouse Builder PackagingEffective 30- Jan 2009
Enterprise ETL Part of Data Integration
Enterprise Edition, FMW price list
Promote from DevgtQAgtPROD Extensible metadata
model Interactive lineage impact analysis,
change propagation Scheduling and advanced
process flow logic Advanced mapping logic
-pluggable maps, target load order RAC
support Slowly changing dimensions XML file
targets Transportable modules
In-Database ETL Free with Database SE, EE, and
Database Machine

• Mapping Editor Debugger
• Basic Process Flows
• HTML Metadata Reports
• OMB Scripting
• Name Address Cleansing
• Match Merge

Data Profiling Quality Requires Database EE
license. Is a Database Option.

• Data Profiling
• Data Rules
• Data Correction
• Data Auditing

• Enable access to data and metadata in
• SAP R/3
• eBusiness Suite
• Peoplesoft
• Siebel

• Integrate with Oracle MDM
• Siebel UCM
• PIM
• Customer Data Hub

Adapters FMW price list
Data Watch Repair Connector Requires Database
EE license. Is a Database Option.
27
Warehouse Builder Pricing (part 1)DB ETL is
included with Database SE, SE1, EE, and Database
Machine
Enterprise ETL Part of Data Integration
Enterprise Edition, FMW price list
Promote from DevgtQAgtPROD Extensible metadata
model Interactive lineage impact analysis,
change propagation Scheduling and advanced
process flow logic Advanced mapping logic
-pluggable maps, target load order RAC
support Slowly changing dimensions XML file
targets Transportable modules
In-Database ETL Free with Database SE, EE, and
Database Machine

• Mapping Editor Debugger
• Basic Process Flows
• HTML Metadata Reports
• OMB Scripting
• Name Address Cleansing
• Match Merge

Data Profiling Quality Requires Database EE
license. Is a Database Option.

• Data Profiling
• Data Rules
• Data Correction
• Data Auditing

• Enable access to data and metadata in
• SAP R/3
• eBusiness Suite
• Peoplesoft
• Siebel

• Integrate with Oracle MDM
• Siebel UCM
• PIM
• Customer Data Hub

Adapters FMW price list
Data Watch Repair Connector Requires Database
EE license. Is a Database Option.
28
Warehouse Builder Pricing (part 2)One license
for access to OWB EETL ODI functionality 23 K
/target cpu
Enterprise ETL ODI ODI EE Part of Data
Integration Enterprise Edition, FMW price list
23 K / target CPU
OWB
Promote from DevgtQAgtPROD Extensible metadata
model Interactive lineage impact analysis,
change propagation Scheduling and advanced
process flow logic Advanced mapping logic
-pluggable maps, target load order RAC
support Slowly changing dimensions XML file
targets Transportable modules
ODI
Knowledge Modules Non-Oracle DWH Native
access more
In-Database ETL Free with Database SE, EE, and
Database Machine

• Mapping Editor Debugger
• Basic Process Flows
• HTML Metadata Reports
• OMB Scripting
• Name Address Cleansing
• Match Merge

Data Profiling Quality Requires Database EE
license. Is a Database Option.

• Data Profiling
• Data Rules
• Data Correction
• Data Auditing

• Enable access to data and metadata in
• SAP R/3
• eBusiness Suite
• Peoplesoft
• Siebel

• Integrate with Oracle MDM
• Siebel UCM
• PIM
• Customer Data Hub

Adapters FMW price list
Data Watch Repair Connector Requires Database
EE license. Is a Database Option.
29
Warehouse Builder Pricing (part 3)Data Quality
pricing unchanged
Enterprise ETL Part of Data Integration
Enterprise Edition, FMW price list
Promote from DevgtQAgtPROD Extensible metadata
model Interactive lineage impact analysis,
change propagation Scheduling and advanced
process flow logic Advanced mapping logic
-pluggable maps, target load order RAC
support Slowly changing dimensions XML file
targets Transportable modules
In-Database ETL Free with Database SE, EE, and
Database Machine

• Mapping Editor Debugger
• Basic Process Flows
• HTML Metadata Reports
• OMB Scripting
• Name Address Cleansing
• Match Merge

Data Profiling Quality Requires Database EE
license. Is a Database Option. 17.5K / target
CPU

• Data Profiling
• Data Rules
• Data Correction
• Data Auditing

• Enable access to data and metadata in
• SAP R/3
• eBusiness Suite
• Peoplesoft
• Siebel

• Integrate with Oracle MDM
• Siebel UCM
• PIM
• Customer Data Hub

Adapters FMW price list
Data Watch Repair Connector Requires DB EE
Data Profiling Quality options Is a Database
Option . 23K
30
Warehouse Builder Pricing (part 4)ERP adapters
are now priced per target CPU (instead of per
target)
Enterprise ETL Part of Data Integration
Enterprise Edition, FMW price list
Promote from DevgtQAgtPROD Extensible metadata
model Interactive lineage impact analysis,
change propagation Scheduling and advanced
process flow logic Advanced mapping logic
-pluggable maps, target load order RAC
support Slowly changing dimensions XML file
targets Transportable modules
In-Database ETL Free with Database SE, EE, and
Database Machine

• Mapping Editor Debugger
• Basic Process Flows
• HTML Metadata Reports
• OMB Scripting
• Name Address Cleansing
• Match Merge

Data Profiling Quality Requires Database EE
license. Is a Database Option.

• Data Profiling
• Data Rules
• Data Correction
• Data Auditing

• Enable access to data and metadata in
• SAP R/3
• eBusiness Suite
• Peoplesoft
• Siebel

• Integrate with Oracle MDM
• Siebel UCM
• PIM
• Customer Data Hub

Adapters FMW price list 2,300 K/ target CPU
Data Watch Repair Connector Requires Database
EE license. Is a Database Option.
31
High-Level Roadmap (part 2)Oracle-centric ETL
DQ functionality continue in the Oracle Database
10gR2
11gR1
10gR1
11gR2
ETL DQ
OWB EETL
Oracle Data Integration 12g

• Core ETL and DQ functionality in the Oracle
  Database
• Enterprise ETL for Oracle and non-Oracle in
  ODI-EE

ODI
11gR2
11gR1
10gR3
32
Agenda

• An abbreviated history
• OWB 11.2 beta overview
• Oracles roadmap for ETL
• Pricing and Packaging
• How to join the beta program ?

33
Oracle Beta ProgramOWB 11.2 in the Oracle
Database 11.2 Beta

• How to qualify?
• Oracle employees, go to owb.us.oracle.com/internal
  /owb112/
• Customer with production licenses in place for
  Oracle SE, EE, or Database Machine
• or
• Current OPN members
• Participate?
• Apply at http//otnbeta.oracle.com/bpo/prospects/i
  ndex.htm
• For assistance in forming a test plan, contact
  Michelle.Bird_at_oracle.com

34
(No Transcript)