Case Study: The University of Manchester improves Microsoft Dynamics duplicate management with KingswaySoft

The University of Manchester addresses 100K+ duplicate records with KingswaySoft

The University of Manchester faced the challenge of removing over 100,000 duplicate contact records within its Microsoft Dynamics environment. The institution needed a dependable solution to accurately identify and merge these records at scale while also establishing stronger controls to prevent future data duplication. To address this, they turned to KingswaySoft and its SSIS Integration Toolkit.

KingswaySoft provided a configurable SSIS-based solution that enabled the university to manage the entire duplicate record process, including identification, merging, and moving alternate key information. The KingswaySoft solution was validated through a successful proof of concept and ultimately executed in production, successfully addressing the vast number of duplicates and strengthening the university's data quality controls.

The University of Manchester