1 / 17

Seven Styles of Data Integration

Seven Styles of Data Integration. Michael Corcoran Vice President & CMO October 13, 2014. Pervasive Business Intelligence Opportunity for Improvement. Most organizations access and analyze less than 20% of their data assets, minimizing the return on their overall IT investment.

early
Download Presentation

Seven Styles of Data 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. Seven Styles of Data Integration Michael Corcoran Vice President & CMO October 13, 2014

  2. Pervasive Business IntelligenceOpportunity for Improvement • Most organizations access and analyze less than 20% of their data assets, minimizing the return on their overall IT investment. Most organizations have deployed BI capabilities to fewer than 10% of their internal users. Documents Transactions Services Messages Databases Applications

  3. Enterprise Business IntelligenceThree Levels CEO/ PRESIDENT STRATEGIC HUMAN RESOURCES INFORMATION TECHNOLOGY FINANCE MARKETING SALES PRODUCTS TACTICAL Data Warehouse OPERATIONAL Operational Data Store Operational Data PARTNERS CUSTOMERS AGENTS SERVICE Process/ Transaction/ Web Service/ Documents RFID SUPPLIER DISTRIBUTOR

  4. Information BuildersOur Solutions Because Everyone Makes Decisions Because Everything Should Work Together

  5. The Cost of Delivering Information • Up to 80% of the cost of implementing business intelligence is attributed to data integration.

  6. Enterprise Business IntelligenceSeven Styles of Data Integration RealTime Point in Time Process/ Transaction/ Web Service/ Documents Data Marts Data Warehouse Operational Data Store (ODS) Operational Data • Data Warehouse • Operational Data Access • Real-time Data Warehouse • Enterprise Information Integration & Drill-Through • Web Services • Process-Driven BI (Alerts, BAM, and Embedded) • Enterprise Search

  7. Data Integration RequirementsTraditional Data Warehousing OPERATIONAL DATA Benefits • Data quality • Consolidated • Data consistency • No operational system impact Challenges • Data Latency • High cost • Implementation time and maintenance ETL DATA WAREHOUSE

  8. Data Integration RequirementsOperational Data Access OPERATIONAL DATA Benefits • Zero data latency • Lower cost • Detail data • Reduced implementation time Challenges • Data quality • Operational system impact • Data aggregation DATA WAREHOUSE

  9. Data Integration RequirementsReal-Time Data Warehouse OPERATIONAL DATA Benefits • Zero data latency • Consolidated data model • No operational system impact Challenges • Transaction volume How Do we Do It • Real-time Transformation • Packaged application interfaces • Works with all brokers, msg queues and TP monitors • Integrated with ETL - Common process flow - Embed ETL jobs in process flows Broker TP Monitor Real-Time Transformation DATA WAREHOUSE Process/ Transaction/ Web Service/ Documents

  10. Data Integration RequirementsEnterprise Information Integration OPERATIONAL DATA Benefits • Consolidated view • Cross-business functions • Executive portals • Reduced implementation time Challenges • Performance • Non-similar data keys DATA WAREHOUSE DATA WAREHOUSE

  11. Data Integration RequirementsEII Drill-Through Data Warehousing OPERATIONAL DATA Benefits • Detail analysis • Financial analysis • Data Warehouse validation Challenges • Data synchronization DATA WAREHOUSE

  12. Data Integration RequirementsWeb Services OPERATIONAL DATA F I R E W A L L Supplier 3 DB2 IMS JAVA Benefits • Standard interfaces • Simplifies B2B data access Challenges • Performance ? Supplier 2 .NET Oracle DATA WAREHOUSE Supplier 1 SQL Server VB

  13. Process-Driven Business IntelligenceAlerts OPERATIONAL DATA ESB Broker TP Monitor Applcation Benefits • True Real-Time • Alerts • Business Activity Monitoring • Embedded BI into any operational business process or workflow. Challenges • ? DATA WAREHOUSE Process/ Transaction/ Web Service/ Documents

  14. Process-Driven Business IntelligenceBusiness Activity Monitoring OPERATIONAL DATA ESB Broker TP Monitor Applcation Benefits • True Real-Time • Alerts • Business Activity Monitoring • Embedded BI into any operational business process or workflow. Challenges • ? DATA WAREHOUSE Process/ Transaction/ Web Service/ Documents

  15. Process-Driven Business IntelligenceEmbedded BI ESB Broker TP Mnitor Applcation

  16. Data Integration RequirementsEnterprise Search

  17. Seven Styles Of Data IntegrationSummary • Today’s business requires new types of data. • Information demand is driving lower latency of data. • Enterprise Business Intelligence requires most, if not all, styles of data integration.

More Related