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.
To specify a remote database in an existing component:
- Create the REST Enabled SQL reference.
- View the page containing the component in Page Designer:
- On the Workspace home page, click the App Builder icon.
- Select an application.
- Select a page.
Page Designer appears.
- In Page Designer, select the region containing the component (if not already selected) and edit the Source attributes.
- To specify a remote database for an interactive report, a classic report, or CSS calendar:
- In the Rendering tab (left pane), select the region containing the report or calendar.
- In the Property Editor (right pane), find the Source group.
- 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 GUID-7322A6D7-557B-463A-815C-52ED40147B73-default.png
- To specify a remote database for chart:
- In the Rendering tab (left pane), find and expand the region containing the chart.
- Expand Series and select the Series that defines the chart.
- In the Property Editor (right pane), find the Source group.
- 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 GUID-CF3E0CBA-7766-4581-8BB6-10003D0467D0-default.png
- Click Save or Save and Run Page.