Whitepaper: The big secret to painless data migration

Published on the 22/10/2016 | Written by insightsoftware


The art of making old data mesh with new data structures and integrate with new data can be a dark one, but the experts at Jet Reports believe it doesn’t have to be painful…

The world is a dynamic place. Businesses change, companies merge, and technologies shift while applications come and go. Change is constant, so the ability to manage change is always in demand.

When we are talking about Enterprise Resource Planning (ERP)systems, change is more prominent than ever.

Organisations change their ERP systems in search of efficiencies to be gained from a new data structure, a new set of software tools, and hopefully the better integrated processes these systems are designed to support. The catch is, ERP data itself is often less dynamic than the environment it lives in. All those facts, events and transactions, happily living in their legacy format, won’t automatically snap right into thenew format.

Legacy data is valuable – it might even represent the very lifeblood of the company itself. Important as it is, legacy data can sometimes get ignored, until it rears up ‘Fatal Attraction’ style and demands attention. Data migration is one of the last steps before the production phase of a new ERP implementation. The main focus up to this point is placed on choosing, planning for and customizing the various ERP modules to be deployed.

The actual data the ERP was designed to house sometimes receives scant attention until go-live is imminent and time becomes a scarce commodity.

This situation is tragic because legacy data is a key component to the success of a new ERP implementation.

When users can access old data in a new ERP with its new screens, new commands and new processes, it understandably proves to them that the newERP is ‘working’. Welcome to the black art of data migration.

Top tips for dealing with legacy data

Regardless of the timeline for doing so – earlier is better – decisions and trade-offs must be made about the historical data. These generally bubble up out of a collection of seemingly innocent questions that invite emotional responses and have far reaching implications.

  • What is going to be migrated, and what is going to be left behind?
  • How should we clean the old data?
  • How should we restructure it?
  • How much history do we need?

 

The big secret to painless data migration

 

 

To find out more please download our free Whitepaper: The big secret to painless data migration

Download iStart PDF

 

 

 

 

FURTHER READING

Whitepaper: Data warehouse automation and ERP

July 30, 2021 | insightsoftware

The benefits of incorporating a data warehouse when upgrading your ERP…

eBook: The new AP department

November 10, 2020 | Esker

What to expect for the future of payables…

Financial year-end

Whitepaper: Streamline your financial year-end close

November 10, 2020 | insightsoftware

Manual processes can lead to error-prone data analysis…

KPI and metrics for finance depts

KPIs and Metrics for Finance Departments in 2020

October 27, 2020 | insightsoftware

What is a Finance Department and Manager Level KPI?…

Financial Planning_insightsoftware

Making Financial Planning a continuous and popular activity

October 15, 2020 | insightsoftware

One of the lessons learned from COVID-19 is that the old way of planning doesn’t work anymore…

Post a comment or question...

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Processing...
Thank you! Your subscription has been confirmed. You'll hear from us soon.
Follow iStart to keep up to date with the latest news and views...
ErrorHere