Solving Data Quality and Migration Issues

Successfully delivering a repeatable data migration and transformation assurance solution for a local UK authority.
Grupo 670@2x

Local Authority Case Study

The Challenge

Migrating data from SAP to Unit4 ERP, which is often completed with limited success.

The Outcome

Migration time reduced by 48%, while providing a high-functioning, repeatable transformation and migration approach. A new standard for ERP migration was set, helping save resources to focus on manual testing..

Group 867
Here you can edit the background of the section

Moving from SAP to Unit4 ERP

When migrating from one ERP system to another, data migration and transformation can cause a significant bottleneck for any implementation consultant. Accuracy and speed are vital when implementing the migration. As market leaders in data migration assurance, many of the UK’s leading consultancies lean on IDS to support and accelerate the migration and offer complete data certainty.

They recognized that the data migration and transformation process had become a bottleneck on previous implementations with public authorities and needed to significantly streamline the process.

A large local authority had decided to migrate away from SAP to a new ERP solution, Unit4.

Our partner, Embridge Consulting, a leading implementation consultancy, has a proven delivery methodology for performing rapid migration and transformation away from SAP to Unit4 ERP. However, the process in the past had been problematic and slow, with data quality not prioritized.

They needed a partner with specialist data migration, transformation and assurance credentials to provide a mechanism that assured the migration and transformation of data had quality gates. Furthermore, it was vital to assure that the data transformation rules had been thoroughly tested.

The ultimate goal was to assure the data was available in the correct format and location in the target database – but increasing the speed of the migration was a key driver.


Ensuring data certainty and integrity at each stage is where IDS have provided the most value to our clients

Emma O’Brien, CEO, Embridge Consulting


"55% to 75% of all ERP migration projects fail to meet their objectives"

iData is a bespoke data transformation and migration assurance engine that automates the process of validating that transformation rules are correct. Data is ingested from a source before following a slick process to improve data quality prior to any transformation. This is completed using template scripts that can be easily edited to drive the focus of each test and assure the transformation process.

By adding templates, there was rapid script creation and faster feedback loops for each data migration cycle.

How exactly did iData perform in this complex process?

Download the full case study using the link below.