13.1.2 REST-Enabled SQL Service URL

The format of the URL clients like APEX need to work with your REST-Enabled SQL Service depends on where its running.

For most REST-Enabled SQL services – including those running on-premises or in Autonomous AI Database – use an endpoint URL like the following in APEX. It includes the ORDS schema alias you chose when enabling REST access, and omits the trailing /_/sql suffix that APEX adds automatically:

https://domainname/ords/your_schema_alias

To enable your OCI MySQL Database System for REST-Enabled SQL access, just define a Database Tools Connection for it. When using an Oracle Cloud Infrastructure (OCI) Database Tools Connection for your REST-Enabled SQL service, the service URL includes the Oracle Cloud ID of your connection. This OCID will be a long string like:

ocid1.databasetoolsconnection.oc1.eu-frankfurt-1.xxxxxx

Note the eu-frankfurt-1 OCI region identifier. Your region may be different. The REST-Enabled SQL service URL to use in Oracle APEX looks like this:

https://sql.dbtools.yourregion.oci.oraclecloud.com/20201005/ords/connectionocid