Oracle APEX enables you to seamlessly shift apps to and from the Oracle Database Cloud Service, private and public clouds, on premise, and even the free public evaluation service.
Deploy on Premises or in the Cloud
Oracle APEX is unique in that it offers flexibility in where it can be deployed. You can deploy Oracle APEX on-premises, on the Oracle Cloud, on a private cloud, or anywhere else Oracle Database runs. Explore some of the most common deployment options and learn how portable Oracle APEX apps are.
All Oracle Database Cloud Services on the Oracle Cloud support Oracle APEX. The Oracle Exadata Express Cloud Service and the Oracle Database Schema Service both provide a fully managed Application Express workspace. Customers don't have to bother with database or APEX administration tasks and can concentrate on developing their business applications. Additionally, the Oracle Database Cloud Service offers a compute shape and gives you the full power of Oracle Database for more demanding use cases.
Oracle Database Exadata Express Cloud Service delivers a managed Oracle Application Express instance on a Oracle Database 12c Release 2 Enterprise Edition, running on Oracle Exadata engineered systems – all at a highly affordable entry-level price. It is a full Oracle Database experience, compatible with what you get on-premises or in other Oracle Database Cloud Services, provisioned within minutes, and suitable for small to medium sized data.
Oracle Database Schema Service is a schema service that provides a multi-tenant cloud environment for using Application Express on Oracle Database. Subscribers get a fully managed Application Express workspace without having to bother about any administration task.
Oracle Database Cloud Service offers compute shapes to provide the full power of Oracle Database in the cloud for any type of application. You can use all standard network connections and have administrative control. The service delivers an easy to use web console user interface and RESTful API to provision and administer Oracle Database on Oracle Compute Cloud Offerings.
On Premises or Private Cloud
Oracle APEX makes it easy to turn a database instance into an Application Development Platform within a private cloud. Each tenant get their own fully isolated workspace in which developers can work independently on their applications.
APEX Workspaces can be provisioned in automated fashion. When enabled, customers just follow a sign-up wizard. After approval, all provisioning is done automatically.
Integrated Resource Management
APEX makes it easy to integrate with database resource management. As soon as the DBA has created Consumer Groups, APEX workspaces can easily assigned to them. Applications or Workspaces can be prioritized based on their importance.
APEX is fully instrumented - administrators can always review activity on workspaces and applications; allowing trends (response times, page views) to be detected and action to be taken if required.
Deploy wherever Oracle Database Runs
Oracle APEX can be deployed anywhere that Oracle Database runs, whether it is running in the Cloud, on-premises, or a third party cloud, or on Linux, Unix or Windows platforms. This means you can develop an Oracle APEX running on Windows on-premises, and deploy it to Oracle APEX running in the Cloud on Linux, or vice versa.
Managing any large scale development effort requires an effective framework to enable multiple developers to work concurrently, and the ability to manage the deployment of multiple versions of the application from Development, through QA/Test, and into Production. Learn how Oracle APEX can be integrated with your existing development practices, how to manage deployments across environments, and how to integrate with version control and continuous integration tools for greater control.
Move Applications between Test / Dev / Prod
Oracle APEX contains utilities and features to run on professional Development - Test / Integration / Production platforms.
Export / Import
Use Export / Import to move your application from Development to Test or from Test to Production. All application details are contained in an export file.
Export Import tasks can be fully automated. APEX provides a command-line utility and a PL/SQL API to perform application exports.Importing can simply be done with SQL*Plus.
Use operating system or CI (e.g. Hudson) jobs to automatically move Applications between platforms. Based on command-line export / import, any scenario can be accomplished.
Integrate with version control
APEX is a development platform on a central instance. Developers are working on the same development platform. Integration with version control thus looks different, but can absolutely done - and is done in practice.
Export and Split Applications
Each application export can be split into individual components. Components are then being checked in to the version control making it easy to detect which component changed when.
Automated Version Control Integration
Use CI/CD (e.g. Hudson) jobs to automatically export applications nightly and to check into version control. Developers will get a detailed version history of their application changes without having to do anything. All is done on the central instance.
Version Control as Application Archive
Once application exports are checked into version control, these can also be used as archive, when developers accidentally deleted or messed up their applications. Recovery is done by simply importing back a clean version.