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
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
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
Creating and Applying Runtime Security Policies
Configuring Dataspace-Level Security
Specifying Runtime and WSDL Access Service Accounts
Working with XQuery Functions for Security
Creating an XQuery Function for Security
Applying an XQuery Function for Security
Data Redaction Options for Data Elements
Specifying the Data Redaction Behavior
Encryption-Based Data Redaction Examples
Example Data Service Functions
Understanding and Using Service Accounts
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
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
Viewing Data Service Functions Metadata
Data Service Function Lineages
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
Setting Individual Auditing 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
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
Related Reading
Sample Configurable Relational Provider File
Using the Configurable Relational Provider
Summary of Basic Configuration Steps
Deploying the Relational Provider
Configurable Relational Provider Format Description and Reference
Overview of Primary XML Elements
Overview of the <custom-rdb-provider> Element
Configurable Relational Provider Reference
Database Matching
Rules for Database Matching
JDBC Metadata Methods to XQuery Functions Mapping
Additional External XQuery Functions
Specifying SQL Syntax for Functions
Syntax Overview
Setting the infix Attribute
Using a Variable Length Placeholder
Default SQL Syntax for Functions
Translating Built-In XQuery Operators Into SQL
Standard and Oracle Data Service Integrator Namespaces for Functions and Types
Function and Type Name Resolution Process
Abstract SQL Providers
AbstractSQLProvider
AbstractSQL89Provider
AbstractSQL92Provider