ADSO conversion, database modernization, COBOL conversion, mainframe assessment, idms to oracleDŵr Cymru Welsh Water is the sixth largest of the ten regulated water and sewerage companies in England and Wales. They are primarily responsible for providing over three million people with a continuous, high quality supply of drinking water. They also supply sewer services for taking away, treating, and properly disposing of the wastewater that is produced. They replaced their Fujitsu/ICL VME mainframe-based Customer Accounting System applications with a modern, commercial off-the-shelf (COTS) solution running on Windows. However, regulatory requirements mandated that at least seven years of customer billing data was to be archived and accessible at all times, a request which the COTS solution was unable to accommodate. As a result, three IDMSX databases containing all seven years of required historical billing data were left in place on the mainframe to meet the requirement, to be accessed as needed.

It became apparent that retaining the mainframe solely to hold and access archived billing data was not cost effective. They needed a solution, fast. Modern Systems came in, converted the IDMSX databases to a single SQL Server database, migrated the applications used to access the data to Windows, and helped Dŵr Cymru Welsh Water shut their costly big iron down for good, in less than four months. This is the story of how it was done.

This case study covers the following:
  • The factors driving Dŵr Cymru Welsh Water's decision to modernize
  • Database modernization best practices
  • Snapshots of each project phase
  • The shocking reduction in database & application footprint that resulted in the end