Back to Customer Stories

Effectively Migrating Legacy Data Into Workday

A Workday Partner wanted to help their customers implement and embrace Workday. Instead, they were finding their time was being spent on data migration planning and fixing data quality.

Their projects usually followed the similar formula of migrating data from legacy systems to Workday. They were having to manually manage each migration from scratch, leading to time being wasted on repetitive work instead of adding the real value they had intended.

A bespoke data migration framework

The firm were looking for ways to save valuable time and enable them to perform faster data migrations. But using generic tools would require them to expand their skillset beyond Workday, an expensive distraction from their billable project time. They needed a solution that would give them the power to fix and verify input data, perform the necessary data conversion, ingest it into Workday, and provide an easy way to manage errors  - all while hiding the complexity so that consultants didn’t need to dive into ETL processes. So that’s what we built for them.

Built in data quality

The migration framework built on CloverDX validates and transforms arbitrary customer data into a Workday friendly format and then loads it directly into individual Workday modules. The solution also has data quality checks built in. Errors and inconsistencies in the client’s legacy data often significantly slows down project delivery, so the data migration framework needed to be efficient in identifying faulty data.

We ensured that error descriptions were easy to understand, so consultants could share them with the client, combining technical understanding of the data with the client’s domain knowledge for quicker resolution.

Planning for the future with a reusable approach

As well as providing module-specific data validations and common data mappings, thereby eliminating a lot of the repetitive work, the solution can also easily adapt to new data, with the consultants only needing to configure inputs and project specific variables.

The reusable migration approach has drastically reduced the time the consultants need to spend on data migrations, so they can focus more on helping their clients get up and running with their new Workday implementations.