Typical workflow

• Share
  • Share via Facebook
  • Share via Twitter
  • Share via Linkedin

You can use Oracle Forms Converter to convert legacy Oracle Forms applications to modern web solutions. You can also use Oracle Forms Converter to estimate efforts of the whole Oracle Forms modernization project.

This page describes a typical workflow for converting your Oracle Forms application to a web application and assessing Oracle Forms modernization project.

1. Convert your FMB forms and PLL libraries to XML and PLD files using Oracle Forms Builder 9i or higher.

   

2. Request a trial version of Oracle Forms Converter from the official product web page. The DB Best team will provide you with the download link and your personal license key.

3. Run the OracleFormsConverter.msi file to install Oracle Forms Converter. Follow the instructions of the installation wizard. Please carefully read the License Agreement. If you accept it, specify the destination folder to install the product.

   

4. Install the required drivers to connect to your Oracle Database. Please note that Oracle Forms Converter requires a specific version of the ODAC driver: ODAC112040Xcopy_64bit.
5. Click the application icon to run Oracle Forms Converter.

6. Create a new project.

   

7. Check the “XML files” option to use XML files as input (see step 1).
8. Specify the path to the folder with XML files and to the folder with PLD files. You may use the Sample project to see how Oracle Forms Converter works. Then press the Create button to create a new project.

9. Press Ctrl+P or select the Project Settings option from the menu. Switch to the Connection settings tab.

   

10. Specify the Oracle Database connection credentials for a database which is used by your Oracle Forms application (we will call it a Source DB) in the “Source connection Settings” section. The connection to the Source DB is necessary to analyze and convert Oracle Forms and database objects. This also allows for getting a detailed assessment report, which helps understand the complexity of converted forms and get ballpark estimates of the whole Oracle Forms modernization project.

11. Press the Convert button to start the conversion process.

    

12. After the application completes the conversion, you will see an Assessment report in the center and a target tree on the right side:

    

13. Press the Publish button to deploy the converted application and see it in the web browser.

    

14. Switch to the To Web Site tab:

    

15. Choose the Start form of your application by selecting a form from the drop-down list.

16. Check the Create basic procedures and Fill Stored Procedures options to create stored procedures for Web API and converted forms in your target database:

    

17. Click the Publish button. Oracle Forms Converter displays the “Database Connection Warning” message. Click the Yes button to specify the target database connection:

    

18. Scroll to the Target connection to Oracle DB section and specify Oracle Database connection credentials for your target database. Click the Save button. Your converted application will connect to this target database to read and write data. You may use the same database as a Source DB and Target DB. Your Oracle Forms and a new converted application can work with the same database simultaneously.

    

19. The publishing process can take a few minutes:

    

20. When Oracle Forms Converter completes the publishing process, the converted web application opens in a browser. The application is available at http://localhost:3000.

    

21. To stop the web server and Web API created for the converted web application, use the Stop Server button.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].