Previous Next JavaScript must be enabled to correctly display this content

## 18.6.2 Before You Begin: REST Enabled SQL Service Requirements

Prior to creating a REST enabled SQL reference, developers must complete these requirements.

Complete the following requirements before creating REST enabled SQL reference:

1. Set up a remote Oracle Database.
2. On the remote Oracle Database, install Oracle REST Data Services (ORDS) 20.x or later.

   Tip:

   This ORDS installation is completely independent from the Oracle REST Data Services used as the Oracle APEX web server

3. Configure and enable the REST Enabled SQL service feature. See Installing and Configuring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.

4. Activate REST Enabled SQL for the target schema on the remote database to be accessed by running `ORDS.ENABLE_SCHEMA`.

   Log in to the database schema to be enabled for REST Enabled SQL and execute the following:

       begin
           ords.enable_schema;
       end;
       /

       commit
       /

The REST Enabled SQL service is then available with a URL in the following format:

`http://host:port/ords/schema`

Where:

- `host` is the name of the system where Oracle REST Data Services is installed.
- `port` is the port number assigned when configuring Oracle REST Data Services. In a default installation, this number is `8080`.
- `ords` is the service name defined when configuring Oracle REST Data Services.
- `schema` is the target schema.

Tip:

When providing the URL for the target schema in APEX, do not append `/_/sql;`.

You will use a URL using the above format when creating the REST Enabled SQL service reference in APEX.

For example, the following is a REST Enabled SQL service for the `scott_obe` schema with ORDS running in standalone mode:

`http://server.example.com:8080/ords/scott_obe`

Parent topic: Managing REST Enabled SQL References