ERP-DataConversion-rev4

ERP-DataConversion-rev4 - ERP Data Conversion Ronald E....

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
1 July 10, 2007 1 ERP Methodology and Project Management ERP Data Conversion Ronald E. Giachetti, Ph.D. Associate Professor Industrial and Systems Engineering Florida International University August 18, 2006 Slide 2 Air Force Mentor-Protégé Program Data Conversion Data conversion is the transfer of data from an old information system(s) to the new system that is replacing it (them) Legacy Data ERP Data Legacy Data Legacy Data
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 August 18, 2006 Slide 3 Air Force Mentor-Protégé Program "Over 50% of all deployments suffer limited acceptance, if not outright failure, because of the lack of attention to data quality issues." -- Gartner s Data Conversion is High on most lists of ERP Project Risks Organization responsible for the effort Relationship to the project decision authority Expected complexity of the conversion effort Resources (budget, schedule, personnel) allocated to data conversion Automated support for data conversion Data Conversion Risks August 18, 2006 Slide 4 Air Force Mentor-Protégé Program Why Data Conversion is Difficult s Source systems were designed for local needs so the source systems are not consistent Different source types (Mainframe, Oracle, MS Access, excel, other flat files, and paper) Inconsistent formatting (currency as text) Inconsistent data coding (O 2 Sensor versus Oxygen Sensor) Each domain has its own terminology (ontology) for their area of specialty s Data has different owners s Data errors in source systems s There is a lot of data ! PHYSICAL HETEROGENITY APPLICATION HETEROGENITY SEMANTIC HETEROGENITY
Background image of page 2
3 August 18, 2006 Slide 5 Air Force Mentor-Protégé Program Data Conversion Process Define stakeholders and objectives Establish stakeholder buy-in Train SMEs and Data Migration team Evaluate and procure tools and technologies Identify and manage risks Model legacy process and data sources Collect data Analyze and profile data Validate and cleanse data Load and transform data Data Migration Execution Planning and Strategy ETL August 18, 2006 Slide 6 Air Force Mentor-Protégé Program Data Migration Process Legacy Data Interim Staging Data ERP Data Conversion (automated or manual) Direct Load Cleanse Data Legacy Data Legacy Data
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 August 18, 2006 Slide 7 Air Force Mentor-Protégé Program Possible Failures A missing source file A system failure Inadequate metadata Poor mapping information Inadequate storage planning A source structural change No contingency plan Inadequate data validation Incorrect data conversion process August 18, 2006 Slide 8 Air Force Mentor-Protégé Program Data Team Members s Data object owner s A Legacy Expert s Data subject matter expert s An ERP functional specialist s Data migration analyst LEGACY ERP Avoid conflict between constituencies
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/07/2011 for the course ERP 2000 taught by Professor Giachetti during the Spring '11 term at FIU.

Page1 / 15

ERP-DataConversion-rev4 - ERP Data Conversion Ronald E....

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online