Download
practical data migration n.
Skip this Video
Loading SlideShow in 5 Seconds..
Practical Data Migration PowerPoint Presentation
Download Presentation
Practical Data Migration

Practical Data Migration

300 Views Download Presentation
Download Presentation

Practical Data Migration

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Practical Data Migration How to enjoy a migration experience John Morris

  2. What’s Coming Up • Who am I? • Migration – The Big Opportunity • Migration – The Big Risk • Industry Standard Migration Model • The New Model • Questions?

  3. Who Am I? • John Morris • 20 plus years in IT • 9 years specialising in Data Migration/Integration • Joint founder of iergo ltd • Author of “Practical Data Migration”

  4. Some of my previous engagements……….

  5. Migration The Big Opportunity • Realising the business case • Making full use of new features • De-risking the project • Realigning technology with enterprise values • Building bridges with the business • Adding value • Whatever your drivers are • ROI • Governance/Compliance • Project Control

  6. Migration - The Big Risk • Tales of migrations that have gone wrong…….. How can we prevent this happening and realise all the good things?

  7. Source Applications ETL Rules Re-try Load Tool Business Users Industry Standard Approach Errors Target

  8. Source Applications ETL Rules Re-try Load Tool Industry Standard Approach • Blue Sky • Well formed and ill-formed problem domains • Emphasises technical over business • Lacks project control leading to uncontrolled recursion “All too often Migration projects start with the technical and end in disaster” Errors Target

  9. Case History Example • The Challenge: • Half the budget was spent building an ETL tool • The users rejected the quality of the data • The users rejected the data source selection • The users rejected the appropriateness of the solution to their environment

  10. Case History (cont) Dramatic improvements when we altered the project drivers: • Put business issues first • Natural division of opinion about where the best data lies • Natural division of opinion about definition of business objects • All of this is already resolved in the business • Get this knowledge out of the business and into the project

  11. The New Model • Not just about moving data from one place to another • Realising all the benefits promised by the software salesman • Adding value • Improving business performance

  12. Golden Rules Golden Rule 1 Data Migration is a Business not a technical issue. Golden Rule 2 The Business knows best Golden Rule 3 No enterprise wants, needs or will pay for perfect quality data Golden Rule 4 If you can’t count it, it doesn’t count

  13. Legacy Data Store System Retirement Policies Data Quality Rules Tool Kit of Techniques

  14. Project Controls New Supporting Techniques Project Initiation Legacy Investigation Qualify Legacy Fit Introduce New Model Migration Design Migration Build & Deploy

  15. Project Controls New Supporting Techniques Source Applications ETL Rules Errors Re-try Load Tool Project Initiation Legacy Investigation Qualify Legacy Fit Introduce New Model Industry Standard Approach Migration Design Migration Build &Deploy

  16. Questions?