1 / 27

Oracle Warehouse Builder 10g r2 (OWB)

Oracle Warehouse Builder 10g r2 (OWB). How you can leverage the new features of OWB “Paris” release. Presenter. Nicholas A. Goodman Principal BI Consultant and Founder of bayon technologies, inc. Certified Business Intelligence Professional Oracle Partner “Expert” OWB consultant.

didina
Download Presentation

Oracle Warehouse Builder 10g r2 (OWB)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Warehouse Builder 10g r2 (OWB) How you can leverage the new features of OWB “Paris” release OWB 10g Release 2Codename: Paris

  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 it’s 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 you’re 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, SQL*Ldr, 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. User Defined Objects Personalities Process Flow Improvements Scheduling Data Mining Security and Mgmt Control Center Runtime/Deploy Better Integration with Discoverer OLAP Enhancements New OWB – Misc

  27. Where to go for more OWB • http://www.bayontechnologies.com(Our Work) • OTN OWB Page • rittman.net (OWB Page) • ngoodman@bayontechnologies.com • Expected release this year

More Related