Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with OracleAS Integration InterConnect

• What is OracleAS Integration InterConnect?
• OracleAS Integration InterConnect Components
• OracleAS Integration InterConnect Hub
• OracleAS Integration InterConnect Adapters
• OracleAS Integration InterConnect Development Kit
• Standard Messaging
• Supported Messaging Paradigms
• OracleAS Integration InterConnect Integration Process
• Design Time
• Run Time
• Separation of Integration Logic and Platform Functionality
• Unique Integration Methodology
• How the Hub-and-Spoke Model Works
• Integration Lifecycle Management
• Using Adapters for Integration
• What's New in This Release?

2 Using iStudio

• Overview of iStudio
• iStudio Concepts
• Applications
• Common Views and Business Objects
• Transformations or Mappings
• Metadata Versioning
• Tracking Fields
• Content-Based Routing
• Cross Reference Tables
• Domain Value Mapping
• Routing and the Message Capability Matrix
• Starting iStudio
• Parts of the iStudio Window
• Menu Bar
• File Menu
• Edit Menu
• Procedure Menu
• Event Menu
• Help Menu
• Toolbar
• Design Navigation List
• Deploy Navigation List
• 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

• Overview of Applications
• Application View
• Application Data Types
• Creating an Application
• Overview of Common Views and Business Objects
• Defining Common Views
• Creating Business Objects
• Creating Common Data Types
• Adding Attributes
• Importing Attributes
• Deleting and Clearing Attributes

4 Using Events in iStudio

• Overview of Events
• 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

6 Enabling Infrastructure

• Enabling Infrastructure
• Working with Content Based Routing
• Working with Domain Value Mappings
• 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
• Working with Cross Referencing
• Adding Applications to Cross-reference Tables
• Removing Applications from Cross-reference Tables
• Populating Cross-reference Tables

7 Using Oracle Workflow

• Oracle Workflow Overview
• Solving Common Business Problems with Oracle Workflow
• Error Management and Compensating Transactions
• Human Interaction
• Message Junctions
• Stateful Routing
• Composite Services
• OracleAS Integration InterConnect Integration with Oracle Workflow
• Design-Time Tools
• Run Time
• Using Oracle Workflow with OracleAS Integration InterConnect
• Model Business Process
• Deploy Business Processes for Run Time
• Model 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
• Launching the Oracle Workflow Home Page
• Launching Oracle Workflow Builder
• Modifying Existing Oracle Workflow Processes

8 Deployment

• Deploying PL/SQL Stored Procedures
• Manual Deployment
• Auto Deployment
• Specifying Application Queue Names for Advanced Queuing Adapter
• Deploying Workflow Events and Process Definitions
• Sync Adapters from iStudio

9 Run-Time System Concepts and Components

• Integration Architecture
• Components
• Adapters
• Agent and Bridge Combination
• Repository
• Advanced Queues
• Oracle Workflow
• Run-Time System Features
• Messaging Paradigms
• Message Delivery
• Message Retention
• Routing Support
• Content-Based Routing
• Load Balancing
• Partitions
• Instances
• Load Balancing with Multiple Adapters
• High Availability
• Backup and Recovery
• Real Application Clusters Configuration
• OracleAS Integration InterConnect Adapters Supporting Real Application Clusters
• Adapter Failover Mechanism
• Configuration
• Sample Database Adapter adapter.ini File with the Spoke Database Entry

10 XML Schema Definition

• Overview of XSD
• Advantages of XSD over DTD
• XSD Elements and Attributes
• XSD Elements
• XSD Attributes
• Nillable
• XSD Type Definitions
• simpleType
• complexType
• anyType
• anySimpleType
• XSD Content Models
• Choice Group
• Sequence Group
• All group
• XSD Namespace
• Include and Import Schema
• InterConnect Validation
• XSD Type Derivations
• Deriving complexTypes by Extension
• Deriving complexTypes by Restriction
• Unsupported Features and Limitations of XSD
• Unsupported Features
• Limitations of XSD

11 Using Enterprise Manager

• Overview of OracleAS Integration InterConnect Management using Oracle Enterprise Manager 10g Application Server Control Console
• OracleAS Integration InterConnect Management Concepts and Components
• Repository
• Hub Queue
• Adapters
• Oracle Enterprise Manager 10g Application Server Control Console Tasks
• Monitoring and Configuring OracleAS Integration InterConnect from Oracle Enterprise Manager 10g Application Server Control Console
• Accessing OracleAS Integration InterConnect
• Viewing Status and System Metrics
• General Section
• Repository Section
• Adapters Section
• Starting and Stopping OracleAS Integration InterConnect Components
• Starting and Stopping the Repository
• Starting and Stopping the Adapters
• Starting and Stopping the Hub Queue
• Monitoring Adapter Performance
• Configuring OracleAS Integration InterConnect Components
• Configuring the Repository
• Configuring the Adapters
• Configuring the Hub Queue
• Locating and Viewing Log Files

12 Using InterConnect Manager

• Overview of InterConnect Manager
• Starting InterConnect Manager
• Using InterConnect Manager
• Hub
• Hub Queue Management
• Error Message Resubmission
• Adapters
• Configuration File Management
• Error Management
• Repository
• Message Tracking
• Using InterConnect Manager in Silent Mode

A InterConnect Interoperability Feature with Plug-in for BPEL

• Introduction
• Benefits of the BPEL Plug-in
• BPEL Plug-in Concepts
• BPEL Servers and InterConnect Hub Topologies
• Scenario 1: One BPEL Server Interacting with One InterConnect Hub
• Scenario 2: One BPEL Server Interacting with Two InterConnect Hubs
• Scenario 3: Two BPEL Servers Interacting with One InterConnect Hub
• Scenario 4: One BPEL Server in Load-Balancing Mode Interacting with One InterConnect Hub
• Local Cache of Adapter Metadata Concepts
• BPEL Plug-in Interaction Concepts
• Oracle BPEL Process Manager and OracleAS Integration InterConnect Interaction Process
• Outbound Interaction Concepts
• Inbound Interaction Concepts
• Request/Reply Interaction Concept
• Limitations of the BPEL Plug-in Feature
• Configuration
• Use Case
• Pre-Requisites
• Creating a Common View
• Creating a Publishing Event for FTP Application
• Creating a Subscribing Event for BPEL Server Application
• Creating a Publishing Event for BPEL Server Application
• Creating a Subscribing Event for DBAPP application
• Deploying the Stored Procedure Generated for Subscribing Event of DBAPP Application
• Starting Oracle BPEL Server and JDeveloper BPEL Designer
• Creating a Receive Activity to Receive NewCustomer Event
• Designing the Human Workflow System
• Creating a Invoke Activity to send the AddCustomer Event
• Run Time

B Integration Scenario

• Integration Scenario Overview
• The New Centralized System
• The Legacy System
• The Integration Scenario
• Modeling the Integration
• Implementing the Scenario
• Review Legacy System Database Trigger
• Create a Project
• Create the Common View Business Object
• Create Business Object Events
• DTD Code
• Create Applications
• Create a Cross Reference Table
• Create Publish Events
• Subscribe to Events
• DBAPP Application Subscriptions
• AQAPP Application Subscriptions
• Create an Oracle Workflow Process Bundle
• Create Content-based Routing
• Deploy the Process Bundle to Oracle Workflow
• Creating Objects in Oracle Workflow for Modeling
• Message
• Lookup Type
• Notification
• What Oracle Workflow provides.
• Copy Lookup Type (Approval)
• Create an Oracle Workflow Message
• Create an Oracle Workflow Notification
• Modeling Business Logic in Oracle Workflow
• Deployment
• Setting Queues
• Sync Adapters
• Exporting and Installing Code
• Conclusion

C Using the Data Definition Description Language

• About D3L
• What Is D3L?
• When Is D3L Used?
• D3L Features
• Integrate Transport Properties
• Allow Multiple Imparrays
• Native Format Message and D3L File Example
• Description of Native Format Message Contents in a D3L File
• Configuration of Native Format Message with a D3L File
• adapter.ini Parameter File Setting
• Message Header Attributes
• D3L File Structure
• Supported D3L Data Types
• Signed or Unsigned Integers
• Floating Point Numbers
• Strings
• Structures
• Sequences
• Data Padding
• Comma-Separated Values File Parsing with D3L
• CSVs are Assigned to Named Fields
• All CSVs are Read into an Array
• Delimiter Encoding Styles
• D3L Integration with OracleAS Integration InterConnect 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 OracleAS Integration InterConnect 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
• Task 1: Create a DTD File for the Advanced Queuing Adapter
• Task 2: Create a D3L File for the FTP Adapter
• Configuring the aqapp_pub and fileapp_sub Applications in iStudio
• Task 1: Create a New Workspace and New Project
• Task 2: Create the Employee Business Object
• Task 3: Create the newEmployee Event
• Task 4: Create the aqapp_pub Application
• Task 5: Enable the aqapp_pub Application to Publish the newEmployee Event
• Task 6: Define the Application Queue for the aqapp_pub Application
• Task 7: Create the fileapp_sub Application
• Task 8: Enable the fileapp_sub Application to Subscribe to the newEmployee Event
• Installing the Advanced Queuing and FTP Adapters
• Task 1: Install the Advanced Queuing Adapter for Application aqapp_pub
• Task 2: Create the Application Queue AQAPP_NEWEMP
• Task 3: Install the FTP Adapter for Application fileapp_sub
• Task 4: Copy the newemp.xml D3L File to the fileapp_sub Adapter Directory
• Task 5: Set the D3L file and Payload Type in the adapter.ini Adapter Initialization File
• Running the D3L Use Case
• Task 1: Start the Adapters
• Task 2: Create PL/SQL Code to Trigger the Native newEmployee Event
• Task 3: Trigger the newEmployee Event
• Task 4: Verify Receipt of newEmployee Event
• Using Other Adapters in D3L and XML Modes
• Using the HTTP, SMTP, or MQ Series Adapters in D3L Mode
• Using XML Mode
• Additional D3L Sample Files and DTD
• Additional D3L Sample Files
• Sample File with Structure VehicleRegistration
• Sample File with Structure Hierarchy PersonRecord
• Sample File with Structure ProductRecord
• D3L DTD

D Transformations

• OracleAS Integration InterConnect 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
• Lookup
• AddTransformation
• DatabaseOperation

E Troubleshooting OracleAS Integration InterConnect

• Problems and Solutions
• iStudio Fails to Connect
• Mappings in iStudio
• Metadata Not Editable in iStudio
• Subscribing Adapter Does Not Receive Messages From the Hub
• Messages Are Not Getting Delivered to a Spoke Application
• OracleAS Integration InterConnect Repository Does Not Start
• DB Adapter Does Not Pick Up Messages That Have Been Published from the Database
• DB Adapter Does Not Publish Messages
• FTP Adapter Cannot Match Incoming Message with Any D3L Definiton
• AQ Adapter Does Not Pick Up Mesage from the Spoke AQ
• FTP Adapter Does Not Publish or Subscribe to Messages
• HTTP Adapter Does Not Publish or Subscribe to Messages
• CBR Issue with DB Adapter
• Workflow Configuration
• Need More Help?

Glossary

Index