Suppose a client has an application that inserts rows into an Oracle database. They want to send this data to a third party for validation as XML but are happy with sending this data once a day. They don’t anticipate that any other app is interested in this new data.
What are some of the issues you can think of regarding using Enterprise server with db notification versus just creating a trigger to insert into a buffer table, and having IS query this database once a day, transform to XML, send to partner and flag the record? I’ve got a fairly good idea on how I would do this with only IS and possibly TN. I’m thinking about guaranteed delivery issues, errors in adapters vs errors in flow services, complexity, scalability, performance, etc.
Assuming the Enterprise server were used, does the broker send the notification to IS for transformation and delivery? Does a component subscribe to the notification events and create the XML? Who bundles up the events for one daily delivery? I would appreciate a typical flow description between all the components.