Previous Next JavaScript must be enabled to correctly display this content

## 18.6.6 Editing a REST Enabled SQL Service Reference

Edit existing REST Enabled SQL references on the Edit page.

To edit a REST Enabled SQL service:

1. Navigate to the REST Enabled SQL page:
   1. On the Workspace home page, click App Builder.
   2. Click Workspace Utilities.
   3. On the Workspace Utilities page, click REST Enabled SQL Services.

   Tip:

   You can also access the REST Enabled SQL page from Shared Components. On the App Builder home page, select the application and then click Shared Components. Find Workspace Objects and click REST Enabled SQL Databases.

   The REST Enabled SQL page appears listing the Remote Server Name, Base URL, and Authentication.

   Description of the illustration rest_enabled_sql_page.png
2. Click the remote server name.
   The Edit page appears. Edit the attributes.
3. REST Enabled SQL attributes:
   1. Name - Enter a descriptive name for this REST Enabled SQL service.
   2. Endpoint URL - Enter the base URL for this REST Enabled SQL service.
   3. Prompt on Install - Choose whether prompts for this REST Enabled SQL service should display when the application is being imported on another APEX instance.
   4. Authentication Required - Choose whether this REST Enabled SQL aervice requires authentication.
   5. Credential - Select the credential to authenticate against.

      Tip:

      To edit credentials, go to Shared Components, Credentials.

4. Session attributes:
   1. Initialization Code - Enter code to be executed immediately after connecting to the REST Enabled SQL service and before the component SQL is being executed.
   2. Cleanup Code - Enter code to be executed immediately after the component SQL is being executed.
5. Advanced attributes:
   1. Static ID - Use the Static ID to reference the Remote Server in API Calls. Static IDs are also used to identify an existing Remote Server when the application is being exported and imported to another workspace.
   2. Server Time Zone - Time Zone which the REST Enabled SQL service uses to decode DATE and TIMESTAMP values. This value is updated each time you click Save and Test.
6. Click Apply Changes or Save and Test.

See Also:

Managing Web Credentials

Parent topic: Managing REST Enabled SQL References