Create REST Enabled SQL service references on the REST Enabled SQL page.
To create a REST Enabled SQL service reference:
- Navigate to the REST Enabled SQL page:
- On the Workspace home page, click App Builder.
- Select a existing application.
- On the Application home page, click Shared Components in the center of the page.
- Under Data Sources, select REST Enabled SQL.
Tip:
You can also access the REST Enabled SQL page from Workspace Utilities. On the Workspace home page, click Workspace Utilities and then click REST Enabled SQL.
- On the REST Enabled SQL page, click Create.
- On General, specify:
- Name - Enter a descriptive name for this REST Enabled SQL service.
- Endpoint URL - Enter the base URL for this REST Enabled SQL service.
- Click Next.
- For Authentication, specify the appropriate credentials:
- Credentials - Select an existing credential to authenticate against, or select Enter new and complete the remaining steps.
- Credential Name - Enter a descriptive name for the credentials.
- Authentication Type - Specify the Authentication type. Select either Basic Authentication or OAuth2 Client.
- Client ID:
-
For Basic Authentication, enter the database user name. User names for Basic Authentication are converted to upper case. To include a case-sensitive user name, prefix it with the exclamation mark (!
).
-
For OAuth2, enter the client ID. This information will not be encrypted.
- Client Secret - Enter the password, or OAuth2 Client Secret. This information is stored encrypted and cannot be retrieved in clear text.
- Verify Client Secret - Enter the password or client secret again to verify your input. When the two values are not identical, an error message displays.
- Click Create.
The REST Enabled SQL service appears on the REST Enabled SQL page.