Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Getting Started with Oracle9iAS InterConnect

What is Oracle9iAS InterConnect?

Oracle9iAS InterConnect Components

Standard Messaging

Oracle9iAS InterConnect Integration Process

Design Time

Runtime

Separation of Integration Logic and Platform Functionality

Unique Integration Methodology

Integration Lifecycle Management

Using Adapters for Integration

2 Using iStudio

Overview of iStudio

iStudio Concepts

Starting iStudio

Parts of the iStudio Window

Menu Bar

Toolbar

Design Navigation Tree

Deploy Navigation Tree

Context Menus

Detail View

Using Workspaces in iStudio

Creating a New Workspace

Opening an Existing Workspace

Using Projects in iStudio

Creating a New Project

Opening an Existing Project

3 Creating Applications, Common Views, and Business Objects

Applications: An Overview

Application View

Application Data Types

Creating an Application

Common Views and Business Objects: An Overview

Defining Common Views

4 Using Events in iStudio

Events: An Overview

Event Maps

Creating Events

Publishing and Subscribing to an Event

Publishing an Event

Subscribing to an Event

5 Using Procedures in iStudio

Using Procedures

Creating a Procedure

Invoking and Implementing a Procedure

Invoking a Procedure

Implementing a Procedure

Exporting Stored Procedures

6 Enabling Infrastructure

Enabling Infrastructure

Content-Based Routing

Cross Reference Tables

Domain Value Maps

Working with Content-Based Routing

Modifying Content-Based Routing

Working with Cross Reference Tables

Creating Cross-Reference Tables

Adding Applications to Cross Reference Tables

Removing Applications From Cross Reference Tables

Populating Cross Reference Tables

Working with Domain Value Mappings

Creating a Domain Value Mapping Table

Adding Applications to Domain Value Mappings

Removing Applications From Domain Value Mappings

Modifying Domain Value Mappings

Deleting Domain Value Mappings

Deleting Domain Value Mapping Tables

Modifying Attribute Mappings

Removing Attribute Mappings

Adding Custom Transformations

Deleting Custom Transformations

Adding Mapping Variables

Deleting a Mapping Variable

Cross Reference Table Walk-Through

Domain Value Mappings Walk-Through

7 Using Oracle Workflow

Oracle Workflow Overview

Oracle Workflow Solves Common Business Problems

Oracle9iAS InterConnect Integration with Oracle Workflow

Design Time Tools

Runtime

Using Oracle Workflow to Apply Business Logic

Install Oracle Workflow Components

Design Business Process

Deploy Business Processes for Runtime

Design Business Process

Process Bundle

Business Process

Activity

Creating a Process Bundle

Creating a Business Process

Populating a Business Process with Activities

Deploying to Oracle Workflow

Launching Oracle Workflow Tools

Modifying Existing Oracle Workflow Processes

8 Runtime System Concepts and Compents

Integration Architecture

Features

Messaging Paradigms

Message Delivery

Message Retention

Routing Support

Error Management

Scalability and Load Balancing

Components

Adapters

Repository

Advanced Queues

Oracle Workflow

9 Runtime Management

Introduction to Runtime Management

Starting Oracle Enterprise Manager

Features

Common Features for Adapters and the Repository

Repository Specific Features

Adapter Specific Features

A Integration Scenario

Integration Scenario Overview

The New Centralized System

The Legacy System

The Integration Scenario

Modeling the Integration

Integration Modeling using iStudio

Implementing the Scenario

Review Legacy System Database Trigger

Create a Project

Create the Common View Business Object

Create Business Object Events

Create Applications

Create a Cross Reference Table

Create Publish Events

Subscribing to Events

Create Content Based Routing

Create an Oracle Workflow Process Bundle

Deploy the Process Bundle to Oracle Workflow

Creating Objects in Oracle Workflow for Modeling

Modeling Business Logic in Oracle Workflow

Deployment

Setting Queues

Pushing Metadata

Exporting and Installing Code

Conclusion

B Using the Data Definition Description Language

About D3L

What Is D3L?

When Is D3L Used?

Native Format Message and D3L File Example

Native Format Message Contents Description in a D3L File

Native Format Message Configuration with a D3L File

D3L File Structure

Supported D3L Data Types

D3L Integration with Oracle9iAS InterConnect Technology Adapters

Runtime Initialization

Native Format Message to Common View Incoming Message Translations

Common View to Native Format Message Outgoing Messages Translations

Installing D3L

Configuring D3L

Task 1: Configure D3L with iStudio

Task 2: Create a Native Format Message

Task 3: Create a D3L File Describing the Native Format Message

Task 4: Configure a Native Format Message with a D3L File

Task 5: Configure D3L with Oracle9iAS InterConnect Technology Adapters

Task 6: Import a D3L File in iStudio

Task 7: Define Metadata Properties with Each Event (Optional)

D3L Use Case

D3L Use Case Overview

Creating Data Type Definitions for Application Views

Configuring the aqapp_pub and fileapp_sub Applications in iStudio

Installing the Advanced Queuing and FTP Adapters

Running the D3L Use Case

Using Other Adapters and XML Mode

Additional D3L Sample Files and DTD

Additional D3L Sample Files

D3L DTD

C Transformations

Copy Fields

Copy Object

Concat Fields

Expand Fields

Set Constant

True Conditional Lookup XRef

True Conditional Lookup DVM

Conditional Copy

True Conditional Copy

True Conditional Concat

True Conditional To Number

False Conditional Copy

False Conditional Concat

False Conditional To Number

To Number

Substring

Char Replace

String Replace

LTrim

RTrim

LPad

RPad

Lookup XRef

Delete XRef

Lookup DVM

Truncate

Increment

Glossary

Index