Contents for 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