13.1 Using Remote Oracle and MySQL Data

Oracle REST Data Services' REST-Enabled SQL feature lets authenticated remote applications access data in an Oracle database or Oracle Cloud MySQL database system.

In Oracle APEX, you can reference a REST-Enabled SQL service by providing the endpoint URL and authentication credentials. Then you can use data in the remote database in any APEX region just like a local table. Oracle APEX handles all the details of interacting with the remote database.

• Referencing a REST-Enabled SQL Service
  Define a REST-Enabled SQL reference to work with the data in a REST-Enabled SQL Service.
• 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.
• Using a REST-Enabled SQL Service
  Once you've created a REST-Enabled SQL Service reference at workspace level, you can use it almost anywhere you can configure a data source.