Contents

Title and Copyright Information

Send Us Your Comments

Preface

Objectives of the Oracle Integration Server

Scope

Intended Audience

Structure of the Document

Related Documents

Conventions

Conventions in Text

Conventions in Code Examples

Part I Overview of E-Business and Integration

1 Overview of E-Business Integration

Introduction to E-Business Integration

Mergers and Acquisitions

Packaged Applications

Business Process Re-engineering

Virtual, Dynamic Supply Chains

Customer Relationship Management

Corporate Self-Service

Business-to-Business Commerce

Application Service Providers and Hosting

Reasons for E-Business Integration

Synchronizing Data Between Information Systems

Isolating Applications and Businesses

Streamlining Multistep Business Processes

E-Business Integration Technologies and Approaches

Data Consistency and Synchronization Technologies

Component-Oriented Development Technologies

Message-Oriented Middleware Technologies

2 Methodology and Solutions

Selecting the Appropriate E-Business Integration Methodology

Synchronizing Data Among Systems

Isolating Applications and Businesses from Each Other

Automating Multi-step Business Processes

Application Integration: The Solution Spectrum

Data Integration

Scenario:

Problem:

Solution:

Application Integration

Synchronous Communication with Functional Interfaces

Scenario:

Problem:

Solution:

Asynchronous Communication with Message-Based Interfaces

Scenario:

Problem:

Solution:

Business Process Modeling and Execution

Scenario:

Problem:

Solution:

Business Process Intelligence

Scenario:

Problem:

Solution:

Business-to-Business Integration

3 Overview of Oracle Integration Server

Introduction to OIS

Data Integration

Replication

Application Integration

Business Process Intelligence

Data Transformation

Application Adapters

Functionality:

Deployment:

Adapter SDK:

Business Process Modeling and Execution

Execution Engine:

Systems Management

Oracle Integration Server Design Objectives

Strategic Infrastructure, Not Tactical Point Solution

Choose And Use As You Go

Mission-Critical, Enterprise-Wide Integration

Leveraging Your Investment

Functions of OIS

Key Objectives for OIS

Security

Product Development Life-Cycles

Extensibility

Encapsulation

Component-Based Architectures

New Messaging Technologies

Auditing and Tracking

Business Process Coordination

Business Intelligence

4 Key Integration Concepts

Asynchronous Message-Based Integration

An Example of the Use of Messaging for B2B Integration

Communication Between the Supplier and Exchange

Message and Data Transformation

Business Process Management and Workflow

Exchange Integration Scenario: Supplier Perspective

Exchange Integration Scenario: Exchange Perspective

Messaging Technology and Architecture

Messaging Technology - An Overview

Synchronous and Asynchronous Communication

Session-Based and Sessionless Communication

Stateless ("Without State") and Stateful ("With State") Communication

Two-Way and One-Way Communication

Message-Based Integration Architectures

Point-to-Point Integration

Hub-and-Spoke Integration

Benefits and Trade-offs

Messaging Technology

Message Storage and Management

Message Propagation and Routing

Message Notification Models

Event Notification

Service Requests

Message and Data Transformation Requirements

Datatype Transformation

Semantic Transformation

Message and Data Transformation Issues

Transformation Location

Transformation Mechanism

Transformation Event Frequency

Message System Interoperability

Java Messaging Service (JMS)

The Oracle Implementation of JMS

XML

Part II Products

5 Synchronous Application Integration

Facilities Provided by the Oracle8i Java VM

Core Facilities Provided by Java VM

Core Runtime Facilities Provided by Java VM

Integration Between Java VM and the Database

Developing Java Applications with the Oracle Database

CORBA Facilities in Oracle8i

Enterprise JavaBeans, an Overview

Supporting JABs on the Oracle8i Java VM: an Architectural Overview

Session Management Facilities

Enterprise JavaBeans Services

6 Data Replication and Gateways

Oracle Replication, an Overview

Advantages of Replication

Uses of Replication

Types of Replication

Multimaster Replication

Snapshot Replication

Hybrid Configurations

Data Access Gateways

Oracle Transparent Gateways

Oracle Procedural Gateways

Oracle Procedural Gateway for APPC

Oracle Access Managers

Uses of Oracle Replication and Gateways

Interoperability

7 Oracle Advanced Queuing and JMS

A Brief Review of the Products

Advanced Queuing

Components of Advanced Queueing

Message

Queue

Queue Table

Agent

Recipient

Recipient and Subscription Lists

Rule

Rule-Based Subscriber

Queue Monitor

General Features of Advanced Queueing

SQL Access

Integrated Database Level Operational Support

Structured Payload

Retention and Message History

Tracking and Event Journals

Integrated Transactions

Queue- Level Access Control

Non-Persistent Queues

Publish-Subscribe Support

Two Contexts for Developing Queueing Operations

Oracle Java Messaging Service (OJMS)

Agents

Additional Message Control Properties

Additional Message Type

Transactional Session

Administration

Restrictions

Oracle Procedural Gateway for IBM MQSeries

TIB Adapter for Oracle

Applying the Products in an Integration Solution

Advanced Queuing

Business Event Integration

Data integration

OJMS

Procedural Gateway for MQSeries

Interoperability

MQSeries Example

Business Intelligence and Message Warehousing

Persistent Queues

Volatile Queues

Basic Principles of Message Storage

Business Intelligence Tools

Reports

Discoverer

Express

8 Oracle Message Broker and JMS

Overview

Oracle Message Broker Core

Drivers

Administrative Components and the LDAP Directory

Client Programming Interface

Adapter Developers Toolkit

Uses of OJMS and OMB

AQ API Compatibility

Interoperability with Other Messaging Technologies

MQSeries Example

Workflow Example

Enabling Tools

Programming Languages

Transformation Engines

Message Transformers

9 Directory Services (LDAP)

Java and Directory Service Integration

Directory Services - An Introduction

The Problem

The Solution

Directory Services and LDAP, a Technical Overview

LDAP Information Model

LDAP Naming Model

LDAP Functional Model

Separable Naming Contexts:

Hierarchical Information:

Security Enforcement:

Oracle Internet Directory

10 Workflow

Overview

Key Workflow Components

Oracle Workflow Builder

Workflow Engine

Workflow Definitions Loader

Workflow Monitor

Key Workflow Features

Complete Programmatic Extensibility

Electronic Notifications

Electronic Mail Integration

Internet-Enabled Workflow

Monitoring and Administration

Business Event System

Workflow Monitor

Uses

AQ API

Queue APIs

Developer APIs for the Inbound Queue

Payload Structure

PL/SQL Callout Functionality

Instantiating Business Process Instances Using PL/SQL and Java

Interoperability

Part III Reference

A Mercator Enterprise Broker and OIS

Introduction

System Editor

Type Tree Editor

Database Editor

Mapping Editor

Input Cards

Output Cards

Maps

Enterprise Broker Engine

Uses of Enterprise Broker in the Oracle Integration Server

Hints and Tips

B Front-End and Back-End Integration

Front-End Integration

Advantages

Drawbacks

Back-End Integration

Advantages

Drawbacks

C Autonomous and Pointer Payloads

Pointer Payload

Example 1: Video Film

Example 2: Changes to a Name and Address Database

Autonomous Payload

Example 1: Share Trading

Example 2: Stock Control

Hybrid Payload

Example: Marketing

D Business Events and System Events

Business Events

System Events

Example: Raising an Order

Distinctions between Business and System Events

Example: Emphasizing System Events

Example: Emphasizing Business Events

Index