Is there a way to automatically report on important B2B Trading Networks events?
Our Business Intelligence (BI) system tracks company transactions end-to-end. So naturally, it wants to know information like:
- B2B order #PO123 received
- B2B invoice #INV456 delivered
- B2B invoice #INV678 delivery failed with reason=<Ariba_PO_Missing>
We have MWS, but there seems to be no programmatic way report this data. Ironically for an integration platform, B2B data seems siloed.
We do not have ‘Optimize for B2B’ or CAF development expertise. (Would either help?)
What we do have is existing IS services to report on inbound and outbound TN transactions over a specified time range (^^). I guess we can run these services with schedulers and create a sort of rough 'n ready eventing system that publishes B2B transaction metadata (order receipt, invoice delivery, and so on) to broker. I’m assuming the events can be delivered to BI using an API.
The alternative to this is the BI system uses an analytics connector to extract information direct from the TN database … this sounds bad (performance impact, undocumented schema )… but could it be workable?
Any thoughts on alternatives? Anyone done this before?
(^^) Our IS services that report on B2B transactions are described in the post below