InfoSphere Integration and Product Roadmap

1. InfoSphere Integration and Product Roadmap Keith Kohl Program Director, Product Management

2. An Industry Unique Information Platform Simplify the delivery of Trusted Information Accelerate client value Promote collaboration Mitigate risk Modular but Integrated Scalable – Project to Enterprise The IBM InfoSphere Vision

3. Evolution of Information Projects Analysts Spot Trends Recommend Executives Performance Mgmt Understand, Decide Applications Real time Situational Decisions Analytic Applications KPIs… Call Center Marts Marts Master Schemas Scorecards Claims Dashboards ERP Warehouses Reports Supply Chain… Weak Information Architecture Heterogeneous Systems & Information Sources

4. An Information AgendaOne Approach to Achieving Information On Demand Create an approach for transforming information into a trusted strategic asset that can be leveraged across applications, processes & decisions for sustained competitive advantage Optimize Business Performance & Organizational Knowledge 4 Create, Manage, Govern & Deliver Trusted Information Business Optimization Create an Information Agenda 3 Optimize Content -based Operational & Compliance Related Processes 5 2 Manage Data Over its Lifecycle DB2, Informix, IMS… 1

5. Four Pieces… but where is the synergy? “When aiming to optimize costs in data management and integration initiatives, it is critical to know what steps to take and where significant savings can be realized while maintaining success in these projects. In most cases, the cost of implementing the steps will be far outweighed by the savings that can be realized.” -- Ted Friedman, Vice President and Distinguished Engineer, Gartner

6. The Synergy Story + + + + + OR + + + + + + +

7. The Synergy Story + + + + + A: You Q: Who invests in these integrations? A: IBM + + + + + + +

8. Market Leadership Data Integration CDI Data Quality PIM ETL Customer Hubs

9. The Construction of Our Single Platform IBM IBM Information Server Mainframe Integration Replication Event Pub (pre-2002) Ascential Acquisition Federation Content Integration Unstructured Information Mgmt 2002 2003 2004 2005 2006 Integrated Semi-structured Data Handling Integrated Matching Integrated Profiling SOA Deployment Architectural Unification Integrated Cleansing Grid Deployment Metadata Integration Ascential

10. Trigo Acquisition Master Data Management Construction Ascential Acquisition - Data Cleansing, Meta Data Management, ETL Operational MDM Customer Center CDI platform WCC MDM Platform 500+ Services Atomic Services SOA Framework DWL Acquisition 2006 1999 2002 2003 2004 2005 2007 Trading partner Collaboration New Product Introduction Collaboration Departmental Collaboration PIM platform Collaborative MDM Product Center

11. The Synergy Facts • IBM is the only vendor in the leadership quadrants in data integration, master data management, data warehousing, and business intelligence • IBM invests $1B per year in this portfolio and the synergy points • IBM has best practices & methodologies that extend across these domains • IBM leads has the most advanced integration across these components available in the market today • Customers who implement multiple pieces from the InfoSphere portfolio reduce their risk and time to market

12. The Big Picture Enterprise Data Warehouse Business Services SIF MDM Repository Staging Area Data Warehouse Real-time Partition Data Warehouse Design Business Applications DataWarehouse Model Services DataModel Business SolutionTemplates Customers Merchandizing Sources Essbase Products Data Analysis & Reporting ROLAP POS Data Mining OLAP Server * FrontOffice Predictive Modelling MDM Consumers Master Data Management Accounting Mgt Reporting ESB ERP Inventory ETL/Data Quality CRM HR Warehouse Management & Administration Metadata Management & Metadata Repository OtherSources

13. Existing Integration Points for Industry Models Generate warehouse structures through RDA BSTs provide design foundation for reports and cubes Pre-load Information Server with a business glossary & physical model for mapping Data and process models mapped to MDM model & business services Fit with our business requirements…..…....85% Savings from initial analysis phase .……....75% Design (inc. logical & physical models) ..…65% Estimated 6 to 12 weeks for Logical model build  Done in 2 Days

14. Models, Design Studio & Information Server Fit with our business requirements…..…....85% Savings from initial analysis phase .……....75% Mitigated project risk..………………. …….....20% Estimated 3 to 5 days to capture business metadata  Done in Minutes Upon import to the Information Server, relationships are automatically created between technical assets and business terms

15. Existing Integration Points for Information Server Pre-built MDM load routines & embedded cleansing & matching High-speed parallel warehouse connectors Direct import of terms into business glossary & physical models into DataStage & FastTrack Metadata lineage into Cognos End-to-end lineage traceability and impact analysis 20-25% decrease in the time spent in design 15% decrease in the time spent in the deployment 15-20% cost savings to build the warehouse Estimated 2000 staff days for project  Completed in 212 days

16. Information Server FastTrack To Reduce Costs of Integration Projects Through Automation “FastTrack usage can reduce the cost of ETL development in mid-size projects but 30%-40%.”…Wipro Utilizing FastTrack will bring significant productivity gains, quality improvement, documentation, and metadata transparency of our data integration tasks. It will also greatly improve the quality of our offshore development….Danske Bank • Business analysts and IT collaborate in context to create project specification • Leverages source analysis, target models, and metadata to facilitate mapping process • Auto-generation of data transformation jobs & reports Specification Auto-generates DataStage jobs Flexible Reporting

17. FastTrack Scenarios Source Metadata Target Metadata Industry Models FastTrack Data Warehouse Information Analyzer SAP Packs Information Analyzer FastTrack SAP MDM Server Information Analyzer FastTrack Industry Models “The ability to translate this information directly into Information Server withup to 70 percent of the code completed will significantly shorten our development lifecycle” - Bank Austria

18. What does this Field Mean? • Show relationships between business terms, data model entities, and technical and report fields • Provides cross-tool mapping of business terms • Allows field meaning to be understood • Allows business term relationships to be understood

19. Where Happens if I Change this Column? • Show complete change impact in graphical or list form • Includes impact on reports in BI tools • Visually navigate through impacted objects across tools • Allows impact analysis on any object type

20. IBM Information Server Where does a Field of Data in this Report Come From? • >50% report execs are now getting the information they want • >50% report a faster time to value (business gets reports faster) • Import & Browse Full BI Report Metadata • Navigate through report attributes • Visually navigate through data lineage across tools • Combines operational & design viewpoint Source Tables

21. Existing Integration Points for MDM Server Pre-built MDM load routines & embedded cleansing & matching Service integration with ESB Direct mapping of MDM data model to the Industry Data & Process models Pre-built integration to load InfoSphere Warehouse Information Server and MDM Server can reduce initial load by 25%-50%, and improve quality An MDM Rapid Deployment release can be in production in 3-4 months vs. 12-18 months

22. Existing Integration Points for Warehouse High speed parallel connectors from Information Server Integration with Cognos through cubing services Generation of warehouse structures from models using RDA Pre-built integration with MDM Server

23. Challenge No single view of merchant accounts across Amex Needed to combine multiple data sources into a single data warehouse Very short implementation timelines Solution Chose a complete InfoSphere stack: InfoSphere Information Server InfoSphere Warehouse IBM Industry Models Cognos 8 BI Results Rolled out their first data mart (just over 6 months) The synergies of the InfoSphere portfolio accelerated their project Now looking to expand into MDM An Example: American Express

24. Bottom Line • The InfoSphere portfolio addresses the majority of requirements companies face around their information • There is no more integrated portfolio on the market • IBM has the only portfolio which also leads in each and every category • IBM invests $1B each year on this portfolio and its integration • By choosing a more complete InfoSphere solution, organizations can reduce their risk & improve time to value

25. InfoSphere Strategy & Vision Leading The Market In Innovation • Continued Simplicity & Usability Advancements • Rule & Transformation Discovery • Automation to Optimization • Platform Analytics & Dashboards • Data Governance Tools

26. IBM Has Invested To Meet These RequirementsOne Single Information Platform • Business As Usual: • Projects 10x as long with individual tooling • Unified Platform Benefits: • Decreased risk by 53% • Improved business alignment 83% • Improve time to value by 75% • Reduce project staffing by 90% Source: Customer Case Studies, Industry Analyst Reports

27. Thank You!