Integration

Hi, I’m new to SOA interfacing so I apologise for this simple question... I'd be grateful if you coud validate my design as a “Proof of Concept” please, so I don’t set off with any school-boy errors.

Objective: To send updates of Person information from HR to an AQ (to be collected by Tibco) when a new employee is created or an existing employee is updated. (This is an 11i system).

My intention is to use API hooks on the employee creation or update process to call custom code to raise a seeded HR Business Event, so that a workflow subscribed to this BE will execute and enqueue a message onto the BPEL queue and trigger a BPEL process via the Apps adapter.

The BPEL process comprises:
• Database Adapters, which are invoked against each source table (person data, assignment data, etc.) to read the updated data
• Assign nodes, which will copy the data from the database adapters into a single custom XML message containing consolidated employee data from several tables
• An AQ adapter, which will be invoked to enqueue the above custom message to an outgoing AQ queue.

Tibco will subscribe to a business event, registered in the Integration Repository, in order to dequeue these messages.

1) Is this approach a valid one or can you suggest a more elegant way?
2) Tibco needs to subscribe to a Business Event registered in the iRep so that it can dequeue the messages... I do not understand how this should be set up in relation to the AQ but I’m thinking it is a custom Business Event? Am I correct? Any suggested links where I can learn more about this would be very much appreciated.

Thank you
Graham