Case Study

Case Study
Working Solution:

Northampton Borough Council

The Challenge

While Northampton Borough Council was engaged in upgrading its core VME production systems to modern Windows Server-based software solutions it became apparent that the cost and time to convert the old data to the new systems would be prohibitive. Northampton was faced with the choice of continuing to finance its VME infrastructure for the sake of 15 GB of data or to archive the data and lose direct access.


The challenge was to help Northampton Borough to cost-effectively retire its Fujitsu VME mainframe within the upgrade timeline, without losing direct access to the data or compromising the roi benefits of the overall systems upgrade.


The Solution

• Implement DataNovata: The Enterprise Application Data Bridge, to convert the data over to SQL Server with all the relationships intact.
• Generate an XML, Java-based, DataNovata application that mirrors the original application screens.

The Project

Decommissioning 7 applications containing 15 GB of financial records and converting the data to an open platform application view for interrogation and analysis:
• CTAX (Council Tax)
• HBIS (Housing and Council Tax Benefits)
• OAP (Orders and Payments)
• UNIPAY/PER (Payroll and Personnel)
• PALS (Public Authority Ledger System)
• HREP (Housing Repairs) IHSL (Integrated Housing Rentals and Lettings)

Some applications lacked documentation and source code was not available, DataNovata expert data consultants successfully deduced the data logic to proceed without a hitch.

The Result

• This project took 6 months from start to completion, using remote access to the VME mainframe and Windows Server.
• Northampton Borough Council successfully retired its mainframe and retained direct access to the data.
• DataNovata enabled Northampton Borough Council to fulfill its mandate.

“The DataNovata applications not only
replicate the original applications’ enquiries,
but do so with a considerably improved &
more intuitive user interface”
Gary Steng, IT Infrastructure Manager

England (Head Office)

Barlow House, 4 Minshull Street,
Manchester, M1 3DZ, UK

North America

31 Disera Drive, Suite 250
Vaughan Ontario
L4J 0A7

Europe

Cortijada los Rincones de Mizala
Calle Mizala, 1
Sorbas
04270

Asia Pacific

34a Mulyan Street,
Como West, Sydney,
NSW 2226, Australia