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.