Many organizations struggle with the proliferation of spreadsheets and desktop database applications, such as MS Access. Departments often develop applications independent of their IT organization, without sufficient safe guards in respect to security, backup and recovery, and data integrity. Many of these become mission critical yet the underlying technology is incapable of meeting corporate governance requirements.
Additionally, numerous organizations that developed applications in Oracle Forms are now looking to modernize their legacy applications. Application Express is very adept at converting these applications into modern, Web 2.0 applications that are secure, scalable and reliable.
Spreadsheets A complete Application Express application can be developed in minutes by simply cutting and pasting a spreadsheet into a wizard. Instead of users distributing a spreadsheet, they can send a URL to a Application Express application. This prevents data loss, centralizes data storage, backups, etc. and ensures there is a single source of truth - no manual synchronization of data is necessary because everyone is viewing the most current version of the data in real-time.
MS Access The Oracle Application Express Migration Workshop assists customers in migrating Microsoft Access applications to Oracle Application Express. It works in harmony with the Oracle SQL Developer Migration Workbench to provide a total solution for your Access Migration requirements. You first use SQL Developer Migration Workbench to migrate your schema definition and data and then use the Oracle Application Express Migration Workshop to migrate your Access forms and reports. The last step is refining your new application taking advantage of all the power and capabilities of Oracle Application Express.
Oracle Forms Oracle Application Express provides a forms conversion utility. This enables developers to export Oracle Forms based applications to XML using the standard Forms utility, then import the XML into Oracle Application Express.
Once loaded into a Forms conversion project, a subset of the functionality can be automatically generated as an Oracle Application Express application. For logic that is not automatically converted, Oracle Application Express enables developers to track the manual migration of client-side Forms logic.
See also: Oracle Database Migration Technology