BluePhoenix completes Israel Phoenix-Hadar post-merger database consolidation

The project covered more than 440 million data records.

BluePhoenix Solutions (BPHX) today announced that it has completed a mission-critical code and data merge project at the Israel Phoenix Assurance Company, one of the largest insurance firms in Israel. The automated BluePhoenix DataMigrator and Remediator technologies were used to integrate Phoenix' IT systems, following a merger between the Israel Phoenix and Hadar Insurance.

"Following the merger, we had to seamlessly integrate two large IT systems that used a variety of coding and naming conventions. The project had to provide us with the capabilities to standardize all insurance policies and services," said Israel Phoenix Assurance CIO Ada Markman. "Based on the successful project we did with BluePhoenix three years ago, we knew that they would be the best choice for this job, too."

The project covered more than 440 million data records, 400 Oracle tables, 2400 COBOL programs and 2000 SQR, SQL and shell scripts in several phases -- data migration, code merge, and field adjustment.

First, the data was integrated by converting the Hadar database and loading it into the Phoenix database using the automated BluePhoenix DataMigrator tool. Second, a large number of programs needed to be adjusted in order to ensure that all codes and entities match in both IT environments. Using the pattern utility of the automated BluePhoenix Remediator tool, which identifies the changes required for each file, hundreds of COBOL, SQR and SQL programs as well as shell scripts embedded into the business logic were amended and expanded according to the company's business rules.

Founded in 1949, the Israel Phoenix Assurance Company is the third largest insurance group in Israel. The firm covers all general insurance lines of business, including life, motor vehicle, property, liability, and health care.

Published by Globes [online] - www.globes.co.il - on Tuesday, June 08, 2004

Twitter Facebook Linkedin RSS Newsletters גלובס Israel Business Conference 2018