CipherSoftInc.com
  • Home
    • » Information
      • » White Paper - Migrate Oracle Forms to the Web - Making the Business Case

Migrate Oracle Forms to the Web - Making the Business Case

There are many reasons organizations are currently migrating their Oracle Forms applications to the Web. This white paper will discuss those issues and review the problems that can occur during a conversion project. As well, it will discuss the options for migrating Oracle Forms, including moving to Forms 10g versus migrating to Java.

As Oracle continues to promote their 10g and 11g environments and to migrate their own applications to Java, many organizations are contemplating utilizing the new Web capabilities that are being provided. While past versions of Oracle Forms have enabled companies to access the Web, 10g is providing the most robust environment thus far. Some companies have business reasons to migrate immediately to the Java environment. This may be driven by the requirement to use JDBC connectivity between applications presently in use, or because there is a specific business reason within the company that requires an application to run in Java. As well, companies are trying to determine whether to stay with Oracle Forms as a development environment or whether they should migrate to Java.

We see many companies moving to Java because it seems to be the wave of the future. It is important that organizations understand the business reasons to migrate their applications and determine if the effort and dollars spent will justify the migration costs. While migration to Java can provide many alternatives, it is not always the best solution for every organization. Understanding the risks of migration and the benefits of Java is imperative to ensure an organization is not spending precious IT dollars on an alternative that does not make business sense.

As companies review the differences between migrating to Java and performing development in 10g there are some key components that assist in the decision for the future development environment.

Migration to Forms 10g is beneficial if:

  • The organization has very few Java resources and a retains a skill set in Forms and PL/SQL development
  • The application doesn’t require changes to the look and feel of the application
  • Skill sets in Forms and PL/SQL are readily available to the organization long-term (stability in resource retention)
  • The Forms being used presently are character based versions of Forms (this is due to the learning curve involved in migrating from a client server technology to multi-tiered Java)
  • Java plug-ins (downloads) are acceptable to clients using the application

Migration to Java is beneficial if:

  • Java has been chosen as the future development environment for the organization
  • Application development costs require reduction (Java development provides much lower development costs)
  • The legacy Forms application requires integration with other applications developed in other environments
  • Other applications within the organization are utilizing Java technology
  • Application Servers or IDE are already in use within the organization that require independence
  • The use of open source technology is beneficial to the organization
  • Provision of choices within the client’s environment is required (such as HTML, DHTML, use of browers, etc.)
  • The use of SOA architecture is beneficial to the organization
  • The organization has determined that the use of proprietary technology is no longer beneficial

The Benefits of Java

Java offers clients a robust, interactive environment. It is one of the most powerful Object Oriented Programming languages available and one of the most “open” technologies available. Java conforms both to its own standardized (and published) specifications as well as to other industry standards such as CORBA. JDBC (Java Database Connectivity) provides a standardized interface for relational databases that can interface, providing a greater level of database independence and portability. It also provides platform independence allowing an organization to utilize the most efficient and effective hardware available. Having choices for hardware and database software can be very liberating for an organization, deterring vendors from holding companies hostage to their proprietary environments.

Why is Java Superior?

Java is currently the only technology that provides a fully interactive GUI interface for the Web. The Java architecture was designed with security in mind and not as an afterthought. This provides a simplified and consistent means of protecting IT assets. Java also provides features that allow programming to become easier and more powerful. These include:

Multi-threading capabilities

  • Automatic “garbage collection” (for efficient use of memory)
  • Standardized error trapping and detection
  • Distributed processing capabilities

Oracle's Strategic Direction?

Oracle has been straightforward with their approach as they move towards new technology. Their goals include:

  • Pooling server-side Java virtual machines to reduce the memory footprint of applications that call middle-tier Java
  • Reduced application pre-starting
  • Performance and scalability on the Web
  • Expanding the scope and depth of the Forms management tuning and problem diagnosis facilities within Enterprise Manager
  • Extensible client and middle-tier Java integration (Java Importer and Pluggable Java Component Interface)
  • Development of their own Enterprise applications with technology such as ADF and JDeveloper

Oracle cites research from IDC to make the case that the enterprise market is headed in the J2EE direction: “The mainstream acceptance of J2EE application servers has increased the need for open and interoperable Java Development tools.” IDC Research Director Rikki Kirzner said. “Being able to deploy to a J2EE certified application server as well as being able to use a fully flexible development environment that can be easily customized and extended with third-party tools or in-house utilities helps developers get their products to market in a rapid and cost effective manner.”

The Options for Migration

There are several options available for migration of Oracle Forms or PL/SQL into the new Java environment. Conversions and migrations have been performed over the past 25 years as organizations move from older technology to the newest. Many lessons have been learned through these conversions. With the options available, an organization can determine the methodology that suits their requirements based on the time available before the migrated application is required to be in production. This review should include their financial restraints as well as their internal capabilities. The following outlines options for migrating the applications.

Rewrite the Application

There's a subtle reason that programmers always want to throw away code and start over. The reason is that they think the old code is inefficient. And here is the interesting observation: they are probably wrong. The reason that they think the old code has problems is because of a cardinal, fundamental law of programming: “It's harder to read code than to write it”. This is why code reuse is so difficult. Programmers tend to write their own function because it's easier and more fun than figuring out how the old function works.

In other words, rewriting applications from scratch is the most expensive and time-consuming option. Many organizations believe that rewriting will solve their problems. They choose to rewrite because they need additional functionality, or because they believe it will save them time and money. One of the obstacles with rewriting applications is the enormous amount of testing that has to be performed to ensure business logic is handled properly, users understand the application, and the application is applicable for the business.

Web-enable Forms

This option seems to be simple. Utilize the capabilities of Forms and become Web-enabled. However, as an organization moves towards 10g and 11g, this option becomes less feasible. Some sort of migration effort is required to fully take advantage of the capabilities of Oracle's new technology. There are companies who are just not ready to migrate their development to Java. This may be due to resource restraints or knowledge level, or simply because they prefer to continue to develop their applications in Oracle Forms. In this case, utilizing migration services or tools to migrate to 10g or 11g makes sense. This will provide an organization the benefits of the technology as well as prepare them for a future move to Java.

Manual Conversion

This alternative is by far one of the highest risks. It is not only time consuming, but also shares the negatives that rewriting the application presents. This includes human error issues, lack of resources or skill set and disruptions to the business operations. In addition, escalating costs usually coincide with manual conversions. Many organizations have started their Forms to Java conversions manually only to determine that the time difference between manual and automatic is significant.

Automatic Conversion

Automatic conversion is one of the best alternatives to migrating applications. With an effective migration tool, the conversion can be performed quickly and effectively with tremendous cost savings. Some conversion tools have benchmarked to be 90% faster than manual migration and 80% less expensive. In addition, automatic conversion reduces the risks for the organization. Functionality is maintained and users do not require retraining. There are several options for automatic conversion that enable an organization to move quickly into the new environment. It is important to note, however, that all automatic conversion alternatives are not the same.

There are presently very few tools available in the market with most venders offering a service to perform a Forms to Java conversion. In some cases, these vendors require that the client send their code “offshore” to have the conversion performed. In addition, there are questions that should be asked of the vendor to ensure that the migration is being converted to a true Java or J2EE environment. These include:

  • Is my application being converted to truly compliant J2EE code?
  • Are we able to purchase the tools, or is this a service offering only?
  • Where is my conversion to be performed (on-site or at the client's site)?
  • Are we able to discontinue licensing of Oracle Forms and PL/SQL or do I still have to license these products?
  • Is the vendor available to assist with any issues and training once we migrate to Java?
  • What percentage of conversion is automatic or how much manual work is involved once it is converted?
  • Is the J2EE code “clean”, i.e., is it easily maintainable once I get into the Java environment?
  • Does the converted code integrate with JDeveloper and utilize the ADF and BC4J environment from Oracle?
  • Does the converted code allow you to become IDE and application server independent?

It is important that as a company asks these questions, they actually work with the vendor to provide a “sample” of the converted Java code. An organization should have the option to send in a small sample of an application to see the resulting converted code. This will ensure that the code is easily maintainable and functional as soon as it is migrated. Functionality can be added or changed during an automatic migration, as it can be more closely controlled than with other migration alternatives.

Summary

It is sometimes difficult to determine the best solution for migrating applications to new technology. The conversion of applications should not be a painful exercise, but one that provides efficient alternatives to the organization enabling the most cost efficient option. Making the business decision to determine how to move into new environments is not always easy. Weighing the benefits to the business of becoming Web-enabled against the time and effort required for a migration process is an important part of this decision. Keeping costs and risks to a minimum, as well as causing little business interruption will ensure that the organization continues to benefit from the project.

Benefits of Exodus™

Back to White Papers Main

This White Paper is provided by CipherSoft Inc. and may be used for informational purposes only. By using this material from this site, you acknowledge and agree to abide by the terms and conditions set forth in this notice. If you do not wish to abide by these terms and condition, do not use this site or download materials from it. CipherSoft Inc. is a Private Incorporated company.

Copyright © CipherSoft Inc. 2007 - All rights reserved.