Go to main content
1/13
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview of Oracle Data Service Integrator Administration
1.1
Administering Oracle Data Service Integrator
1.1.1
Securing Data
1.1.2
Caching Query Results
1.1.3
Viewing Metadata
1.2
Understanding Oracle Data Service Integrator-Enabled WebLogic Server Domains
1.2.1
Understanding the Relationship between Oracle Data Service Integrator and WebLogic Domains
1.2.1.1
Creating a New Domain
1.2.1.2
Provisioning an Existing Domain for Oracle Data Service Integrator
1.2.2
Understanding Console Users
1.2.3
Configuring SSO for Clients
1.3
Introducing the Oracle Data Service Integrator Administration Console
1.3.1
Oracle Data Service Integrator Administration Console Components
1.4
Server Classpath Settings
2
Getting Started with Oracle Data Service Integrator Administration
2.1
Starting and Stopping WebLogic Server
2.1.1
Starting the Server
2.1.2
Stopping the Server
2.2
Launching Oracle Data Service Integrator Administration Console
2.3
Exploring Oracle Data Service Integrator Administration Console
2.3.1
Using the Navigation Pane
2.3.1.1
Change Center and Configuration Locking
2.3.1.2
Pending Changelist
2.3.1.3
Navigation Tree and Category List
2.3.2
Using the Workspace Content Area
3
Deploying Dataspaces
3.1
Introduction
3.2
Creating a New Dataspace
3.3
Deleting a Dataspace
3.4
Deploying Dataspaces on a Target Server
3.4.1
Deploying a Dataspace
3.4.2
Deploying a Web Service Map on a Cluster
3.5
Importing Dataspace Artifacts
3.6
Exporting Dataspace Artifacts
4
Configuring Oracle Data Service Integrator Resources
4.1
Configuring the Cache and Log for a Dataspace
4.2
Using the Physical Sources Category
4.2.1
Viewing Physical Data Source Locations
4.2.2
Modifying Data Source End Points
4.2.3
Substituting SQL Statements
4.2.3.1
How SQL Statement Substitution Works
4.2.3.2
Requirements for SQL Statement Substitution
4.2.3.3
Creating Substitute SQL Query Statements
4.2.3.4
SQL Statement Substitution Example
4.3
Setting the Server Resources
4.4
Item-based Memory Management
4.5
Using Work Managers With Oracle Data Service Integrator
4.5.1
Creating and Configuring Work Managers
4.5.2
Sharing Work Manager Constraints
4.6
Using Administrative Properties
4.7
Monitoring Active Queries and Updates
4.8
Setting the Transaction Isolation Level
4.9
Preloading Oracle Data Service Integrator Projects and Dataspaces
5
Securing Oracle Data Service Integrator Resources
5.1
Introduction to Oracle Data Service Integrator Security
5.2
Understanding Runtime Security Policies
5.2.1
Definition of a Securable Resource
5.2.1.1
Allowing Anonymous Access
5.3
Creating and Applying Runtime Security Policies
5.4
Configuring Dataspace-Level Security
5.4.1
Specifying Runtime and WSDL Access Service Accounts
5.4.1.1
Specifying Service Accounts
5.4.2
Working with XQuery Functions for Security
5.4.2.1
Creating an XQuery Function for Security
5.4.2.2
Applying an XQuery Function for Security
5.4.3
Data Redaction Options for Data Elements
5.4.3.1
Data Redaction Conditions
5.4.3.2
Specifying the Data Redaction Behavior
5.4.3.3
Encryption-Based Data Redaction Examples
5.4.4
Understanding and Using Service Accounts
5.4.4.1
Creating a Service Account
5.4.5
Exporting Access Control Resources
5.5
Configuring Data Service and Operation-Level Security
5.5.1
Creating Data Service Runtime Security Policies
5.5.2
Cascading Element-Level Security to Child Elements
5.5.3
Creating and Configuring Security Policies for Operations
5.5.4
Configuring Data Element-level Security
5.5.4.1
Additional Data Element Security Considerations
5.5.5
Securing Native Web Services
5.5.6
Creating Security Policies for User-Defined Security Resources
5.6
Working with Administrative Access Control Policies
5.6.1
Assigning Entitlements
5.6.1.1
Gaining Administrative Access After a System Lockout
5.6.2
Taking Lock and Edit Capability
6
Viewing Native Web Services
6.1
Viewing Native Web Service Artifacts
6.1.1
Using the General Tab
6.1.1.1
Test the Generated Web Service
6.1.1.2
View the WSDL
6.1.1.3
Export the Static JAR File
6.1.2
Using the Operations Tab
6.1.3
Using the Data Lineage Tab
6.2
Generating a Web Services Mediator Client JAR File
6.3
Generating a Mediator Client JAR File
7
Viewing Metadata Using the Service Explorer
7.1
Introducing Service Explorer
7.2
Using the Service Explorer
7.2.1
Web Browser Requirements for Data Lineage Graph
7.2.2
Analyzing and Viewing Data Services Metadata
7.2.2.1
Data Service Lineages
7.2.2.2
Data Lineage Viewing Options
7.2.3
Viewing Data Service Functions Metadata
7.2.3.1
Data Service Function Lineages
7.2.3.2
Cyclic Dependency
7.2.4
Viewing Web Service Metadata
7.3
Searching Metadata
7.3.1
Search Guidelines
7.3.2
Performing a Basic Metadata Search
7.3.3
Performing an Advanced Metadata Search
7.3.4
Generating Reports
8
Configuring Query Results Cache
8.1
Understanding Results Caching
8.1.1
Caching API
8.2
Setting Up Caching
8.2.1
Step 1: (Optional) Run the SQL Script to Create the Cache Tables
8.2.1.1
Modifying the Cache Table Structure
8.2.2
Step 2: Create the JDBC Data Source for the Cache Database
8.2.3
Step 3: Specify the Cache Data Source and Table
8.2.4
Step 4: Enabling Caching by Function
8.2.4.1
Caching Identity Keys for Security
8.3
Monitoring and Purging Data Cache
8.3.1
Purging Data Cache
8.3.1.1
Purging the Cache for a Dataspace
8.3.1.2
Purging the Cache for a Function
9
Working With Audit and Log Information
9.1
Auditing
9.1.1
Audit Data Structure
9.1.2
Setting Global Audit Properties
9.1.2.1
Auditing Severity Levels
9.1.3
Setting Individual Auditing Properties
9.1.3.1
Admin Audit Properties
9.1.3.2
Common Audit Properties
9.1.3.3
Query Audit Properties
9.1.3.4
Update Audit Properties
9.1.4
Function-level Auditing
9.1.5
Retrieving Audit Information
9.1.5.1
WebLogic Server Security Framework
9.1.5.2
Oracle Data Service Integrator Client API
9.2
Monitoring the Server Log
9.3
Monitoring a WebLogic Domain
9.4
Using Other Monitoring Tools
10
Extending Database Support
10.1
Introduction
10.1.1
General Use Cases
10.1.2
Overview of the Extension Framework Architecture
10.1.3
Relational Providers Included With Oracle Data Service Integrator
10.1.4
Supported Features
10.1.5
Importing Relational Source Metadata
10.1.6
Related Reading
10.2
Sample Configurable Relational Provider File
10.3
Using the Configurable Relational Provider
10.3.1
Summary of Basic Configuration Steps
10.3.2
Deploying the Relational Provider
10.3.2.1
Adding a Provider
10.3.2.2
Removing a Provider
10.4
Configurable Relational Provider Format Description and Reference
10.4.1
Overview of Primary XML Elements
10.4.2
Overview of the <custom-rdb-provider> Element
10.4.3
Configurable Relational Provider Reference
10.5
Database Matching
10.5.1
Rules for Database Matching
10.5.2
JDBC Metadata Methods to XQuery Functions Mapping
10.5.3
Additional External XQuery Functions
10.6
Specifying SQL Syntax for Functions
10.6.1
Syntax Overview
10.6.2
Setting the infix Attribute
10.6.3
Using a Variable Length Placeholder
10.7
Default SQL Syntax for Functions
10.8
Translating Built-In XQuery Operators Into SQL
10.9
Standard and Oracle Data Service Integrator Namespaces for Functions and Types
10.10
Function and Type Name Resolution Process
10.11
Abstract SQL Providers
10.11.1
AbstractSQLProvider
10.11.2
AbstractSQL89Provider
10.11.3
AbstractSQL92Provider
Scripting on this page enhances content navigation, but does not change the content in any way.