Best solution for migration from Oracle Forms 6i to the web?

Question

I work in an Oracle shop. There's a toolset that consists of roughly 1000 Oracle Forms (using the Forms builder from 6i, early 90's software) with Oracle 10g on the back end. It's serving roughly 500 unique people a month, with 200 concurrent connections at any given time during the work day.

Obviously this is something that needs to be addressed to get rid of the Forms runtime and move to a web based solution. The tools need to be accessed from Windows, Linux, various UNIX's, VMS and Solaris.

What options out there exist that would be feasible to migrate to? Not only does it need to be feasible for migration but the development will need to be done by 8 or so engineers who support the tool set (and many of which who would prefer to stay put and not modernize this tool set).

Oracle offers a few solutions that convert Oracle Forms into a crappy Java Applet (it's a very terrible temporary solution).

My solution of choice has been migrating to Ruby on Rails (which I'm a big proponent of Rails) but this will involve a learning curve (which we'll hit with any solution) for other developers. Also, the other difficulty in this is converting some very complex forms to HTML forms.

Has anyone tackled such a solution? Are there any packages offered by anyone outside of Oracle?

Any specific Java Web frameworks?

Would GWT, jQuery UI, ExtJS or any other JavaScript UI frameworks offer the rich user experience needed?

.NET is a consideration but a last resort (mostly because of license costs, there's no room in the budget in addition to what we're paying for Oracle licenses).

Answer 1

That's exactly what I am currently doing using...

Oracle Application Express

The learning curve is much smaller than most web-based alternatives for Forms developers, as all the code is in PL/SQL (unless you start getting fancy with Javascript, which you can). Also, in the latest release of Application Express (3.2), there is a tool to convert Forms applications to Apex.

It comes free with Oracle versions since 9.2.

Answer 2

I'll +1 for Oracle Application Express -- I think that there are some significant advantages in your situation.

1. Free licensing
2. It may bean attractive option to the current staff, if they are Oracle bigots like me.
3. It's 100% web, and in 11g doesn't even require a web tier.

Answer 3

Oracle maintains a list of vendors who all specialize in doing exactly what you need to do.

This is a very common and popular topic due to the large installed base of Oracle Forms. If you do a simple Google search there are lots of accounts of making this transition.

In my personal experience, we had luckily structured our Oracle Forms applications to have nice PL/SQL APIs. It was simple to re-use all the existing PL/SQL in our transition to J2EE, which we did manually. It sounds like you have too many Forms to do that efficiently, though.

Answer 4

Hi i have done a similar work using GWT/springs/ORMS combination, the results are fantastic ,how ever it also depends on the complexity of business process mine was a very very complex business process, what i did was segragate all the layers and treat each layer as a service , in the process i made an application which every one goes wow and at the same time is eligible for many certifications , but if you want to do it more faster and not change the front end u can use exodus cheers

vasem

[email protected]

Answer 5

A really late answer, but relevant. The upcoming V3.2 release of Oracle Application Express adds an Oracle Forms migration tool, which you might find improves your productivity even further.

Answer 6

Our company specializes in Oracle Forms migration to Java. We work with GWT as our front end and a java framework that works on any application server that supports JRE 5. We migrate all the events orchestration and all PL/SQL code. We have a very detailed document explaining our limitations but we have experience with more than 15.000 different forms and reports.

Please visit our web page: www.aspsols.com and send me an email [email protected]. We will be happy to make you a demo of some of your more complex forms.

>

Answer 7

I have found that PITSS.CON, developed by PITSS ( http://www.pitssamerica.com ) is the best out there Oracle Forms Migration. Instead of doing this manually, where you can spend up a few months with a couple hundred forms or a couple years with over a thousand, PITSS.CON, enables one to migrate from any 2.3 to 10g in a matter of days. Its unbelievable what this tool can do.

Answer 8

Hi I work for PITSS (pitssamerica.com), and I want to elaborate on what gwoods1412 stated. You can migrate from any version of Oracle Forms 2.3, 3.0, 4.0, 4.5, 5.0, 6i, or 9i to 10g. The tool also migrates your Oracle Reports, and we have a solution to cure the issue with using the Reports parameter form. Oracel Forms and Reports 10g is a Web Based Solution, so you don't have to bite off the expense of a migration to another platform.

APEX is free to use, but it isn't free to migrate to. And the migration tool only extracts the fields (items), it does not take the Business Logic. So you are not getting your real investment out of your forms, you are getting a query and field description.

If you use a tool like PITSS.con, you will be testing you application on the web in a few days. Your developers will be working on other projects, and all will be right in the world. Oh yeah, you can interoperate with APEX, ADF, Java, .NET, etc once you are in 10g too. That means new development can be done in a new toolset. You start a gradual methodical migration to a new technology. Pretty nice to not have a huge launch party in two years when you can have one this month.

And APEX isn't really an enterprise solution. Here's a quote from David Peake who is Oracle APEX Product Manager:

"One of my key goals is to not over sell APEX conversion capabilities and ensure that attendees understand that converting Forms requires significant investment and is not going to be easy, no matter what tool you are converting to."

I stole that quote from Grant Ronald's (Oracle Fusion Middleware Product Manager ) blog which can viewed at Grant's Blog

Answer 9

Hi

I work with Release3 Inc. (www.release3.com) and I just wanted to ensure you get the appropriate answer for your question.

You can migrate your 6i Forms to "Open Source Java" without much pain.

We've recently introduced "TransForm" a very powerful Forms to Java Migration toolkit.....You may want to check it out.

Here are some of the subtle differences we offer with TransForm:

• Migrates Oracle Forms to "Open Source Java"
• Moves business logic to PL/SQL packages in database.
• Technology: EJB3.0, JSF, Icefaces-AJAX
• Deploy to any Java web application server.

• Can easily handle migrating all complexitites of a Form to Java: Master-Detail, all types of Canvases, LOV, Grid, etc....

• non proprietary, to a solid - standards based Java framework

• You can use PL/SQL skills to migrate the Forms to Java. (Having some basic java skills can be helpful).
• very easy to use, no dependency on external consultants
• It can handle migrating any complexity of oracle forms with great ease.
• We've kept it very cost effective.
• TransForm is template based tool, so its easy to customize for any unique situation (if required).

Its so complete that you could essentially use Forms Builder to continue design/develop new Oracle Forms, and use TransForm to build java applications while using your existing PL/SQL skills.

We know Oracle Forms well, and We've gone through several levels of testing to ensure Forms to Java Migration is an easy transition process with TransForm. We know we've got something that's really fresh approach to migrating Oracle Forms to Java, and something that really works.

Contact me at [email protected], and I can provide you with some sample FREE Oracle Forms to Java Migration licenses (no strings attached) for you to try/evaluate.

Regards,

Rohit Bhalla Release3 Inc.

[email protected]

Answer 10

Hi all, i have o short question : Is there any 'free' migrations tools for Oracle Forms?

AlexC

Answer 11

I know of a Oracle Forms migration to Open Source Java toolkit call 'Transform' and it has worked for several of our clients on basic to complex forms. Check out www.release3.com.

Answer 12

You should check out this site http://www.forms2net.com/ it's Migration Tool of Oracle Forms to .Net. It's pretty good stuff!

Answer 13

You really need to check out the Forms Conversion utility from TurboEnterprise. I do not use Oracle Forms but a friend of mine has used their software to covert Oracle Forms and he loves it. They also have a free version on their website too i think. www.turbo-enterprise.com