Using BusinessObjects Data Services in support of Data Migration and Master Data Management For the Chicago Chapter BOUG Meeting – August 20, 2010
Dan Lopez, Manager at Capgemini
2Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
• Why is Data Migration Needed?
How has SAP Data Migration Historically Been Done?
Emerging SAP Data Migration Best Practices
How do I Manage Data Quality after Data Migration?
Q&A
Agenda
3Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
SAP Data Migration/Conversion Use Cases
SAPMainframe
Legacy Application Modernization / ERP
Implementation
Global SAP
SAP Instance Consolidation
SAPSAP
SAPSAP
SAP
SAP
Application Portfolio Rationalization
JDE i2
PeopleSoft
4Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
• Why is Data Migration Needed?
How has SAP Data Migration Historically Been Done?
Emerging SAP Data Migration Best Practices
How do I Manage Data Quality after Data Migration?
Q&A
Agenda
5Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
How Has SAP Data Migration/Conversion Historically Been Done?
Used with permission from SAP
HistoricalApproaches
SAP LEGACYSYSTEM(S)
Custom Code
“Let’s cross the fingers’ and hope it loads…
What was needed was an approach that leveraged simplified tools, best practice methodology and content to address the full cycle of data migration processes.
Upload / ADM
?
But Data migration is far from easy. The results were:
Designing access to numerous source legacy systems and/or data silos
Proper mapping of source to target files Assuring consistent metadata Resolving data quality problems
Why?
More than 80% of data migration projects run over time and/or over budget. Cost overruns average 30%. Time overruns average 41%.Bloor, 2007
80% of organizations… will underestimate the costs related to the data acquisition tasks by an average of 50 percent”Gartner
Analysts
ABAP/ LSMW
6Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
• Why is Data Migration Needed?
How has SAP Data Migration Historically Been Done?
Emerging SAP Data Migration Best Practices
How do I Manage Data Quality after Data Migration?
Q&A
Agenda
7Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
Example Data Migration Best PracticesTaken From Capgemini's DELIVER Methodology
DELIVER: A tested methodology developed globally, based on a structured approach for the migration and quality improvement of data.
Focus Areas:• Data Discovery helps to determine
issues with data in an early stage and gives information needed to define conversion rules of higher quality.
• Frequent “Trial Conversions” or “Mock Migrations” are executed and tested against controls in order to provide quality and completion.
• Data mapping and cleansing leverages accelerators through a data migration factory model.
• Data controls are put in place up front in order to quantifiably measure the success of a data conversion, which is critical to the “Go/No Go” moment in the project.
DELIVER Data Migration Methodology
8Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
SAP’s Best Practices Architecture for Data Migration
Legacy Data Environment
Data Staging and Test Environment
Applications
Databases
Flat Files/Excel
Loading
Extract & Profile
Staging Area
SAP
Target Environmen
t
Data Services Platform
Cleanse
Name Parsing
Address Parsing & CorrectionMaterial/Product ParsingMatching
Reconciliation
Performance Analysis
Dashboards and Business Reporting
IDocs
load routines for SAP Objects
Validate & LoadTransform
Business Validation
RulesSAP Config Validation
TransformData into SAP
structure
Mainframe
Used with permission from SAP
9Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
Project Acceleration through SAP’s Best Practice For Data Migration
Key Features: Predefined Migration Content
Data validation content for SAP Business Objects Data Integrator (including enrichment rules) for the SAP Best Practices Baseline Package and a broad set of industries the content includes also extraction jobs to extract check tables from the SAP target system for the value mapping.
Documentation Quick guide on how to install and use Data Integrator and the
SAP Best Practices for Data Migration content.
Business Process Document for Data Migration is a process guide that provides a process flow and the sequence in which the objects need to be loaded
Business Process Documents for Objects are independent object documents that provide you instructions on the complete object processing tasks within DI all the way to loading IDocs into
SAP. Extension Guide provides the information you need to extend
and modify the DI content that is an integral part of the SAP Best
Practices Data Migration solution. Implementation Accelerator
Mapping templates for the mapping workshop at the customer site including field and value mapping.
Used with permission from SAP
10Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
SAP Best Practice for Data Migration Leverages BusinessObjects Data Services
SAP BusinessObjects™ Data Integrator is the most productive and scalable data integration platform for ETL
Currently supported Data Migration Content Built on Business Objects Data Services for SAP Business All-in-One
– Cost Element
– Characteristic
– Class
– Activity Type
– Activity Price
– Customer Master
– Vendor Master
– Material Master
– Material Master Classification
– Material Inspection Type
– Material Customer Replenishment
– Purchase Info Record
– Inspection Method
– Master Insprection Characteristics
– Inspection Plan
– Object Dependency
BOM
Routing
SD Pricing
Inventory Balances
A/P & A/R
HCM Baseline
Transactional data
Sales Order
Purchase Order
Internal Order
Source List
WBS
Functional Location
Used with permission from SAP
11Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
• Why is Data Migration Needed?
How has SAP Data Migration Historically Been Done?
Emerging SAP Data Migration Best Practices
How do I Manage Data Quality after Data Migration?
Q&A
Agenda
12Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
Apply the Same Technology for Data Migration After Go Live to Provide a Proactive Data Quality Firewall
Used with permission from SAP
13Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
Apply the Same Technology for Data Migration After Go Live to Provide Reactive Data Quality Scorecards
Used with permission from SAP
14Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
• Why is Data Migration Needed?
How has SAP Data Migration Historically Been Done?
Emerging SAP Data Migration Best Practices
How do I Manage Data Quality after Data Migration?
Q&A
Agenda
15Capgemini Business Information Management© Copyright Capgemini 2010 All Rights Reserved
Together. Free your energies
www.capgemini.com
The information contained in this presentation is proprietary. © 2010 Capgemini. All rights reserved
Dan LopezManager, Capgemini Business Information ManagementOrlando, Florida
Phone: +1 (407) 655-9176 E-Mail: [email protected]