December 29, 2016
In today's business environment, every critical function an organization undertakes is increasingly reliant on information that is accurate, timely, complete, and integrated.
The move by larger companies (and increasingly by SMEs) toward fully integrated systems, generically referred to as ERP software has raised the bar even higher for maintaining data integrity. With the implementation of an ERP system, a robust data migration process is central and critical to the project’s successful implementation. Every system and subsystem relies on quality data, and historical data is often critical to business continuity.
A successful data migration improves business operations substantially, from enhancing data accessibility to improving data integrity. Before we can explain how to combat data migration challenges, it's important to understand what they are and how they can affect your business.
Data migration involves the transferring of data between computer storage types or formats, making it a key consideration for any system implementation, upgrade, or consolidation. During the migration process, data needs to be extracted from the source systems, transformed and loaded into the target system. This can be (and usually is) a complex and challenging process for many reasons; the following are perhaps the most common:
Migrations are performed infrequently and companies are usually unprepared for the challenges that lie ahead. One of the most important and common problems with data migration is the lack of involvement and participation by company management, thus degrading the importance of data migration projects. This is a task that requires collaboration and participation from all employees across the organization in order to ensure a successful outcome.
An incomplete or non-existent migration strategy; employees involved in data transfer should be very familiar with all the steps in the data migration process from start to finish.
Data quality issues that have accumulated over time, such as, dissimilar data structures for the same customer, incomplete or missing data, lack of legacy data standards. These problems are multiplied by the volume of data stored and used in organizations.
Underestimating the scale and cost of the data migration project; underestimating the scope and budget required for the project at the outset will almost certainly result in project overruns in both time and money (if not failure).
The following four key areas should be addressed in order to satisfy the requirements of a fully integrated migration process:
Data migration is not the sexy part of the project. Consequently, data migration planning is often given less priority and seen as an administrative ‘burden’ instead of a necessary and essential component of the project. A well thought-out strategy must be in place before attempting the data migration, with input from all the business stakeholders.
Given a broad enough scope, the data migration strategy can address issues of scope, timeline, and resources, as well as itemizing the administrative steps to be covered in the migration.
All corporate data is a business asset. It belongs to the organization and is one of the most important ‘tools’ of the business. If data is conceptualized in this manner, the idea of engaging and achieving a robust commitment from business management committed to the success of this project should not be difficult. Participation from management will ensure a process that is empowered to make the necessary decisions that will drive the required actions.
Proper allocation of resources and a timeline are critical aspects of the data migration project and contribute to the overall success or failure of the project. Refining and clearly defining the scope also makes it easier to determine the size of the budget and the eventual agreement from management.
Conducting an analysis of the source and target systems, in consultation with the business users (directly impacted by the data migration), will ensure a transfer process that is both fully functional and that has minimized the amount of data to be migrated.
Data integrity problems (as previously noted) begin as a failure to treat data as a strategic business resource. Data integrity requires the prioritizing of its maintenance and upkeep in a business strategy, with an appropriate budget allocation. This perspective should also be supported when dealing with data migration. A breakdown of data to-do’s is as follows:
A data migration is an integral part of any successful ERP implementation. As such, it must be given the priority that it deserves (at the planning stage) in order to fully and successfully participate in the overall successful ERP implementation.
Gabriel’s background includes more than 15 years of experience in all aspects of business software selection and implementation. His research work has involved detailed functional analyses of software vendors from various areas such as ERP, CRM, and HCM. Gheorghiu holds a Bachelor of Arts in business administration from the Academy of Economic Studies in Bucharest (Romania), and a master's degree in territorial project management from Université Paris XII Val de Marne (France).
Jack of all trades, master of none.
If you’re not worried about online security, you should be.
The ‘cloud’ is one of those fashionable words that has dominated tech discourse as of late,...
Jack of all trades, master of none.
If you’re not worried about online security, you should be.
Never miss a post.
Subscribe to keep your fingers on the tech pulse.