Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Oracle to Java Conversion, India

Customer

At the beginning of 2017 an Indian multinational company that provides innovative IT solutions and services turned to Ispirer Systems. 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 migration of its application developed for Insurance industry and was looking for a tool to convert PL/SQL procedures to Java. Ispirer Migration and Modernization Toolkit was selected as a helpful tool for this task. The Company’s management decided to perform a PoC and evaluate the result in terms of migration automation level and tool readiness.

Solution

The PoC included the conversion from Oracle to Java of around 100 000 lines of code containing in packages, stored procedures and functions. Ispirer has provided MnMTK license including Extension Package for tool customization according to Customer’s requirements.

Being ready to handle the task quickly and efficiently Ispirer experts have 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 (datetime)
    • TO_DATE
    • LPAD
    • LEAST
    • INITCAP
    • DECODE

After the Toolkit customization, the Oracle code selected for this POC was moved to Java flawlessly and required minimum post-migration corrections. And when converting the rest of the Customer's code as well as in any future migrations such Oracle Pl/SQL code will be automatically converted to Java equivalents according to the conversion rules added to Ispirer MnMTK during this PoC.

Results & Advantages

The PoC was successfully completed in 3 months and Ispirer delivered a solution that met customer’s expectations. Customer’s management took the decision to continue moving Oracle PL/SQL code to Java using Ispirer MnMTK that proved its efficiency in automated Oracle to Java application migration.



Learn more about Oracle PL/SQL to Java conversion.

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


Testimonials
December 5, 2017Fantasy Inventions Media Private Limited, India
Microsoft SQL Server to MySQL

"Fantasy Inventions media Pvt Ltd is a startup software and media related company based in INDIA. Among other numerous projects, we are operating an end-to-end...

...

October 18, 2017Sociedade Bíblica do Brasil (SBB), Brazil
Visual Basic to Java Swing

"SBB is brazilian non-profit organization dedicated to spreading the Holy Bible and, through it, promoting the integral development of the human being.

We are...

...

Feedback

The tool is amazing. I like the fact that it import even the triggers of my Firebird database.

Read more
Company News
Industry Events