Administration Guide

Overview of Liquid Data Administration

Working with WebLogic Domains

Starting the Server and Running the Administration Console

Configuring Access to Data Sources

Data Source Descriptions

Supported Data Source Types

Managing the Server Repository

Implementing Security

Configuring Query Results Caching

Configuring Custom Functions

Importing and Exporting Server Configurations

Deploying Liquid Data in a Production Environment

Generating Web Services from Stored Queries

Ongoing Liquid Data Management Tasks

Updating License Keys

Creating Liquid Data Domains

Understanding WebLogic Domains and Administration

Understanding the Relationship of Liquid Data to WebLogic Domains

Creating a New Domain

Adding Liquid Data to an Existing Domain

Starting and Stopping the Server

Starting WebLogic Server and the Liquid Data Server

Start the Server in the Appropriate WebLogic Domain

Starting the Server

Stopping the Server

Next Steps

Using the WLS Administration Console

Using the Administration Console to Manage Liquid Data

Starting the Administration Console

Overview of the Administration Console

Finding the Liquid Data Node in the Navigation Tree

Configuring Liquid Data Server Settings

Configuring Server Settings

Server Console Page Field Descriptions

To Configure Liquid Data Server Settings

Modifying Server Settings

Viewing and Accessing All Configured Data Sources

Viewing All Configured Data Sources

Configuring Secure Access to Data Source Descriptions

To Assign Security Policies to a Data Source

Removing Data Source Descriptions

Distributing Data Source Descriptions to Other Liquid Data Servers

Configuring Access to Relational Databases

Connection Pool URLs and Driver Names for JDBC Data Sources

Creating a JDBC Connection Pool

Creating a JDBC Data Source

Creating a Relational Database Data Source Description

Summary of Configured Data Sources

Modifying a Relational Database Source Description

Modifying Data Source Description Settings

Modifying JDBC Connection Pools or JDBC Data Sources

Removing a Relational Database Source Description

Configuring Access to XML Files

Creating an XML File Data Source Description

Summary of Configured Data Sources

Modifying an XML File Data Source Description

Removing an XML File Data Source Description

Configuring Access to Delimited Files

Using Delimited Files in Liquid Data

Creating Delimited Files From an Application

Delimited File Configuration Field Descriptions

Configuring Delimited Files

Configuring Access to Web Services

Creating a Web Service Data Source Description

Summary of Configured Data Sources

Modifying a Web Service Data Source Description

Removing a Web Service Data Source Description

Configuring Access to Application Views

Adding Liquid Data to a WebLogic Platform or WebLogic Integration Domain

Starting the Liquid Data Server in the WebLogic Platform or WebLogic Integration Domain

Defining an Application View Using the WebLogic Integration Application View Console

Configuring an Application View Data Source Description

Creating an Application View Data Source Description

Summary of Configured Data Sources

Modifying an Application View Data Source Description

Removing an Application View Data Source Description

Configuring Access to Data Views

Data View Data Sources Page of the Administration Console

Creating a Data View Data Source Description

Deleting a Data View Data Source Description

Defining Security Policy for a Data View

Deploying Liquid Data Components

Liquid Data Components to Deploy

Navigating to the Deploy Tab

Configuring Access to Custom Functions

About Custom Functions

Use Cases for Custom Functions

Components of Custom Functions

Administration Tasks for Custom Functions

Creating a Custom Function Description

Summary of Configured Custom Function Groups

Configuring Secure Access to Custom Function Descriptions

To Assign Security Policies to a Custom Function Description

Modifying a Custom Function Description

Removing a Custom Function Description

Configuring Access to Complex Parameter Types

Creating a Complex Parameter Type Description

Managing Complex Parameter Types

Modifying a Complex Parameter Type Configuration

Removing a Complex Parameter Type Configuration

Configuring Stored Queries

Stored Queries in Liquid Data

Stored Queries Tab of Liquid Data Administration Console

Available for Liquid Data Control or EJB API

Stored Query Configuration Field Descriptions

Stored Query Configuration Tasks

To Configure (Deploy) a Stored Query

To Create a Data View from a Stored Query

To Create a Web Service from a Stored Query

To Delete a Stored Query Configuration

Importing and Exporting Liquid Data Configurations

About Liquid Data Configurations

What Liquid Data Imports and Exports

What Liquid Data Does Not Import or Export

WebLogic Server Specific Configuration Information

Files Added to the Liquid Data Server Repository

Repository Name

File Swap Configuration

Navigating to the Import/Export Tab

Exporting a Liquid Data Configuration

Importing a Liquid Data Configuration

Managing the Liquid Data Server Repository

About the Liquid Data Server Repository

Contents and Organization of the Server Repository

Server Repository Location

Server Repository File System Hierarchy

Considerations for Evolving the Repository

Navigating to the Repository Tab

Browsing the Server Repository

Working with Folders and Files in the Server Repository

Downloading Files From the Server Repository

Uploading Files to the Server Repository

Creating Sub-Folders

Copying and Pasting Files in the Server Repository

Renaming Folders and Files in the Server Repository

Deleting Folders and Files in the Server Repository

Configuring Secure Access to Items in the Server Repository

To Assign Security Policies to a Repository Item

Configuring the Results Cache for Stored Queries

Security in Liquid Data

Overview of Liquid Data Security

Defining Liquid Data Roles and Groups

Basic Administration Console Access Requirements

Using Liquid Data Pre-Defined Security Roles and Groups

Manually Creating Liquid Data Groups and Roles

Creating Liquid Data Security Resource Groups

Configuring Security Policies on Liquid Data Objects

Query Security

Data Source Security

Repository Directory and File Security

Initializing Liquid Data Security

Making Sure Your Domain Includes Liquid Data

Setting Up Liquid Data Administrator Users

Setting Up Liquid Data Console Users

Defining Liquid Data Security Resource Groups

Nested Levels of Security Resource Groups

Example

To Define a Security Resource Group

Assigning Security Policies to Liquid Data Objects

Security Policy Methods (Access Levels)

Conditions for the Security Policies

Understanding the AND and OR Condition Logic

To Assign a Security Policy to an Object

Integrating Liquid Data Security with Other BEA Software

Web Services and Liquid Data Security

WebLogic Integration

Application Integration and Liquid Data Security

WebLogic Portal and Liquid Data Security

WebLogic Workshop and Liquid Data Security

Monitoring the Server

Monitoring Liquid Data Server Statistics

Monitoring the Server Log

Monitoring a WebLogic Domain

Using Other Monitoring Tools

Checking the Status of Liquid Data Resources

Status Administration Page

Status Values

To Check the Status of a Invalid Resources

What Determines the Status of a Resource

Configuring the Query Results Cache

Understanding Results Caching

Setting up the Results Cache Database

Step 1: Install and Configure the Database Server

Step 2: Run the SQL Script to Create the Cache Database

Step 3: Create the JDBC Data Source for the Cache Database

Enabling the Results Cache

Configuring a Security Policy for Purging the Cache Results

Security Policy Methods

To Configure a Cache Purging Security Policy

Configuring Results Caching for Stored Queries

To Create the Cache Policy

To Edit the Cache Policy

To Remove the Cache Policy

Flushing the Cache

Purging the Cache Programmatically

Generating and Publishing Web Services

Viewing a Demo

About Web Services

Creating a New Web Service from a Stored Query

Modifying a Web Service

Deleting a Generated Web Service

Testing a Generated Web Service

Managing the Deployment of a Generated Web Service

Finding the Target Schema for a Generated Web Service

Invoking Published Web Services