using businessobjects data services in support of data migration and master data management for the...

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


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






Q&A

Agenda


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






Q&A

Agenda


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


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



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.



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







Q&A

Agenda


Apply the Same Technology for Data Migration After Go Live to Provide a Proactive Data Quality Firewall



Apply the Same Technology for Data Migration After Go Live to Provide Reactive Data Quality Scorecards







Q&A

Agenda


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]

using businessobjects data services in support of data migration and master data management for the...

Documents

data migration methodology

support of data migration

data mapping

data controls

data conversion

data migration projects

data discovery

master data management