13.1.1 Referencing a REST-Enabled SQL Service
Define a REST-Enabled SQL reference to work with the data in a REST-Enabled SQL Service.
A REST-Enabled SQL reference is a workspace-level definition. Once created, you can use it in any application.As shown below, the Create REST Enabled SQL Service wizard in Workspace Utilities lets you assign a meaningful name to the endpoint.
Figure 13-1 Referencing a REST-Enabled SQL Service in Workspace Utilities
As shown below, you can enter new authentication credentials on the second step of the wizard, or choose a credential you might have defined previously. Most REST-Enabled SQL services use basic authentication over HTTPS. This includes ones on-premises and in Autonomous AI Database.
Figure 13-2 Providing Credentials for REST-Enabled SQL Service
When you click (Create) APEX validates the endpoint URL and authentication to confirm everything is working. As shown below, if all is well, you'll see a confirmation to that effect.
Figure 13-3 Confirmation of Successfully Authenticated REST-Enabled SQL Connection
Parent topic: Using Remote Oracle and MySQL Data