17.3.5 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. Select a existing application.
   3. On the Application home page, click Shared Components in the center of the page.
   4. Under Data Sources, select REST Enabled SQL.

   Tip:

   You can also access the REST Enabled SQL page from Workspace Utilities. Select the application and then click Workspace Utilities and then click REST Enabled SQL Services.

   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 Application Express 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"