Administration Guide

Configuring Access to Data Views

Before a BEA Liquid Data for WebLogic query can access data in a data view, the data view must be configured as a Liquid Data data source. Data views are derived from stored queries. Only one data view can be created from a stored query. You can also deploy data views directly from the Data View Builder. For instructions on how to create data views, see Building Queries and Data Views and To Create a Data View from a Stored Query.

Once configured, data views with data source descriptions will show up as data sources available for use in any EJB client, such as the Data View Builder, that connects to this server. For more information, see Using Data Views as Data Sources in Building Queries and Data Views.

The following sections are included:

Data View Data Sources Page of the Administration Console

The Data View tab of the Liquid Data Administration Console displays a list of data views configured in Liquid Data. You configure the data views from the Stored Queries tab of the Liquid Data Administration Console.

Figure 12-1 Data Views Tab of the Liquid Data Administration Console

Data Views Tab of the Liquid Data Administration Console

From the Data View tab, you can perform the following:

If you want to set a security policy for the data source (and security in enabled for your Liquid Data domain), click Define Security Policy or Edit Security Policy on the data source to which you want to assign security. If the object already has a policy defined, the link is labeled "Edit Security Policy"; if the object has no defined policy, the link is labeled "Define Security Policy." For more information, see Configuring Secure Access to Data Source Descriptions.
Remove an existing data source by clicking the trash can next to it.

Note: You can also view all data sources from the All Data Sources configuration tab on the Liquid Data node in the Administration Console, as described in Viewing and Accessing All Configured Data Sources.

Creating a Data View Data Source Description

To access a data view as a data source from Liquid Data, you must first create a data source description. The data source description provides Liquid Data with the necessary information to access the query defined in the data view and use it as a data source for other queries.

Note: You can create and deploy a Data View directly from the Data View Builder instead of going to the Administration Console. For details, see Building Queries and Data Views.

You create new data view data sources from the stored query tab of the Liquid Data Administration Console. To create a data view data source description, see To Create a Data View from a Stored Query.

Deleting a Data View Data Source Description

You can delete a data source description that you no longer need. Deleting a data source description does not remove the stored query to which it refers; it removes only the data view description from the repository.

Note: You must have access to the console and modify security permissions on the data view to delete the data view data source description. For more information, see Defining Liquid Data Roles and Groups.

To remove a data source description for a data view:

Start the Administration Console (for details, see Starting the Administration Console).

In the left pane of the Administration Console, expand the node for your domain and click the Liquid Data node.

In the right pane, click the Data Sources tab.

Click the Data Views tab.

A table of configured Liquid Data data views is shown (see Figure 12-1).

Find the data view that you want to remove and click the trash can in the Action column (the last column in the table).

When prompted, click Yes to confirm removal.

The Administration Console removes the selected data source description and deletes the file from the Liquid Data repository.

Defining Security Policy for a Data View

You can define a security policy for each data source from the Data Views tab of the Liquid Data Administration Console.

Perform the following steps to define a security policy on a Liquid Data data view data source.

Start the Administration Console (for details, see Starting the Administration Console).

In the left pane of the Administration Console, expand the node for your domain and click the Liquid Data node.

Navigate to the Liquid Data —> Data Sources —> Data Views tab of the Liquid Data Administration Console.

Click Define Security Policy or Edit Security Policy on the data view to which you want to assign security. If the data view already has a policy defined, the link is labeled "Edit Security Policy"; if it no defined policy, the link is labeled "Define Security Policy."

Assign a security policy to the data view, as described in Assigning Security Policies to Liquid Data Objects.

Click Apply on the security policy screen.