Scenario 6. B2B Messaging: Using XML and Oracle Advanced Queueing Messaging for Multi-Application Integration

Problem. Company X needs several applications to communicate and share data in order to integrate the business work flow and processes.

• Solution. XML is used as the message payload. It is transformed via the XSL-T Processor, enveloped and routed accordingly. The XML messages are stored in an 'AQ Broker' Database in LOBs. This solution also utilizes content management i.e., presentation customization using XSL stylesheets. See Figure 2-6.

• Main Tasks Involved.
  1. The user or application places a request. The resulting data is pulled from the corporate database using XSU.

  2. Data is transformed via XSL-T Processor and sent to the AQ Broker

  3. AQ Broker reads this message and determines accordingly, what action is needed. It issues the appropriate response to (or from) from Application 1, 2, and 3, for further processing.

• Oracle XML Used:
  • XML Parser

  • XSL-T Processor

  • XML-SQL Utility (XSU)

Figure 2-6 Scenario 6. Using XML and Oracle Advanced Queueing Messaging for Multi-Application Integration