APEX on the Autonomous Database ATP & ADW Cloud Service

-

Yesterday at the KScope19 conference, Oracle announced the immediate availability of APEX, ORDS, and SQL Dev Web on Autonomous Database Cloud!


Chaitanya Koratamaddi dedicated an entire session on presenting the possibilities of APEX on the Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) Cloud Service Oracle offers.

APEX on Autonomous: What is it?

You get a dedicated Application Express 19.1 instance managed by Oracle. Installation, Upgrade and Instance Configuration tasks of APEX on ATP/ADW are completely managed by Oracle, including ORDS.

Why choose for APEX on Autonomous?

The provisioning of new environments is instantly and effortless within minutes. You will get a pre-configured, fully managed and secured environment to both build and deploy APEX applications. You can start developing immediately as soon as your DB service is provisioned. Provisioning is done in three simple steps:
  1. Sign in to Oracle Cloud Infrastructure Console
  2. Create a Compartment
  3. Create  an ATP/ADW instance

ATP/ADW can instantly scale compute and storage online as needed based upon your workload.
Oracle completely manages the configuration, patching, monitoring and upgrading of all APEX components.

APEX apps developed on-premise can easily be deployed to APEX on ATP/ADW or vice-versa.
You have the benefit of elastic resources, automated DB tuning, high availability and security.
It’s possible to create multiple APEX Workspaces using a wizard. It’s possible to use database accounts to access APEX instance administration and development environment. You even can make outbound webservice calls, but the Oracle Wallet/Trust Store is managed by Oracle. New/additional Wallet entries have to be requested through Oracle Support. The RESTful Web Services functionality in APEX is supported. APEX apps can be build with any of the supported authentication schema’s.
APEX on ATP/ADW includes the email capabilities of APEX and configured through the APEX administration API:


Some Restrictions

Using APEX on ATP/ADW knows some restrictions compared to installed on premise or self-managed on cloud infrastructure. Certain configuration options are predefined by Oracle in APEX administration and cannot be altered. Currently, the APEX Builder interface is only available in English. PDF, Excel and Word printing options are not natively supported. Vanity URL’s, basically mapping your own domain(s), are too currently not supported.

Get Started:

oracle.com/autonomousdatabase
apex.oracle.com/autonomous
oracle.com/REST
oracle.com/SQLDeveloper

Comments

Post a Comment

Popular posts from this blog

Remember Me - APEX Autologin

-
Image
I promised to publish about this subject to one of the attendees during my presentation at KScope 12 in San Antonio. I used this functionality in my demo application ( FifApex ) and it seems there is interest in how to do this. Most of the public websites like Facebook, LinkedIn, Twitter, Amazon or OTN do have it: an option to stay logged in, even if you closed the browser, so you do not have to authenticate each time you visit the site again. I’m pretty used to it and would be surprised if a website didn’t offer this convenient feature. OK, it’s not entirely secure, but, as I said, very convenient. I’m working on a “consumer” site/application, I’m building it with APEX and I want to offer this “remember me” option too. I knew an APEX based website that does offer this feature ( www.plsqlchallenge.com ) and I had a chat with the developer that implemented it’s login mechanism, Paul Broughton from Apex Evangelists . So, here my thanks to him for the original inspiration.   Or...
Read more

Dynamic Date Range in APEX Datepicker - no Plugin required

-
Image
The build in jQuery UI Datepicker of Application Express is a very versatile component and it is very easy to configure the basic settings with the Page Item properties. One of the properties you can set, is the range of selectable dates by entering a Minimum and Maximum Date value. The “syntax” of these values is based on the jQuery UI Datepicker components date format capabilities, so this might be looking a bit awkward to us Oracle folks at first sight. Next to giving a static value or one of these Datepicker calculations you can reference an APEX Page Item to set the range values, which is a nice thing as we are able to calculate a range dynamically, based on some database value/calculations. The bummer is: the calculation only gets executed during the rendering phase of the page and changing the referencing Page Item’s value won’t change the Datepicker range. What you really want (yes, you do), is to be able to reference Page Items to control the Minimum and Maximum Date dynamica...
Read more

Tabular Forms on Complex Views - using INSTEAD OF Triggers

-
Image
Creating tabular forms in Apex is relative straight forward. One gets fully generated, instant insert/update/delete functionality. Unfortunately (for the form developer), tables are usually part of a more or less complex data model, which is optimized for data storage, rather then for form-layout. Well, Apex offers some possibilities to the developer to enable tabular forms beyond 1:1 table based. Collections One alternative is to create your tabular form using the Apex Collection API. There is a good article on Martin Giffy D'Souza’s blog describing this technique. This collection-approach basically pre-fetches data into a (PL/SQL) collection from a query/cursor. The “collected” data will be displayed in the form. An on-submit page process will store the data submitted from the form into the collection. After this you can perform some validation before submitting the data to table(s) in an on-submit page process. Database Views Well, I favor an approach that keeps the...
Read more