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

Oracle PL/SQL to HP 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 HP 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:

  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;

Java code with User Defined Scalar Functions (UDSFs):

  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. }

You should compile the into a class file, so that you could include it in your Java UDF JAR library. If you are using an HP Vertica node as a development system, you can either copy the 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.

If you are interested in our tool or have any questions to us, you can always contact us.

PgConf.Russia 2017
March 3, 2017 PgConf.Russia 2017

We are happy to announce that Ispirer Systems will take part in the International Conference PGConf.Russia 2017 that will be held on March 15-17, 2017 in Moscow.

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.



I must say that your tool is perfect, I used it only twice, once to test and the second time to do the final work. In less than two minutes I found the exact MSSQL database. If I would find myself again in a similar situation I would not hesitate to consider your other products.

Read more
Industry Events