Customer

It was real estate financial and IT services provider. The company specializes in introducing high technology solutions into their customers’ businesses in property sector. The firm renders a wide range of advisory and consulting, load and tax management services.

They also develop applications for property management, including programs for sales history and client management. A network of service centers across the country guarantees prompt communications flow between national real estate agents, equities market players and credit organization.

Technologies

IBM DB2 LUW, COBOL, Oracle PL/SQL

Challenge

The client wanted us to migrate the DB2 database to Oracle. The task also involved COBOL scripts conversion into PL/SQL. There were triggers and stored procedures to be moved from DB2 to Oracle, that contained about 60 thousand lines on code, and other types of database objects. The goal of this project was to perform the move of the database and the application to Oracle PL/SQL and to maintain accuracy and technical liaison.

Solution

Some pieces of COBOL code contained special characters. To achieve better automatic conversion by the Ispirer Migration and Modernization Toolkit 2015, Ispirer developers added new conversion rules according to the specification. After comprehensive testing procedure, the customized Toolkit ready to perform the migration at the highest level was delivered to the client.

During extension stage Ispirer Toolkit developers additionally expanded business logic metadata.

Results & Advantages

This project involved a short-term migration that took less than 4 months. Evaluation of client’s target code requirements and exact compliance with them contributed to the faster results and high precision of conversion. Ispirer migration experts controlled all the migration process and provided professional maintenance and consulting.

2014