Application Consolidation for Enterprise Applications ERPCRM Rick L

Application Consolidation for Enterprise Applications (ERP/CRM) Rick L Miller, WW Program Manager, IBM Information Management

Enterprise Applications Support Core Business Processes • Highly interdependent applications SAP Component (ERP) SAP Enterprise Portal SAP Component (SCM) SAP MDM SAP XI/PI ESR SAP Component (BI/BW) • Support critical business processes like order to cash • Require complex deployments, data migrations and upgrades • Inherently risky and prone to failure

The Problem Continually growing islands of information coupled with lack of governance processes increase the challenges of consolidating applications Uncertainty Creates Risk § What are the right data sources? § What is the state of the legacy data? § Are we simply moving our data quality issues? 47% of users don’t have confidence in their information 59% of managers miss information they should have used 42% of managers use wrong information at least once a week AIIM & Accenture Surveys, 2007 § What legacy data is missing for the new environment? § How can we build accurate project specifications to limit risk? § How do we keep data from becoming the critical path?

Typical Risk to Data Migration Projects 83% of migration initiatives either overrun their budgets or fail outright • Data sufficient for legacy systems, but not sufficient for SAP • Lack of documentation of existing systems • Poor quality of data in source systems • Multi-brand complexity • Errors detected late in project lifecycle leading to re-work and delays Source: The Gartner Group – Corporate Integration Projects

Data integration activities will consist of 15 – 30% of total project spend Between 20 and 40% of your implementation expenses should be allocated to data migration 1 1 Direct from SAP’s Legacy System Migration Workbench (LSMW) manual

Data integration activities will consist of 15 – 30% of total project spend Data Integration/Migration Activities Discover Prepare 30% Understanding Source Data 40% Cleaning, Standardising Harmonizing, Management Largely manual effort on small percentage of data. Some manual coding can review all data. This effort is the most unpredictable. The work can vary greatly depending on condition of data, however it is always the largest piece of work in the data initiative. Largely manual effort on 100% of data. This can mean dozens of persons cleaning source systems manually to correct and augment data and manually aligning records to MRD. Some manual coding can reduce the manual effort. Deliver 30% Conversion, Loading, Interfaces, Connectivity Coding transformations and loads. Traditionally this effort is plagued with problems related to data quality and it can easily be pulled by necessity into the Cleaning, Standardising and Harmonising area causing timing and budget problems.

Data integration activities will consist of 15 – 30% of total project spend Data Integration/Migration Activities Discover Prepare 30% Understanding Source Data 40% Cleaning, Standardising Harmonizing, Management Largely manual effort on small percentage of data. Some manual coding can review all data. This effort is the most unpredictable. The work can vary greatly depending on condition of data, however it is always the largest piece of work in the data initiative. Largely manual effort on 100% of data. This can mean dozens of persons cleaning source systems manually to correct and augment data and manually aligning records to MRD. Some manual coding can reduce the manual effort. Deliver 30% Conversion, Loading, Interfaces, Connectivity Coding transformations and loads. Traditionally this effort is plagued with problems related to data quality and it can easily be pulled by necessity into the Cleaning, Standardising and Harmonising area causing timing and budget problems. Reality is 70% of the activity required to be successful with the data migration occurs here

Data integration activities will consist of 15 – 30% of total project spend Data Integration/Migration Activities Discover Prepare 30% Understanding Source Data 40% Cleaning, Standardising Harmonizing, Management Largely manual effort on small percentage of data. Some manual coding can review all data. This effort is the most unpredictable. The work can vary greatly depending on condition of data, however it is always the largest piece of work in the data initiative. Largely manual effort on 100% of data. This can mean dozens of persons cleaning source systems manually to correct and augment data and manually aligning records to MRD. Some manual coding can reduce the manual effort. Deliver 30% Conversion, Loading, Interfaces, Connectivity Coding transformations and loads. Traditionally this effort is plagued with problems related to data quality and it can easily be pulled by necessity into the Cleaning, Standardising and Harmonising area causing timing and budget problems. Estimates are often based on this

Data integration activities will consist of 15 – 30% of total project spend Data Integration/Migration Activities Discover Prepare 30% Understanding Source Data 40% Cleaning, Standardising Harmonizing, Management . 75% Business 25% IT Deliver 30% Conversion, Loading, Interfaces, Connectivity 25% Business 50% IT 75% IT There is a more significant involvement by the business users in the up front activities. Not understanding the roles and responsibilities required can negatively impact the project.

Data Quality Issues/Risks Ø Poor quality data from source systems Ø Projects delayed due to data quality problems ü Duplicate data ü Inability to load data ü Irrelevant data ü Data attributes insufficient to execute cross functional business processes ü Embedded business rules Ø Data sufficient for legacy systems not sufficient for ERP ü Data gaps require augmentation strategies Ø Multiple change requests required to deal with data issues Ø Decisions to “go with what we have” and clean up the mess later Ø Error detection and reprocessing is iterative and time consuming Ø Data migration issues lead to Inaccurate reporting Ø Critical data issues often are not found until late in Realization and Final Prep Ø Customer satisfaction suffers Ø Poor system adoption

Incorrect Data Loaded Correctly into SAP Customer Master Data Irrelevant data Lack of address validation or verification Duplicate data

SAP Integration Requires High Quality Data Product Costing Planning MPS Sales Order MRP Planned Order Production Order Goods Issue Raw Purchase Requisition Goods Receipt Delivery Goods Issue Finished Goods Receipt Customer Profitability Analysis Billing SAP Master Data in Business Flow Vendor Material G/L Account Purchase Order Invoice Receipt Customer Payment Vendor Payment

Best Solution Is To Fix Problems Early Find problems early, reduce pain (risk, $, time) later Relative $cost of fixing error/issue Project Lifecycle 110 Info. Sphere Approach 90 Relative Effort 70 Traditional Approach 50 30 10 Analysis Mapping System Test Load Benefits of This Approach ► Reduce risk – surface and address issues early ► Maximize value from Subject Matter Expert resources ► Lower cost than traditional approach Post Cutover

Application Consolidation with Info. Sphere Benefits vs. Hand-coding and services-only solutions Discover 50 – 90% Savings Prepare 50 – 90% Savings Benefits Deliver 40 - 60% Savings Implement and Monitor 73 – 90% Savings Ø 45 to 80% of total integration cost savings in the initial project Ø Ensures trust for timely Go-Live and Production Deployments Ø >75% ongoing project savings for new implementations/waves Ø Ensures lasting data quality

Enabling Trusted Information 1 Discover Analyze Source Systems Before Blueprint • • • 5 Eliminates surprises Provides an objective basis for planning Minimizes re-work by increasing accuracy of specifications Identifies data strengths and weaknesses Quantifies data quality impacts pre-transformation Support Design Employ Ongoing Data Quality Process Apply to Blueprint Design Workshops • • • 4 Monitor critical business rules Trend data quality over time to identify problem areas Assess Data Quality periodically Governance Maintain Data Quality Through Controls • • • Apply end user controls for standardization, validation and augmentation Apply standardization, validation and augmentation in master data synchronization strategy Apply standardization, validation, augmentation to operational interfaces Provides enterprise standardization Identify matched records across or within sources Survive the best possible record sets for target Analyze free form text and split domains Identify embedded business logic Apply data correction and augmentation Delivery Apply Results to Realization of Data Integration • • 2 Provides transformation logic (mapping tables) Identifies faulty logic & aids acceptance testing Captured business rules for reuse Apply data correction and validation in Batch and Real Time 3

SAP Provisioning Environment Substantial acceleration for SAP migrations & consolidations DATA HARMONIZATION DATA ALIGNMENT DATA EXTRACTION PROVISIONING AREA QS, DS Cognos ALIGNMENT AREA FT, DS GAP REPORTS STAGING AREA IA, QS IDA, DS BG, MWB LEGACY SOURCES

Commercial Metals Company Global Consolidation of 200+ locations into a single SAP Instance Challenge • CMC needed a single view of its customers to understand their business across all divisions. • CMC was unable to rapidly and dynamically analyze their global manufacturing capacities. As a result, they could not make optimal decisions on where to fulfill demand or take advantage of manufacturing techniques such as Global Available-to-Promise (ATP). • CMC needed to adequately leverage global spend across all divisions with their suppliers. Info. Sphere Solution Ø CMC has invested in SAP software to help them create common business processes and reduce the total cost of ownership of their information technology assets. Ø CMC purchased IBM Information Server to rationalize the data that will be loaded into SAP and create a common view of data globally. Benefits § Merged divisional silos of data into a single view of customer. § CMC will use IBM Information Server to rationalize the data being migrated from legacy systems into SAP. § Eliminated manual processes, allowing CMC to utilize IBM Information Server coupled with the IBM data integration methodology to accelerate and standardize the migration process § Completed first 2 migrations onschedule. Aggressive 3 month rapid migration cycle through 2010

ERP Data Integration Realities Ø Moving to ERP will not make data quality issues go away, it will expose them Ø ERP will allow data to be loaded that is either not relevant or will load, but is not clean Ø As data is loaded into ERP extensive validations are performed (for example a full Customer Master object has over 400 validations) Ø ETL tools alone do not provide support for all necessary data integration activities. This is more than a mapping activity. Ø Legacy data must be recast into the ERP load formats and only have a fraction of required attributes to run ERP business processes Ø Project milestones are often delayed due to ERP validation errors. This represents a lot of extra development time and project risk Ø Loading data correctly into ERP is not the big issue, loading correct data correctly into ERP is the real issue

Info. Sphere Benefits in an SAP Enterprise Enhancing the bottom line by simplifying & reducing implementation cycles and ensuring sustained value Ø Accurate Assessment & Design of Business Processes Ø Accelerated Data Migration Ø Ensuring on-time Go-Live’s Ø Repeatable & reusable infrastructure for on-going legacy system interfaces Ø Enforced Data Quality & Governance Ø Establishing Enterprise Master Data integration

Thank you! For more information please visit: http: //www. ibm. com/software/data/infosphere/