Whitepaper: The big secret to painless data migration

Published on the 22/10/2016 | Written by The Analytics Company

Painless data migration

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?

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

Download iStart PDF

The big secret to painless data migration


Cash trapped_Esker

Whitepaper: How to make your cash work harder for you

August 6, 2020 | Esker

Free up your cash trapped in inefficient AP and AR processes…

Sage Business process ebook

eBook: Streamline your business operational process

February 27, 2020 | Sage

Discover how three technology trends can help you overcome today’s top four industry challenges…

Sage_CFO 3.0 whitepaper

Whitepaper: CFO 3.0 – Digital Transformation beyond Financial Management

February 27, 2020 | Sage

Uncovering the gap between the perceptions and reality of digitalisation in finance…

Inventory management

Whitepaper: How to pick an inventory management solution that scales with your business

September 26, 2019 | Oracle NetSuite

Learn how to pick a software solution that supports the mission of a growing company…

Future of finance in CFO hands

Whitepaper: The future of finance is in the CFOs hands

September 26, 2019 | Oracle NetSuite

Learn why CFOs should look at different ways to become more strategic…

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.

Follow iStart to keep up to date with the latest news and views...