18.3.7.4 Specifying a REST Enabled SQL Reference in an Existing Component

Configure existing classic reports, interactive reports, CSS calendars, JET charts, Tree regions, Toggle Column reports, and Reflow Table reports to point to a remote database using a REST Enabled SQL service reference.

Before configuring a component to use a REST Enabled SQL service reference, , you must complete the tasks described in "Before You Begin: REST Enabled SQL Service Requirements" and create the reference as described in "Creating a REST Enabled SQL Service Reference."

To specify a remote database in an existing component:

1. Create the REST Enabled SQL reference.
2. View the page containing the component in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
3. In Page Designer, select the region containing the component (if not already selected) and edit the Source attributes.
4. To specify a remote database for an interactive report, a classic report, or CSS calendar:
   1. In the Rendering tab (left pane), select the region containing the report or calendar.
   2. In the Property Editor (right pane), find the Source group.
   3. Edit the following Source attributes:

      • Location - Select Remote Database.

      • Remote Database - Select the defined REST Enabled SQL Service reference.

      • Type - Select how the data is queried. Select Table/View or SQL Query.

      • Configure the table or provide a SQL Query.

      • Configure the remaining attributes as needed.

      In the following example, the region Report 1 is selected and the Source points to a Remote Database called SCOTT_OBE Example.

      
      Description of the illustration rest_enabled_report_source.png
5. To specify a remote database for chart:
   1. In the Rendering tab (left pane), find and expand the region containing the chart.
   2. Expand Series and select the Series that defines the chart.
   3. In the Property Editor (right pane), find the Source group.
   4. Edit the following Source attributes:

      • Location - Select Remote Database.

      • Remote Database - Select the defined REST Enabled SQL Service reference.

      • Type - Select how the data is queried. Select Table/View or SQL Query.

      • Configure the table or provide a SQL Query.

      • Configure the remaining attributes as needed.

      In the following example, Series 1 is selected and the Source points to a Remote Database called SCOTT_OBE Example.

      
      Description of the illustration rest_enabled_chart_source.png
6. Click Save or Save and Run Page.