1 / 34

Complete Information Integration

Complete Information Integration. A Shared Architecture for Operational and Analytic Integration. Andy Flower Vice President Session # 101. Speaker Qualifications. Andrew Flower, Founder and Lead Consultant 14 years in Data Integration and Data Architecture

druce
Download Presentation

Complete Information Integration

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. Complete Information Integration A Shared Architecture for Operational and Analytic Integration Andy Flower Vice President Session # 101

  2. Speaker Qualifications • Andrew Flower, Founder and Lead Consultant • 14 years in Data Integration and Data Architecture • Contributing Author to Oracle 8i Data Warehousing • Instructor on Data Integration for TDWI • Member of the IOUG Board of Directors

  3. Agenda • Enterprise Information Integration • Is this a solution looking for a problem? • It is time to move to the middle • Hey! I can do this with Oracle Database and Fusion Middleware • Review of Enterprise Information Integration

  4. Enterprise Information Integration • What is it? • Thank you John Zachman • How does this fit into an Enterprise Architecture • It is all about managing the Nouns and Verbs of your organization

  5. Zachman Framework

  6. Enterprise Information Integration • Provides an on demand integration layer supporting Operations and Business Intelligence • Dependent on effective organizational management • Master Data Management • Data Governance • Standardized processes for cleansing data • Service Oriented Architecture inclusive of Business Process, Service, and Technical Integration

  7. Enterprise Information Integration • Strengths • Provides one place for an enterprise to access master data • Supports changes to processes • Improves overall data quality through consistent reuse of rules • Source for conformed dimensions • Supports batch and low latency reads and writes • Weaknesses • New concept, infrastructure project hard for business to buy in • Confusion on what tool sets to use to support such an architecture • Heavy use of on-demand reads/writes could create bottleneck to operational applications

  8. Service Integration Architecture Information Integration Architecture Business Process Integration Architecture Technical Integration Architecture Enterprise Integration Architecture From Enterprise Integration by Beth Gold-Bernstein

  9. Questions?

  10. Is this a solution looking for a problem? • Strengths • Provides one place for an enterprise to access master data • Supports changes to processes • Improves overall data quality through consistent reuse of rules • Source for conformed dimensions • Supports batch and low latency reads and writes • Weaknesses • New concept, infrastructure project hard for business to buy in • Confusion on what tool sets to use to support such an architecture • Heavy use of on-demand reads/writes could create bottleneck to operational applications

  11. What is driving this? • A data warehouse is inherently a bad idea. • A proxy for ill fitting application data representing the true enterprise data model • In the big picture it actually introduces another heterogeneous application • Satisfies same need by providing core data with rules in services on demand • Operational data integration • On demand analytics • BAM and BPM • Need to integrate structured, semi and un-structured data • Need to be more nimble and flexible.

  12. It is time to move to the middle • Focus on the Nouns and the Verbs • Master Data Management for operational and analytic applications • Standardized Data Quality Services • Data Services that can be Orchestrated and delivered with Functional Services • Data Governance • Function Governance

  13. Information Integration Architecture

  14. In other words, SODW • Service Oriented Data Warehousing (SODW) is comprised of: • Variable Entity Latency • MDM to support both Operational and Analytic integration • Data Standardization and Quality Services are key • Data Integration Services • Traditional ETL

  15. Entity Driven Latency • Low latency (Real Time) • Batch • Not an all or nothing approach • For each entity discover availability of source data • For each entity determine the consumer requirement for availability

  16. Master Data Management + • One set of master reference data supporting operational integration and BI • Plus -> all data that is shared (including transactions) Create once share everywhere • Wrapped with services to integrate and access

  17. Data Integration Services • ETL • ELT • Data standardization • Access

  18. Portal Legacy Database Legacy Application Operations Application Operations Application Operations Application Operations Application Business Intelligence Application Business Intelligence Application Application Database Application Database Application Database Application Database Application Database Application Database Data Integration Data Integration Data Integration Master Data Management+ Enabling SODW

  19. Functional Application Servers App Data Server MDM Data Server Meta Data Server BI Application Server BI Data Server Data Integration Server Legacy Mainframe Enabling SODW

  20. Questions?

  21. Hey! I can do this with Oracle Database and Fusion Middleware! • Data Hubs (Customer, Product, Financial) or build my own MDM+ repository • OWB Services exposed in the database for ETL and Data Quality processing • Oracle Data Integrator • SOA Suite, BPEL, Oracle Business Intelligence

  22. The SODW Market • Both IBM and Oracle are pushing data integration and data hubs to the middleware stack • Informatica is pushing hard into the SODI space • Business Intelligence tools are moving to SOA based platforms too (How will SAP integrate Business Objects?)

  23. Questions?

  24. Examples from a Life Insurance Customer • New Policy Application • Total Premiums by Product, Agent, Period • Alerts for New Policies by Agent vs. Historical trend for Cancellations/Non-Payment

  25. New Policy Application

  26. New Policy Application XML Policy XML Policy Standardize Validate Party Retrieve Coverage Retrieve Medical Master Data Management+ XML Insured Medical Information Underwriting Engine Party Policy HTTP MIB Service Bureau

  27. Total Premiums by Product Portal Policy Admin Application Profitability Analysis Application Database Application Data Mart Data Integration Master Data Management+

  28. Operational Analytics Portal Surrender Service Policy Admin Database Application Data Mart Data Integration Master Data Management+

  29. Questions?

  30. Your Take Aways • Enterprise Information Integration • What is it • What problems it solves • The keys to the strategy • How Fusion Middleware fits in

  31. Sessions to Check Out

  32. Become a Complete Oracle Technology and Database Professional • Join the IOUG online at www.ioug.org and get immediate access to: • Member Discounts and Special Offers • SELECT Journal • Library of Oracle Knowledge (LoOK) • Member Directory • Special Interest Groups • Discussion Forums: • Access to Local and Regional Users Groups: • 5 Minute Briefing: Oracle • Volunteer Opportunities

  33. Join the BIWA SIG Today! • Please visit www.ioug.org to learn more about joining the IOUG BIWA SIG.

  34. Thank You! • Please fill out your evaluation forms • Andy Flower • Complete Information Integration, Session # 101 • For further information you can contact me at • aflower@loganbritton.com • For more information about LoganBritton, visit LoganBritton.com

More Related