Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documents

1 Getting Started with OracleAS Integration InterConnect

1.1 What is OracleAS Integration InterConnect?

1.1.1 OracleAS Integration InterConnect Components

1.1.1.1 OracleAS Integration InterConnect Hub

1.1.1.2 OracleAS Integration InterConnect Adapters

1.1.1.3 OracleAS Integration InterConnect Development Kit

1.2 Standard Messaging

1.2.1 Supported Messaging Paradigms

1.3 OracleAS Integration InterConnect Integration Process

1.3.1 Design Time

1.3.3 Separation of Integration Logic and Platform Functionality

1.3.4 Unique Integration Methodology

1.3.4.1 How the Hub-and-Spoke Methodology Works

1.3.5 Integration Lifecycle Management

1.3.6 Using Adapters for Integration

1.4 What's New in This Release?

2 Using iStudio

2.1 Overview of iStudio

2.1.1 iStudio Concepts

2.1.1.1 Applications

2.1.1.2 Common Views and Business Objects

2.1.1.3 Transformations or Mappings

2.1.1.4 Metadata Versioning

2.1.1.5 Tracking Fields

2.1.1.6 Content-Based Routing

2.1.1.7 Cross Reference Tables

2.1.1.8 Domain Value Mapping

2.1.1.9 Routing and the Message Capability Matrix

2.2 Starting iStudio

2.3 Parts of the iStudio Window

2.3.1.1 File Menu

2.3.1.2 Edit Menu

2.3.1.3 Procedure Menu

2.3.1.4 Event Menu

2.3.1.5 Help Menu

2.3.3 Design Navigation List

2.3.4 Deploy Navigation List

2.3.5 Context Menus

2.3.6 Detail View

2.4 Using Workspaces in iStudio

2.4.1 Creating a New Workspace

2.4.2 Opening an Existing Workspace

2.5 Using Projects in iStudio

2.5.1 Creating a New Project

2.5.2 Opening an Existing Project

3 Creating Applications, Common Views, and Business Objects

3.1 Overview of Applications

3.1.1 Application View

3.1.2 Application Data Types

3.1.3 Creating an Application

3.2 Overview of Common Views and Business Objects

3.2.1 Defining Common Views

3.2.1.1 Creating Business Objects

3.2.1.2 Creating Common Data Types

3.2.1.3 Adding Attributes

3.2.1.4 Importing Attributes

3.2.1.5 Deleting and Clearing Attributes

4 Using Events in iStudio

4.1 Overview of Events

4.1.1 Event Maps

4.2 Creating Events

4.3 Publishing and Subscribing to an Event

4.3.1 Publishing an Event

4.3.2 Subscribing to an Event

5 Using Procedures in iStudio

5.1 Using Procedures

5.1.1 Creating a Procedure

5.2 Invoking and Implementing a Procedure

5.2.1 Invoking a Procedure

5.2.2 Implementing a Procedure

6 Enabling Infrastructure

6.1 Enabling Infrastructure

6.2 Working with Content-based Routing

6.3 Working with Domain Value Mappings

6.3.1 Adding Applications to Domain Value Mappings

6.3.2 Removing Applications From Domain Value Mappings

6.3.3 Modifying Domain Value Mappings

6.3.4 Deleting Domain Value Mappings

6.3.5 Deleting Domain Value Mapping Tables

6.3.6 Modifying Attribute Mappings

6.3.7 Removing Attribute Mappings

6.4 Working with Cross-referencing

6.4.1 Adding Applications to Cross-reference Tables

6.4.2 Removing Applications From Cross-reference Tables

6.4.3 Populating Cross-reference Tables

7 Using Oracle Workflow

7.1 Oracle Workflow Overview

7.1.1 Oracle Workflow Solves Common Business Problems

7.1.1.1 Error Management and Compensating Transactions

7.1.1.2 Human Interaction

7.1.1.3 Message Junctions

7.1.1.4 Stateful Routing

7.1.1.5 Composite Services

7.2 OracleAS Integration InterConnect Integration with Oracle Workflow

7.2.1 Design Time Tools

7.3 Using Oracle Workflow with OracleAS Integration InterConnect

7.3.1 Model Business Process

7.3.2 Deploy Business Processes for Runtime

7.4 Model Business Process

7.4.1 Process Bundle

7.4.2 Business Process

7.4.4 Creating a Process Bundle

7.4.5 Creating a Business Process

7.4.6 Populating a Business Process with Activities

7.4.7 Deploying to Oracle Workflow

7.4.8 Launching Oracle Workflow Tools

7.4.8.1 Launching the Oracle Workflow Home Page

7.4.8.2 Launching Oracle Workflow Builder

7.4.9 Modifying Existing Oracle Workflow Processes

8 Deployment

8.1 Deploying PL/SQL Stored Procedures

8.1.1 Manual Deployment

8.1.2 Auto Deployment

8.2 Specifying Application Queue Names for AQ Adapter

8.3 Deploying Workflow Events and Process Definitions

8.4 Sync Adapters from iStudio

9 Runtime System Concepts and Components

9.1 Integration Architecture

9.2.1.1 Agent and Bridge Combination

9.2.2 Repository

9.2.3 Advanced Queues

9.2.4 Oracle Workflow

9.3 Runtime System Features

9.3.1 Messaging Paradigms

9.3.2 Message Delivery

9.3.3 Message Retention

9.3.4 Routing Support

9.3.4.1 Content-Based Routing

9.3.5 Partitioning

9.3.6 High Availability

9.3.7 Backup and Recovery

9.4 Real Application Clusters Configuration

9.4.1 OracleAS Integration InterConnect Adapters Supporting Real Application Clusters

9.4.1.1 Adapter Failover Mechanism

9.4.2 Configuration

9.4.3 Sample Database Adapter adapter.ini File that Shows the Spoke Database Entry

10 Using InterConnect Manager

10.1 Overview of InterConnect Manager

10.2 Starting InterConnect Manager

10.3 Using InterConnect Manager

10.3.1.1 Hub Queue Management

10.3.1.2 Error Message Resubmission

10.3.2 Adapters

10.3.2.1 Configuration File Management

10.3.2.2 Error Management

10.3.3 Repository

10.3.4 Message Tracking

10.4 Using InterConnect Manager in Silent Mode

A Integration Scenario

A.1 Integration Scenario Overview

A.1.1 The New Centralized System

A.1.2 The Legacy System

A.1.3 The Integration Scenario

A.2 Modeling the Integration

A.3 Implementing the Scenario

A.3.1 Review Legacy System Database Trigger

A.3.2 Create a Project

A.3.3 Create the Common View Business Object

A.3.4 Create Business Object Events

A.3.4.1 DTD Code

A.3.5 Create Applications

A.3.6 Create a Cross Reference Table

A.3.7 Create Publish Events

A.3.8 Subscribe to Events

A.3.8.1 DBAPP Application Subscriptions

A.3.8.2 AQAPP Application Subscriptions

A.3.9 Create Content-based Routing

A.3.10 Create an Oracle Workflow Process Bundle

A.3.11 Deploy the Process Bundle to Oracle Workflow

A.3.12 Creating Objects in Oracle Workflow for Modeling

A.3.12.1 Message

A.3.12.2 Lookup Type

A.3.12.3 Notification

A.3.12.4 What Oracle Workflow provides.

A.3.12.5 Copy Lookup Type (Approval)

A.3.12.6 Create an Oracle Workflow Message

A.3.12.7 Create an Oracle Workflow Notification

A.4 Modeling Business Logic in Oracle Workflow

A.5.1 Setting Queues

A.5.2 Sync Adapters

A.5.3 Exporting and Installing Code

B Using the Data Definition Description Language

B.1.1 What Is D3L?

B.1.2 When Is D3L Used?

B.1.3 D3L Features

B.1.3.1 Integrate Transport Properties

B.1.3.2 Allow Multiple Imparrays

B.2 Native Format Message and D3L File Example

B.2.1 Description of Native Format Message Contents in a D3L File

B.2.2 Configuration of Native Format Message with a D3L File

B.2.2.1 adapter.ini Parameter File Setting

B.2.2.2 Message Header Attributes

B.3 D3L File Structure

B.3.1 Supported D3L Data Types

B.3.1.1 Signed or Unsigned Integers

B.3.1.2 Floating Point Numbers

B.3.1.3 Strings

B.3.1.4 Structures

B.3.1.5 Sequences

B.3.1.6 Data Padding

B.3.2 Comma-Separated Values File Parsing with D3L

B.3.2.1 CSVs are Assigned to Named Fields

B.3.2.2 All CSVs are Read into an Array

B.3.2.3 Delimiter Encoding Styles

B.4 D3L Integration with OracleAS Integration InterConnect Adapters

B.4.1 Runtime Initialization

B.4.2 Native Format Message to Common View Incoming Message Translations

B.4.3 Common View to Native Format Message Outgoing Messages Translations

B.5 Installing D3L

B.6 Configuring D3L

B.6.1 Task 1: Configure D3L with iStudio

B.6.2 Task 2: Create a Native Format Message

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

B.6.4 Task 4: Configure a Native Format Message with a D3L File

B.6.5 Task 5: Configure D3L with OracleAS Integration InterConnect Adapters

B.6.6 Task 6: Import a D3L File in iStudio

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

B.7 D3L Use Case

B.7.1 D3L Use Case Overview

B.7.2 Creating Data Type Definitions for Application Views

B.7.2.1 Task 1: Create a DTD File for the Advanced Queuing Adapter

B.7.2.2 Task 2: Create a D3L File for the FTP Adapter

B.7.3 Configuring the aqapp_pub and fileapp_sub Applications in iStudio

B.7.3.1 Task 1: Create a New Workspace and New Project

B.7.3.2 Task 2: Create the Employee Business Object

B.7.3.3 Task 3: Create the newEmployee Event

B.7.3.4 Task 4: Create the aqapp_pub Application

B.7.3.5 Task 5: Enable the aqapp_pub Application to Publish the newEmployee Event

B.7.3.6 Task 6: Define the Application Queue for the aqapp_pub Application

B.7.3.7 Task 7: Create the fileapp_sub Application

B.7.3.8 Task 8: Enable the fileapp_sub Application to Subscribe to the newEmployee Event

B.7.4 Installing the Advanced Queuing and FTP Adapters

B.7.4.1 Task 1: Install the Advanced Queuing Adapter for Application aqapp_pub

B.7.4.2 Task 2: Create the Application Queue AQAPP_NEWEMP

B.7.4.3 Task 3: Install the FTP Adapter for Application fileapp_sub

B.7.4.4 Task 4: Copy the newemp.xml D3L File to the fileapp_sub Adapter Directory

B.7.4.5 Task 5: Set the D3L file and Payload Type in the adapter.ini Adapter Initialization File

B.7.5 Running the D3L Use Case

B.7.5.1 Task 1: Start the Adapters

B.7.5.2 Task 2: Create PL/SQL Code to Trigger the Native newEmployee Event

B.7.5.3 Task 3: Trigger the newEmployee Event

B.7.5.4 Task 4: Verify Receipt of newEmployee Event

B.7.6 Using Other Adapters in D3L and XML Modes

B.7.6.1 Using the HTTP, SMTP, or MQ Series Adapters in D3L Mode

B.7.6.2 Using XML Mode

B.8 Additional D3L Sample Files and DTD

B.8.1 Additional D3L Sample Files

B.8.1.1 Sample File with Structure VehicleRegistration

B.8.1.2 Sample File with Structure Hierarchy PersonRecord

B.8.1.3 Sample File with Structure ProductRecord

C Transformations

C.1 OracleAS Integration InterConnect Transformations

C.1.1 Copy Fields

C.1.2 Copy Object

C.1.3 Concat Fields

C.1.4 Expand Fields

C.1.5 Set Constant

C.1.6 True Conditional Lookup XRef

C.1.7 True Conditional Lookup DVM

C.1.8 Conditional Copy

C.1.9 True Conditional Copy

C.1.10 True Conditional Concat

C.1.11 True Conditional To Number

C.1.12 False Conditional Copy

C.1.13 False Conditional Concat

C.1.14 False Conditional To Number

C.1.15 To Number

C.1.16 Substring

C.1.17 Char Replace

C.1.18 String Replace

C.1.23 Lookup XRef

C.1.24 Delete XRef

C.1.25 Lookup DVM

C.1.26 Truncate

C.1.27 Increment

C.1.28 DatabaseOperation

D Troubleshooting OracleAS Integration InterConnect

D.1 Problems and Solutions

D.1.1 iStudio Fails to Connect

D.1.2 Mappings in iStudio

D.1.3 Metadata Not Editable in iStudio

D.1.4 Subscribing Adapter Does Not Receive Messages From the Hub

D.1.5 Messages Are Not Getting Delivered to a Spoke Application

D.1.6 OracleAS Integration InterConnect Repository Does Not Start

D.1.7 DB Adapter Does Not Pick Up Messages That Have Been Published From the Database

D.1.8 FTP Adapter Cannot Match Incoming Message With Any D3L Definiton

D.1.9 AQ Adapter Does Not Pick Up Mesage From the Spoke AQ

D.1.10 CBR Issue with DB Adapter

D.2 Need More Help?

Glossary

Index