data migration erp ax
DESCRIPTION
Data Migration MethodologyAhmed Rafik - ERP Coachwww.ahmedrafik.comTRANSCRIPT
![Page 1: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/1.jpg)
Data Migration - ERP
![Page 2: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/2.jpg)
Content:
- Data Movement Techniques.- Four Basic Rules in Data Migration.- Data Migration Strategy.- Data Migration Methodology.
![Page 3: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/3.jpg)
Data Movement Techniques
Consolidation MigrationUpgradeIntegration
Many-to-One One-to-OneMany-to-Many One-to-One
![Page 4: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/4.jpg)
Four Basic Rules in Data Migration
Data Migration is a business Issue.
The Business Knows Best
No one Needs Perfect Data
If you can’t count it, it doesn’t count.
Source: ERP System Research - Method of data migration from one ERP system toanother in real time - University of Zagreb - Pavlinska , Croatia
![Page 5: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/5.jpg)
Data Migration Strategy
Hand Coding ETLV Replication EAI
ETLV is the preferred technology for data migration
Lack of productivity. Easy & accessible, misses some requirements.
Enterprise application integration cannot handle the extreme volume.
Handle the extremerequirements of data.
Source: TDWI Technology Survey, February 2006. 166 respondents.
![Page 6: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/6.jpg)
Data Migration Strategy in ERP
ETLV Strategy
Extract Transform Load Validate
E T L V
Extract Data from Source System
Transform Data for the Target
System
Load Data into the Target
System
Validate the Data Loads
![Page 7: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/7.jpg)
Data Migration Methodology
Plan Migrate Validate
Gather Requirements
Data Identification
Create Migration
Plan
Validate Data
Documentation
Reporting
![Page 8: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/8.jpg)
Data Migration MethodologyPlan
Gather Requirements
Data Identification
Data Required to upload
Data Quality Assessment
Cleansing Data
Migration Plan
![Page 9: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/9.jpg)
Data Migration MethodologyPlan
Gather Requirements
Data Identification
Coding Structure Data Configuration
Master Data “Static Data”
Sub-Master
Data
Transaction Data“Dynamic Data”
Cleansing Data
Migration Plan
![Page 10: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/10.jpg)
Data Migration MethodologyPlan
Gather Requirements
Data Identification
Determine Migration Team
Determine Timing of Migration
Generate Data Templates
Master Data
Template
Design Mapping “Data Mapping
Assessment”
Develop Test Plan
Migration Plan
Transaction Data
Template
![Page 11: Data Migration ERP AX](https://reader037.vdocuments.us/reader037/viewer/2022100215/5476c46bb4af9f2d0f8b458c/html5/thumbnails/11.jpg)
Thanks…
Ahmed Rafik