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

Progress 4GL to Oracle PL/SQL Migration

Ispirer MnMTK is the application migration tool, which supports Progress 4GL to Oracle PL/SQL conversion of any complexity.


Progress 4GL to Oracle PL/SQL Migration Overview

We develop our conversion tool using a customer-oriented approach so as we do our best in order to satisfy all your project requirements. Our technical experts have great experience in application migrations and always find innovative solutions even to the most complicated migrations from Progress 4GL to Oracle PL/SQL.


Why Ispirer MnMTK 2015 for Progress 4GL to Oracle PL/SQL Conversion?

The main purpose of Ispirer Systems is to carry out a high-grade and top-of-the-line database migration. We personalize our migration tool Ispirer MnMTK in such a way that a customized version can fully satisfy a client's business requirements.

Our main benefits:

  • High quality and experiences technical support: our technical team has a tremendous experience in migration projects of different levels of complexity.
  • Customer-oriented approach and Fast Customization: we personalize our migration tool in such a way that a customized version can fully satisfy our client’s business needs, custom conversions and optimizations are made within 1-2 business days;
  • Pre-Sales Engagement: we demonstrate a full conversion during the evaluation before you make a decision.
  • Flexible pricing: we can offer you a wide range of options, among which you will definitely find the one which suits you;
  • Optimized Conversion: after the conversion you get an intelligent and maintainable code, without using any Ispirer's middleware.

Read more about Ispirer MnMTK Key Benefits at Why Ispirer.

Live Presentation

Ispirer Migration Solution

Progress 4GL to Oracle PL/SQL

Request

Request a Quote

Ispirer Migration Solution

Progress 4GL to Oracle PL/SQL

Service Toolkit

Conversion Features

Migrates Progress databases to Oracle databases


Migrate Progress databases to Oracle databases

  • Converts Progress tables/view/sequences to Oracle tables/views/sequences

For example,

Progress 4GL:

  1.  
  2. ADD TABLE "TB_DATATYPES"
  3. AREA "Schema Area"
  4. DUMP-NAME "tb_datat"
  5.  
  6. ADD FIELD "c1" OF "TB_DATATYPES" AS CHARACTER
  7. FORMAT "X(8)"
  8. INITIAL ""
  9. POSITION 2
  10. SQL-WIDTH 16
  11. ORDER 10
  12.  
  13. ADD FIELD "c4" OF "TB_DATATYPES" AS INTEGER
  14. FORMAT "->,>>>,>>9"
  15. INITIAL "0"
  16. POSITION 5
  17. SQL-WIDTH 4
  18. ORDER 20
  19.  
  20. ADD FIELD "c5" OF "TB_DATATYPES" AS logical
  21. FORMAT "yes/no"
  22. INITIAL "no"
  23. POSITION 6
  24. SQL-WIDTH 1
  25. ORDER 30
  26.  
  27. .
  28. PSC
  29. cpstream=ISO8859-1
  30. .
  31. 0000000976
  32.  

Oracle PL/SQL:

  1.  
  2. CREATE TABLE TB_DATATYPES
  3. (
  4. c1 CHAR(16),
  5. c4 NUMBER(10,0),
  6. c5 NUMBER(1,0)
  7. );
  8.  
  • Converts Progress 4GL triggers to Oracle triggers/procedures

Progress 4GL:

  1.  
  2. TRIGGER PROCEDURE FOR DELETE OF gsinvhd.
  3. FIND distribution
  4. WHERE distribution.company = gsinvhd.company NO-LOCK NO-ERROR.
  5.  

Oracle PL/SQL:

  1.  
  2. CREATE OR REPLACE TRIGGER SWT_Delete_gsinvhd
  3. AFTER DELETE
  4. ON gsinvhd
  5. DECLARE
  6. v_distribution_company VARCHAR2(255);
  7. BEGIN
  8. SELECT company INTO v_distribution_company FROM distribution
  9. WHERE (distribution.company = gsinvhd.company) AND ROWNUM <=1;
  10. EXCEPTION
  11. WHEN NO_DATA_FOUND THEN
  12. NULL;
  13. END;
  14.  

Converts Progress 4GL code to Oracle PL/SQL code


Convert Progress 4GL code to Oracle PL/SQL code

  • Converts Progress 4GL Procedure Files (*.p) to Oracle procedures

Progress 4GL:

  1.  
  2. PROCEDURE generate-DATA :
  3. DEFINE VARIABLE i AS INTEGER NO-UNDO.
  4. DEFINE VARIABLE gc-company AS CHARACTER NO-UNDO.
  5.  
  6. FIND company WHERE company.company = gc-company NO-LOCK NO-ERROR.
  7.  
  8. find budget WHERE budget.company = gc-company no-LOCK no-error.
  9. Do while avail budget:
  10. Do i = 0 TO 5:
  11. find budget-analysis
  12. WHERE budget-analysis.user-id = company.gc-user-id AND
  13. budget-analysis.company = gc-company AND
  14. budget-analysis.pc-center = "ALL" AND
  15. budget-analysis.acct-period = i
  16. no-error.
  17. END.
  18. END.
  19. END PROCEDURE.
  20.  

Oracle PL/SQL:

  1.  
  2. CREATE OR REPLACE PROCEDURE "generate-data" AS
  3. v_company_company VARCHAR2(255);
  4. v_company_numperiods VARCHAR2(255);
  5. v_company_gcuserid NUMBER(10,0);
  6. v_budget_company VARCHAR2(255);
  7. v_i NUMBER(10,0);
  8. v_gccompany varchar2(4000);
  9. v_if_exists NUMBER(10,0);
  10. v_budgetanalysis_userid NUMBER(10,0);
  11. v_budgetanalysis_company VARCHAR2(255);
  12. v_budgetanalysis_pccenter VARCHAR2(255);
  13. v_budgetanalysis_acctperiod VARCHAR2(255);
  14. BEGIN
  15. BEGIN
  16. SELECT company, "num-periods", "gc-user-id"
  17. INTO v_company_company,v_company_numperiods,v_company_gcuserid
  18. FROM company
  19. WHERE (company.company = v_gccompany) AND ROWNUM <=1;
  20. EXCEPTION
  21. WHEN NO_DATA_FOUND THEN
  22. NULL;
  23. END;
  24. BEGIN
  25. SELECT company INTO v_budget_company FROM budget
  26. WHERE (budget.company = v_gccompany) AND ROWNUM <=1;
  27. EXCEPTION
  28. WHEN NO_DATA_FOUND THEN
  29. NULL;
  30. END;
  31. LOOP
  32. SELECT COUNT(*) INTO v_if_exists FROM budget;
  33. exit WHEN v_if_exists = 0;
  34. BEGIN
  35. v_i := 0;
  36. while v_i <= 5 LOOP
  37. BEGIN
  38. SELECT "user-id", company, "pc-center", "acct-period"
  39. INTO v_budgetanalysis_userid,v_budgetanalysis_company,
  40. v_budgetanalysis_pccenter,v_budgetanalysis_acctperiod
  41. FROM "budget-analysis"
  42. WHERE ("budget-analysis"."user-id" = company."gc-user-id"
  43. AND "budget-analysis".company = v_gccompany
  44. AND "budget-analysis"."pc-center" = 'ALL'
  45. AND "budget-analysis"."acct-period" = v_i)
  46. AND ROWNUM <=1;
  47. EXCEPTION
  48. WHEN NO_DATA_FOUND THEN
  49. NULL;
  50. END;
  51. v_i := v_i+1;
  52. END LOOP;
  53. END;
  54. END LOOP;
  55. END;
  56.  
  • Converts Progress 4GL Include Files (*.i) to Oracle functions
  • Converts Progress ABL reports to Oracle Reports

Assessment Process

The assessment of your migration project could definitely help to weigh up efforts and the approximate cost of your migration. In order to facilitate the process, you're welcome to fill in our:

You can also 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

We had the chance to validate the SQL conversion and it was all fine. Thank you very much and well done!

Read more
Industry Events