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.
- The user or application places a request. The resulting data is pulled from the corporate database using XSU.
- Data is transformed via XSL-T Processor and sent to the AQ Broker
- 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