Many of us had the experience of trying to fit a comfy couch, or a large bed, into a room that is too small for it.
Option 1: Move on to a bigger house.
Option 2: Throw out the offending piece of furniture.
Of course, when the house is already paid for, and the couch is an heirloom, or a favorite piece, neither option 1 nor option 2 appeal.
So it makes a lot of sense to plan ahead.
Will your precious pieces of furniture fit into the new location? Or should you rather find somewhere else?
Migrating data is a lot like moving furniture
Often, in business, we outgrow one system and need to replace it with another.
A new system may provide better performance, handle higher transnational volumes, or offer more sophisticated functionality,
In order to maintain our organisational history we typically need to move existing data – customer, supplier, product and transaction data from the old system into the new system.
Unlike our old couch, data cannot simply be ignored if it does not fit.
Yet, like a large couch, data may not comply with new system constraints or may not map into the new table structures,
In fact, in many instances data issues cause substantial delays and cost over runs.
This is because functional teams typically focus on the new functionality required from the new system, and assume that data will fit as is.
Data profiling critical to successful data migration
Project managers need to understand and manage data risks that may impact their timelines.
Data profiling and discovery allows business to identify data issues early, plan the new system structures to fit, and adapt the data to fit the space.
Unlike our old couch, we can adjust data to make it fit better.
Learn more about data profiling with our online course. offered in partnership with elearningCurve.com, or call us on 0114854856
This analogy comes from the course, and is used with permission of eLearningCurve