10.3.6 Adding a Chart on a New Page Using External Data Sources

Run the Create Page Wizard to add a new chart page using an external data source.

The component(s) described in this topic include built-in support for REST Enabled SQL and REST Data Sources which enables read and write access to remote data sources. In order to build a component on a remote data source, you must first create the application and configure the external data source.

To add a chart on a new page using an external data source:

1. Run the Create Page Wizard:
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Create Page.
      The Create Page Wizard appears.
2. On Create a Page:
   1. Page Type - Select Component.
   2. Click Chart.
3. For Chart Type, select a chart type.
4. For Page and Region Attributes:
   1. Page Number - Enter a page in which the chart object is to appear.
   2. Page Name - Enter a page name.
   3. Page Mode - Select a page mode. Normal presents the page as a normal Application Express application page. Modal Dialog presents the page as an overlay window positioned which remains active and focused until the end user dismisses (closes) it. The underlying page is grayed out and the end user is prevented from interacting with the rest of the page until the dialog is closed.
   4. Breadcrumb - Select whether you want to use a breadcrumb navigation control on your page.
   5. Click Next.
5. For Navigation Preference, specify the type of navigation to include on this page and click Next. The navigation options (for example, navigation menu or tabs) depends upon the current application theme.
6. For Source, select a remote data source:

   • REST Enabled SQL Service - Data is sourced from a remote database, where the connection is defined using REST Enabled SQL. To create or maintain REST Enabled SQL references, navigate to Shared Components, REST Enabled SQL.

   • REST Data Source - Data is sourced from a RESTful web service defined using REST Data Sources. REST Data Source are created and maintained within Shared Components.

7. The steps that follow depend upon the Source Type: Table or SQL Query.

   • If the Source Type is Table:

     1. Source Type - Select Table.

     2. Table/View Owner - Select the owner of the table on which you are building the chart.

     3. Table/View Name - Select the table or view on which the chart is based.

     4. Page Items to Submit - Enter a comma separated list of page items on the current page to be set into session state when the chart data gets read with a separate request.

     5. Maximum Rows - Enter the maximum number of rows you want to use to display the chart.

     6. Click Next.

   • If the Source Type is SQL Query:

     1. Source Type - Select SQL Query.

     2. SQL Query - Enter the SQL SELECT statement to be used for the chart. The SQL SELECT statement must include at least two columns.

     3. Page Items to Submit - Enter a comma separated list of page items on the current page to be set into session state when the chart data gets read with a separate request.

     4. Maximum Rows - Enter the maximum number of rows you want to use to display the chart.

     5. Click Next.

8. For Column Mapping:
   1. Select the columns to be mapped to the chart. The options that display vary depending upon the chart type selected. To learn more about an attribute, click the field-level Help.
   2. Click Next.
9. Click Create.