bea.com | products | dev2dev | support | askBEA
 Download Docs   Site Map   Glossary 
Search
e-docs > Liquid Data for WebLogic > Administration Guide > Configuring Access to Data Views

Administration Guide

 Previous Next Contents Index View as PDF  

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

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.

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

    Table 11-1 Liquid Data Data View Configuration  

    Field

    Description

    Required?

    Name

    Logical name of the data view. You can use any meaningful name you want. The only limitation is that the name start with an alphabetic character (a-z or A-Z). The query uses this name to reference the data source.

    Yes.

    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.

    Yes.

    Schema

    Schema for the query. Enter the schema file name or click Browse Repository to select it.

    Yes.

    Namespace URI

    Identifies the target namespace of the schema file. Example:

    urn:schemas-bea-com:ld-cptSample

    Optional but recommended. If used, Schema Root Element Name must also be supplied.

    Schema Root Element Name

    dentifies a unique root element in the schema file. Many schemas have only a single root. In cases where there are multiple root elements, only elements under the identified root will available through the data view.

    For example, the sample schema CustomerOrderReport described in the Liquid Data Getting Started document has only a single root, CustomerOrder.

    Optional but recommended. If used, Namespace URI must also be supplied.


     

  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:

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.

 

Back to Top Previous Next