The Story
Enable was hired by the City of Olathe’s court software vendor to convert nearly 30 years of records from their legacy system to their new solution. Due to the sensitive and confidential nature of the information being converted, the entire project team was required to pass police and FBI background checks before being granted access to the system and the entire conversion process was completed on the City’s secure servers. Enable used our formal Extract, Transform, Load (ETL) methodology to rationalize and migrate all of the legacy data to the new system. Our process includes the following steps:
- Develop a mapping strategy
- Complete field mapping
- Create custom mapping and conditional field logic
- Load legacy data into the test environment
- Test and validate results
- Load legacy data into the production environment
The Result
Due to multiple issues with the historical data and the opaque nature of the legacy system, the Enable team lead the mapping effort to discover how and where legacy data was stored and linked, scrubbed and normalized this data while eliminating over 60% of the duplicate name records.
As a result, the City was able to successfully GoLive with their new system, improve its business processes and efficiency and utilize the powerful new search tools with their extensive historical records