Case Study

Case Study
Working Solution:

International Claims Adjuster - Application Modernization Archive

The Challenge

As part of its ERP modernization, one of the world’s largest insurance claims adjusters needed to dispose of multiple inherited systems and bring all its European offices under a common application data governance. The complexity of data migration for non-transactional data to the new ERP system was to be avoided, if possible.

The challenge was to find a flexible, capable archiving tool that could support the detailed user requirements at a significant reduction in operating cost.

The Solution

  • Implement DataNovata: The Enterprise Application Data Bridge and convert the different application data histories over to a generic SQL Server.
  • Generate an XML, Java-based, DataNovata application to replace each application and model the UI to support the user enquiry screens

The Project

Archive all the data history from 2 separate database structures with multiple tables and indexes for each application module, and render meaningful application UIs on any IP-enabled device:

  • IBM iSeries & Sun Systems
  • DB2, MySQL
  • System 21 and Sun Accounts
  • >50 users
  • GL, AR, AP, Cashbook, Asset Register, etc.

Minimal input from client IT Services allowed the client to focus on the new ERP system implementation.

The Result

  • The initial pilot proof of concept was completed in a matter of a few weeks.
  • The archiving solutions were completed, inclusive of user training, 6 weeks in advance of the new ERP system launch.
  • Only closing balances were migrated to the new ERP (green field). The history is accessible through the DataNovata applications on desktop and mobile devices.

"DataNovata demonstrated the flexibility of their toolkit and exceeded our expectations.”

CIO European Operations

DataNovata Regional Office Location Contact Information

England (Head Office)

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

North America

31 Disera Drive, Suite 250
Vaughan Ontario
L4J 0A7


Cortijada los Rincones de Mizala
Calle Mizala, 1

Asia Pacific