Agenda

2. Oracle Warehouse BuilderProduct UpdateMichelle BirdSenior Product Manager, Oracle Warehouse BuilderMay 20, 2009

3. Agenda • An abbreviated history • OWB 11.2 beta overview • Oracle’s 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 Oracle’s products remains at the sole discretion of Oracle.

5. Agenda An abbreviated history  OWB 11.2 beta overview Oracle’s 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/products/warehouse/index.html

8. Product HighlightsAn abbreviated history of OWB 2004 2006 2003 2007 Release 10.1 Release 10.2 Release 9.2 Release 11.1 Oracle 10g certified Data profiling & auditing Oracle RAC certified Server components installed w/ Oracle DB Mapping Debugger Interactive LIA Name & Address Connector to Oracle MDM Scheduling Match/Merge Improved connector for SAP R/3 Release 9.0.4 EBS and PeopleSoft connectors Metadata Security Process Flow Editor OLAP and relational modeling Scripting Language Pluggable mappings Multi-table insert Non-Oracle targets Pivot and Unpivot 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 releaseOWB 11.2 Most new features = priced option(s) Features licensed with Oracle Database 2000 2003 2004 2006 2007 Release 2.0.4 Release 10.1 Release 10.2 Release 9.2 Release 11.1 Basic ETL functionality Oracle 10g certified Data profiling & auditing Oracle RAC certified Server components installed w/ Oracle DB Mapping Debugger Mapping Editor Interactive LIA Name & Address 3,000+ companies Compete against Informatica and Ascential Connector to Oracle MDM Set and row based code generation Scheduling Match/Merge Improved connector for SAP R/3 10,000+ companies Release 9.0.4 EBS and PeopleSoft connectors Metadata Security Process Flow Editor OLAP and relational modeling Scripting Language Pluggable mappings Multi-table insert Non-Oracle targets Pivot and Unpivot 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. BI Tool Integration OBI EE (Enterprise Edition) : design & leverage Oracle objects Discoverer (Standard Edition): design & deploy EUL Databases Databases Non-Oracle BI : design & leverage Oracle objects Applications Applications Connectivity Connectivity Files Files Odbc / Gateways Odbc / Gateways Connectors Connectors CDC: Queues / Streams/ Third Party CDC: Queues / Streams/ Third Party Messages Messages SQL*Loader/ Ex Table Analytics Analytics Semi-Structured Semi-Structured Web Services Web Services 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  Oracle’s roadmap for ETL Pricing and Packaging How to join the beta program

12. JDBC JDBC Native Loaders Native Loaders Native Un-Loaders Native Un-Loaders Service Oriented Architectures Web Services for data integration and data quality 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 Connectivity Oracle Warehouse Builder 11.2 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 SQL*Loader/ Ex Table Knowledge Module Framework Analytics Analytics Unified Metadata Unified Metadata Semi-Structured Semi-Structured Web Services Web Services

13. Leveraging the Oracle DatabaseNew 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 EEHow it’s done in OWB 11.2 • In OWB, derive the model from the dimensional model • In OWB, generate the metadata for all 3 layers of OBI EE • 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 codeIncreased Flexibility • Modify template • Regenerate the code • 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 • Define “execution units” for each type of source ( 3 shown here) • 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 Oracle’s 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 Term:Deliver 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/warehouse/pdf/owb_roadmap.pdf

22. High-Level Roadmap (part 1)Unified platform that is a superset of OWB and ODI Unified dev team “ CY 2012” Common pricing • 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 Oracle’s 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 WAREHOUSE BUILDER ENTERPRISE ETL DATA INTEGRATOR APPLICATION ADAPTERS ORACLE DATABASE DATA PROFILING & QUALITY ENTERPRISE EDITION FOR WAREHOUSE BUILDER $2,300/cpu DBEE+$17.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 Name&Address cleansing DATA WATCH & REPAIR ODPQ+$23k 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 Dev>QA>PROD 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 Dev>QA>PROD 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 Dev>QA>PROD 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 Dev>QA>PROD 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 Dev>QA>PROD 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 Oracle Database 12g 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 Oracle’s 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/index.htm • For assistance in forming a test plan, contact Michelle.Bird@oracle.com