bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

Administration Guide

Configuring Access to Data Views

Before a BEA Liquid Data for WebLogicTM 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. For instructions on how to create data views, see Creating Data Views from Stored Queries.

Once configured according to the instructions in this topic, 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 topics are included:

- Creating a Data View Data Source Description

- Summary of Configured Data Sources

- Modifying a Data View Data Source Description

- Removing a Data View Data Source Description

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 that tells Liquid Data how to find the data view.

Notes: You must log in with modify access before you can create a data source description. For more information, see Administration Console Security.

There are two ways to create a data view data source description—using the Data View tab on the Liquid Data node, as described in this section, or using the Create Data View link in the server repository, as described in Creating Data Views from Stored Queries.

To create a data source description for a data view:

1. In the left pane, click the Liquid Data node.

2. In the right pane, click the Configuration tab.

3. Click the Data Sources tab.

4. Click the Data Views tab.

5. Click the Configure a new Data View source description text link.

   The configuration tab for creating a new Data View Liquid Data source description is displayed.

   Figure 11-1 Configuring a Liquid Data Source Description for a Data View

6. Fill in the fields as detailed in the following table.

   Table 11-1 Liquid Data Data View Configuration

   Field | Description
   --- | ---
   Name | Logical name of the data view. You can use any meaningful name you want. The query uses this name to reference the data source. Required.
   Query File | Name of a stored query file in the repository, created either in the Data View Builder or a hand-coded query. Enter the query file name or click Browse Repository to select it. Required.
   Schema | Schema for the query. Enter the schema file name or click Browse Repository to select it. Required.

7. Click Create.

   The Administration Console displays the new data view data source description in the summary table.

Note: If security is enabled on your Liquid Data server, you must configure access to this data source description, as described in Configuring Secure Access to Data Source Descriptions. In addition, you can configure access to any data view files in the repository, as described in Configuring Secure Access to Items in the Server Repository.

Summary of Configured Data Sources

The summary table shows a list of configured data sources of a particular type and a subset of configuration information for quick scanning. From the summary list, you can do the following:

- Navigate to the configuration for a particular data source by clicking on it in the table.

- Configure security on a data source by selecting the data source and clicking the Configure ACL link. The Configure ACL link takes you to the Compatibility Security ACL configuration tabs. 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.

Modifying a Data View Data Source Description

You can modify an existing data view data source description.

Note: You must log in with modify access before you can modify a data source description. For more information, see Administration Console Security.

To modify an existing data source description for a data view:

1. In the left pane, click the Liquid Data node.

2. In the right pane, click the Configuration tab.

3. Click the Data Sources tab.

4. Click the Data Views tab.

   A table of configured Liquid Data data sources is shown.

5. Click on the data source you want to modify.

6. Change the settings as needed.

7. Click Apply.

8. Verify the operation of any existing queries that depend on the data source configuration you just changed.

Removing a Data View Data Source Description

You can remove a data source description that you no longer need. Removing a data source description does not remove the actual data view to which it refers. To explicitly remove the data view file from the repository, see Deleting Folders and Files in the Server Repository.

Note: You must log in with modify access before you can remove a data source description. For more information, see Administration Console Security.

To remove a data source description for a data view:

1. In the left pane, click the Liquid Data node.

2. In the right pane, click the Configuration tab.

3. Click the Data Sources tab.

4. Click the Data Views tab.

   A table of configured Liquid Data data views is shown.

5. Find the data view that you want to remove and click the trash can next to it.

6. When prompted, click Yes to confirm removal.

   The Administration Console removes the selected data source description.