University of Manchester Duplicate Record Management Case Study

This case study details the University of Manchester's implementation of KingswaySoft's SSIS Integration Toolkit to manage duplicate contact records within its Microsoft Dynamics environment. The university faced the challenge of over 100,000 duplicate records that required identification and merging to enhance data quality. The objective was to not only cleanse existing duplicates but also to establish an alternate key for contacts to prevent future duplications. The integration specialist, Andy Lea, utilized the toolkit's components, including the Duplicate Detector and Dynamics CRM/Dataverse functionalities, to configure a comprehensive duplicate management process. The solution enabled the team to effectively identify duplicates, select master records, and execute the built-in merge process. The successful proof of concept validated the approach, leading to efficient execution. The results included improved data quality and stronger controls to mitigate future duplication risks, demonstrating the effectiveness of KingswaySoft's configurable functionality and reliable documentation.