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


Oracle PL/SQL to HPE Vertica


Conversion Features

Ispirer MnMTK has a built-in capability of migrating Oracle packages, procedures and functions to Java classes with generic rules to create scalar functions for HPE Vertica. The tool will create a few separate files for each PL/SQL element.

From one PL/SQL function or procedure two files are created:

  • File with function class that carries out the processing you want your UDF to perform.
  • File with factory class that provides metadata about the function class, and creates an instance of it to handle function calls.

Oracle procedure migration

Source Oracle procedure:

  1.  
  2. CREATE OR REPLACE PROCEDURE types_migration
  3. AS
  4. g NUMBER(10,0);
  5. p NUMBER(4,0);
  6. j NUMBER(11,0);
  7. i NUMBER;
  8. BEGIN
  9. j:=10;
  10. END;
  11.  

Java code with User Defined Scalar Functions (UDSFs):

  1.  
  2. import java.SQL*;
  3. import java.math.*;
  4. import com.vertica.sdk.*;
  5. public class TypesMigrationFactory extends ScalarFunctionFactory
  6. {
  7. @Override
  8. public void getPrototype
  9. (ServerInterface srvInterface, ColumnTypes argTypes,
  10. ColumnTypes returnType)
  11. {
  12. returnType.addInt();
  13. }
  14. @Override
  15. public ScalarFunction createScalarFunction
  16. (ServerInterface srvInterface) {
  17. RETURN NEW TypesMigration();
  18. }
  19. public class TypesMigration extends ScalarFunction {
  20. @Override
  21. public void processBlock
  22. (ServerInterface srvInterface,
  23. BlockReader argReader, BlockWriter resWriter)
  24. throws UdfException, DestroyInvocation {
  25. do {
  26. Long g = NULL;
  27. INTEGER p = NULL;
  28. BigDecimal j = NULL;
  29. DOUBLE i = NULL;
  30. j = NEW BigDecimal(10);
  31. resWriter.setLong(1);
  32. }while(argReader.NEXT());
  33. }
  34. }
  35. }
  36.  

You should compile the TypesMigrationFactory.java into a class file, so that you could include it in your Java UDF JAR library. If you are using an HPE Vertica node as a development system, you can either copy the TypesMigrationFactory.java file to another location on your host, or compile it in place if you have root privileges.

Why Ispirer MnMTK?

Ispirer MnMTK helps to automate the migration process of Oracle PL\SQL to Vertica database. The tool is constantly evolving and can be easily customized for your migration project. With Ispirer MnMTK you eliminate most of the associated risks and considerably reduce internal efforts. All these benefits are available at very reasonable and competitive costs, which makes Ispirer MnMTK even more attractive instrument for this project type.

For more detailed information about our engagement model for application conversion projects, please, go to Application Migration Engagement Model page.



Ispirer and HPE joint Brochure

Read the Ispirer and HPE joint Brochure to see how our partnership brings increased value to customers like you.





You are also welcome to reach us via Contacts page.

 
Testimonials
December 3, 2012Epicor Software Corporation, United States
Progress 4GL to C# .Net Migration

"Epicor has engaged with the Ispirer team to create and refine prototype techniques for migrating certain parts of the Epicor Progress ABL code to well...

...

Case Studies
May 26, 2014COBOL to .NET Conversion, United States

Our client was a major player in market-driven innovation and science. For more than two hundred years, it has been presenting world-class science and engineering to the global marketplace...

...

September 12, 2014Delphi to C# .NET, United States

Our client was a U.S.-based health insurance company providing care services since six decades through its extensive network of hospitals and other institutions.

...

Feedback

The migration went very well and the customer is very happy with the results.

Read more
Industry Events