38 Presenting Application Data in a Portal

This chapter describes the methods available in WebCenter Portal to present data from an application (also known as application integration) on a portal page.

You can use portal assets to render data on a page in a variety of ways, as described in the following sections:

Permissions

To present data on a portal page, you must be a portal manager or a portal member with the portal-level permissions Basic Services: Edit Page Access and Structure (standard permissions) or Pages: Edit Pages (advanced permissions). You also need the permissions noted in the procedures for the specific tasks you will perform.

For more information about permissions, see About Roles and Permissions for a Portal.

38.1 Presenting Data from a REST or SQL Data Source Using a Business Object

Introduced in WebCenter Portal 12c (12.2.1) is the ability to retrieve data from a REST or SQL data source using a business object, simplifying the complexities of application integration. The retrieved data can be rendered on a portal page in a data visualization using a visualization template. For example, the data can be presented in one of the built-in visualization templates, or a developer can build a custom visualization template in JDeveloper.

The basic steps to accomplish this are:

  1. Create data source. Create a REST or SQL data source from which to retrieve the data to present on the page (see Creating a REST Data Source and Creating a SQL Data Source).

  2. (Optional) Create business object. If you need to filter the attributes and methods retrieved from the data source, create a business object (see Creating a Business Object). If you do not create a unique business object, one is automatically created when a data source is selected in the Define Data Visualization wizard, and all the attributes and methods for the data source are added to the business object. Manually-created business objects are listed on the portal Assets page and in the Define Data Visualization wizard, but automatically-created business objects are internal and not exposed anywhere.

  3. Determine visualization template. Decide if you can use one of the built-in visualization templates (see About the Built-In Visualization Templates), or if you need to work with a developer to create a custom visualization template. When a custom visualization template is uploaded to a portal, it is shown on the Assets page for the portal; it can also be made available as a shared asset, available to all portals.

  4. Configure data visualization. Add a data visualization component (Data Presenter Visualization) to a page, then configure the component to define the data visualization that you want to render on the page (see Configuring a Data Visualization).

38.2 Presenting Data from a Web Service Using a Data Control

Data retrieved from a web service by a data control can be rendered on a portal page in a custom task flow. You can select how to present the data, appropriate to the specific data control. For example, the data can be shown as a table, graph, form, button, or label. You can enable users to control the data displayed by a data control by including a parameter form along with the data presentation. You can also wire data control parameters to task flow parameters so that the data control retrieves data based on the values specified for the task flow parameters. Users can change the value of the task flow parameters in the page editor to request the corresponding data from the data control.

The basic steps to accomplish this are:

  1. Create a data control (see Creating a Web Service Data Control).

  2. Create a custom task flow (see Creating a Task Flow).

  3. Add the custom task flow component to a page, then add the data control you want to render on the page as a table, form, or graph (see Consuming a Data Control in a Task Flow and Controlling the Data Displayed in a Task Flow Using a Data Control).