Administration Guide

Overview of Oracle Data Service Integrator Administration

Administering Oracle Data Service Integrator

Securing Data

Caching Query Results

Viewing Metadata

Understanding Oracle Data Service Integrator-Enabled WebLogic Server Domains

Understanding the Relationship between Oracle Data Service Integrator and WebLogic Domains

Creating a New Domain

Provisioning an Existing Domain for Oracle Data Service Integrator

Understanding Console Users

Introducing the Oracle Data Service Integrator Administration Console

Oracle Data Service Integrator Administration Console Components

Server Classpath Settings

Getting Started with Oracle Data Service Integrator Administration

Starting and Stopping WebLogic Server

Starting the Server

Stopping the Server

Launching Oracle Data Service Integrator Administration Console

Exploring Oracle Data Service Integrator Administration Console

Using the Navigation Pane

Change Center and Configuration Locking

Pending Changelist

Navigation Tree and Category List

Using the Workspace Content Area

Deploying Dataspaces

Introduction

Creating a New Dataspace

Deleting a Dataspace

Deploying Dataspaces on a Target Server

Deploying a Dataspace

Deploying a Web Service Map on a Cluster

Importing Dataspace Artifacts

Exporting Dataspace Artifacts

Configuring Oracle Data Service Integrator Resources

Configuring the Cache and Log for a Dataspace

Using the Physical Sources Category

Viewing Physical Data Source Locations

Modifying Data Source End Points

Substituting SQL Statements

How SQL Statement Substitution Works

Supporting Externalized End Points in Substituted Queries

Requirements for SQL Statement Substitution

Creating Substitute SQL Query Statements

SQL Statement Substitution Example

Setting the Server Resources

Item-based Memory Management

Using Work Managers With Oracle Data Service Integrator

Creating and Configuring Work Managers

Sharing Work Manager Constraints

Using Administrative Properties

Monitoring Active Queries and Updates

Setting the Transaction Isolation Level

Preloading Oracle Data Service Integrator Projects and Dataspaces

Securing Oracle Data Service Integrator Resources

Introduction to Oracle Data Service Integrator Security

Understanding Runtime Security Policies

Definition of a Securable Resource

Allowing Anonymous Access

Creating and Applying Runtime Security Policies

Configuring Dataspace-Level Security

Exporting Access Control Resources

Configuring Data Service and Operation-Level Security

Creating Data Service Runtime Security Policies

Cascading Element-Level Security to Child Elements

Creating and Configuring Security Policies for Operations

Configuring Data Element-level Security

Additional Data Element Security Considerations

Securing Native Web Services

Creating Security Policies for User-Defined Security Resources

Working with Administrative Access Control Policies

Assigning Entitlements

Gaining Administrative Access After a System Lockout

Taking Lock and Edit Capability

Viewing Native Web Services

Viewing Native Web Service Artifacts

Using the General Tab

Test the Generated Web Service

View the WSDL

Export the Static JAR File

Using the Operations Tab

Using the Data Lineage Tab

Generating a Web Services Mediator Client JAR File

Generating a Mediator Client JAR File

Viewing Metadata Using the Service Explorer

Introducing Service Explorer

Using the Service Explorer

Web Browser Requirements for Data Lineage Graph

Analyzing and Viewing Data Services Metadata

Data Service Lineages

Data Lineage Viewing Options

Viewing Data Service Functions Metadata

Data Service Function Lineages

Cyclic Dependency

Viewing Web Service Metadata

Searching Metadata

Search Guidelines

Performing a Basic Metadata Search

Performing an Advanced Metadata Search

Generating Reports

Configuring Query Results Cache

Understanding Results Caching

Caching API

Setting Up Caching

Step 1: (Optional) Run the SQL Script to Create the Cache Tables

Modifying the Cache Table Structure

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

Step 3: Specify the Cache Data Source and Table

Step 4: Enabling Caching by Function

Caching Identity Keys for Security

Monitoring and Purging Data Cache

Purging Data Cache

Purging the Cache for a Dataspace

Purging the Cache for a Function

Working With Audit and Log Information

Auditing

Setting Global Audit Properties

Auditing Severity Levels

Setting Individual Auditing Properties

Admin Audit Properties

Common Audit Properties

Query Audit Properties

Update Audit Properties

Function-level Auditing

Retrieving Audit Information

WebLogic Server Security Framework

Oracle Data Service Integrator Client API

Initializing the RequestConfig Class

Passing the RequestConfig Object

Filtering Audit Data

Retrieving Data Service Audit

Retrieving Audit Properties

Oracle Data Service Integrator Performance Profiling

Creating a Performance Profiler

Using the Sample Performance Profiler

Monitoring the Server Log

Monitoring a WebLogic Domain

Using Other Monitoring Tools

Extending Database Support

Introduction

General Use Cases

Overview of the Extension Framework Architecture

Relational Providers Included With Oracle Data Service Integrator

Supported Features

Importing Relational Source Metadata

Sample Configurable Relational Provider File

Using the Configurable Relational Provider

Summary of Basic Configuration Steps

Deploying the Relational Provider

Adding a Provider

Removing a Provider