Summary

  • Customer: IT solution provider
  • Country: India
  • Product Used: Ispirer Toolkit License
  • Source Technology: Oracle PL/SQL
  • Target Technology: Java
  • Project Scope: 100,000 LOC
  • Project Duration: 2016-2017

Customer

An Indian multinational company that provides innovative IT services. The company offers best-in-class technology solutions for clients around the world and strives to meet the distinct needs of every business.

Challenge

The company was considering migrating its application developed for the insurance industry, and was looking for a tool to convert PL/SQL procedures to Java. Ispirer Toolkit was selected as a useful software for this task.

Solution

The management of the company decided to perform PoC and evaluate the result in terms of the level of migration automation and tool readiness.

The PoC Stage included converting Oracle to Java with about 100,000 lines of code contained in packages, stored procedures, and functions. Ispirer provided the customer a Toolkit license, including the Extension Package to customize the tool in accordance with the project requirements.

During the Extension Stage, the Ispirer experts developed and added to the toolkit the following features:

  1. In-house solution for migration of collections (Collection type Associative Arrays and Nested Tables) with our own class generation and additional methods implementation;
  2. OUT (IN OUT) parameters conversion;
  3. Arithmetic operations with intervals and datetime conversion;
  4. Pipelined Table Functions migration;
  5. Creation of functions with complex logic corresponding to Oracle system functions:
  • TO_CHAR
  • TO_DATE
  • LPAD
  • LEAST
  • INITCAP
  • DECODE

After the toolkit customization, the Oracle code was moved to Java flawlessly and required minimal fixes after migration. When converting the rest of the customer’s code, as well as in any future migrations, Oracle PL/SQL will be automatically converted to Java equivalents according to the conversion rules added to Ispirer Toolkit during this PoC.

Benefits Derived from Conversion

The Proof of Concept Stage was successfully completed in 3 months. Meanwhile, Ispirer presented an automated solution that met all the customer's expectations. The company's management decided to continue transferring Oracle PL/SQL code to Java using Ispirer Toolkit, which proved to be effective in application conversion.