Data migration tools have saved the Rover Group about £2.5m over the last four years recent analysis has revealed.
The car manufacturer saved £800,000 in 1999 alone, by using the data integration tool ETI Extract from Evolutionary Technologies International in Rover's ongoing data warehouse project. The company says it would have spent an extra £1.4m by using traditional hand coding methods.
Dave Sangwine, data warehousing manager at systems integrator Softlab, a BMW company that provides IT services for Rover, said the original data warehouse, set up in 1989, could only support the data requirements of individual business units.
Rover needed a single source of information for at least 12 legacy databases for staff around the globe. "There are five separate divisions [within Rover] including warranty, distribution and finance, and no-one could see a vehicle completed across all five systems. Softlab copied all this data into one warehouse to give a single source of information."
When measured against competitive products, he said, ETI Extract stood out in terms of functionality, capability in large complex integrations and UK support. "This device generates completely readable and highly efficient Cobol and C programming code."
Sangwine said that many data warehousing projects were failing because companies were not using efficient data migration tools. "Companies have staff who support the systems but don't understand the data," he said.
"In most data migration projects there is a lot of re-working of software, but [by using ETI Extract] we can analyse the data and generate code much faster than before.