DB Best has successfully completed several Oracle Forms modernization projects. These updates bring our customers the joy of running their Oracle Forms in a regular web browser. And so can you! With our unique Oracle Forms Converter, you can modernize your outdated solutions with a brand-new web architecture.
Convert. Test. Deploy.
Get off legacy Oracle Forms using our proven automated conversion technology. Arrive to the Web 2.0 architecture and to the cloud in a matter of weeks.
Automate your Oracle Forms conversion to HTML5!
Moreover, our Oracle Forms Converter extracts the SQL code from your Oracle Forms. It then adds this code to your database in the shape of the stored procedures or functions allowing you to call these procedures via .NET Web API.
Brands that rely on Oracle Forms Converter
Discover the list of the Oracle Forms Converter features and benefits.
Run Assessment Report to analyze the complexity of your Oracle Forms code and get a detailed report on the conversion automation issues.
Here you can estimate the complexity of the source Oracle Forms simply by analyzing the statistics report. Also, you can examine the assessment report to understand what it would take to address the conversion action items manually.
Our platform includes a unique Test Recorder tool which provides you with a repeatable script after you manually run the test.
In addition, you can rely on our in-house Migration Platform to perform thorough testing of your new application. Using these test scripts during further development of your project will be a big plus too.
The Oracle Forms Converter can automatically convert up to 100% of your Oracle Forms to web-based single page applications.
If this sounds like a magic wand, it is. You can now get high-quality results with no extra manual effort. While you will still have a long way before deployment of your new converted system, the code conversion process is fully automated.
CI/CD Solution out of the box
Take advantage of our established CI/CD solution for all components of the system as it is all part of the product.
You can deploy all system components (converter, middle-tier, database script, test automation) in one click with our established CI/CD solution. This allows for a significant decrease in the Oracle Forms migration project timeframe.
How does it work
Find the typical workflow of the Oracle Forms Converter below:
Export to XML
First, you need to connect to your existing Oracle Forms and export them into XML format. Currently, we use an Oracle utility to convert FMB forms to XML. However, we plan to integrate this feature into the Oracle Forms Converter application.
Then use Oracle Forms Converter to collect the statistics of your Oracle Forms.
Based on these statistics, our Oracle Forms Converter analyzes the complexity of your XML forms. As a result, your source forms are distributed into 5 following categories:
- 1 — Easy
- 2 — Medium
- 3 — Complex
- 4 — Very Complex
- 5 — Extremely Complex
This helps estimate your Oracle Forms modernization project.
After that you can get an assessment report for your migration project.
Oracle Forms Converter discovers the conversion action items and shows them in a table. The report is pretty much the same as shown on the previous image. However, it includes new columns related to these action items. Depending on the manual effort required to address the action items, they are grouped into 3 categories:
- Simple action
- Medium action
- Significant action
You can explore the action items in the relevant tab.
As a part of this process, our fully automated tool extracts embedded SQL code from the forms and loads it into the database in the shape of stored procedures. Also, Oracle Forms Converter utilizes the package manager for Node.js packages. This improves the visual and logical aspects of your app.
At the end of the day, Oracle Forms Converter transforms FMB forms and PLL files to XML and provides JS code for each of the forms and libraries. The converted code looks as follows.
Now you need to deploy the middle tier. Then all is ready to publish the converted forms and integrate their components.
On the next step you may want to use our in-house Migration Platform to test how the converted applications run in the web.
We have established a proven CI/CD process to connect all the pieces into the automated script. This allows for deployment of all system components automatically with minimal downtime.
Now you can run your new forms on the web. Find the screenshot below that demonstrates how the source Oracle Forms and the converted web applications run side by side. The source Oracle Form is on the left side while the converted application is on the right side.
You can see that the forms look almost the same! What’s even more important, the converted code looks almost identical to the source code. So, you can quickly debug this new, clean, and clear code of converted applications. Read our blog post and watch the related video to see how this magnificent converter works.
Migrating Oracle Forms to APEX requires a redesign of embedded business logic
Oracle suggests their customers upgrade legacy Oracle Forms to Oracle APEX. However, this proves to be a complex and problematic path.
Oracle Application Express (APEX) is a low-code development platform. Oracle designed this platform to compete against web-based solutions like Quick Base. Therefore, Oracle APEX platform does not include business logic familiar to database solutions like Oracle Forms and Reports, Microsoft Access or Visual Basic.
Oracle APEX platform is fundamentally different from Oracle Forms. The two products have completely different architecture and principles. Differences include things such as: Oracle APEX does not support Oracle Forms built-ins, triggers, list of values, system variables, visual attributes, FRM errors, etc.
Also, Oracle Application Express Limits do not support many of the capabilities of Oracle Forms.
Finally, Oracle does not provide any guidance on how you can support APEX as a part of your DevOps practice.
Because of these differences, using the upgrade path from Oracle Forms to Oracle APEX is a bad idea. Even after completing the migration, you may need to rethink and rewrite major parts of your application code.
In addition to keeping the existing functionality, here are some other benefits of using Oracle Forms Converter:
- Simple scalability of the converted solution
- Scripts for automated testing — which our customers can leverage for further development activities
- A feasible way to replace your database platform
- The ability to deploy the converted system to the cloud with minor changes
The Oracle Forms Converter supports the following versions of Oracle Forms and Oracle Database. In addition to that, the Oracle Forms Converter requires the following software to be installed on your computer.
Supported Oracle Forms versions
- Oracle Forms 10g; Oracle Forms 11g; Oracle Forms 12c
Supported Oracle Database versions
- Oracle Database 6; Oracle Database 6i; Oracle Database 10g; Oracle Database 11g; Oracle Database 12c
- Microsoft Windows 10; Microsoft Windows 8.1; Microsoft Windows 8; Microsoft Windows 7
- Microsoft Windows Server 2012 R2; Microsoft Windows Server 2012; Microsoft Windows Server 2008 R2
- .NET Framework 4.0 or higher
At the PASS Summit 2019, DB Best introduced a completely reworked Oracle Forms Converter, which is designed to automate conversion from legacy Oracle Forms to a modern Web 2.0 architec...
A lot of our customers are stuck with legacy Oracle Forms. Looking for better performance, our customers want to get off their outdated solutions and run their modernized forms in any ...
At DB Best, we've helped several customers move away from Oracle Forms to a modern web-based solution. To accomplish this, developed a totally new Oracle Forms Converter. This tool a...
DB Best has successfully completed several Oracle Forms modernization projects, making our customers happy with the new web architecture of their solutions. However, the first question...