Is it a good idea to log the request and response payloads in database using DataPower.... From waht I know there will be good amount of performance issues wrt DP --> Databases ... no other layer between DP - DB.
Can someone share any URL with this perspective...
2) Is ITCAM for SOA a good option to consider. Would this let us logging the huge payloads ( both request and responses ). I heard we can utilize this tool but never worked or haven't looked this tool doing this job ( though I've seen tivoli for monitoring and alerts )
3) There are other options too like wrpiing the messages into soap and send it to backend -- I'm aware of this option. and some others too ( in this same way little change in the design )
But #1 and #2 are the ones I havn't seen or done any work on them ... so need your inputs on them. Please let me know.
For # 1 --> I see this publication
But again DP directly interacting with DB making me feel nervous of ...do not have much info if the performance related are tied with it ( definitely there are )... please share some URL's and share your thoughts ( on #1 and # 2 ).
This topic has been locked.
2 replies Latest Post - 2012-12-12T14:22:47Z by SystemAdmin
Pinned topic logging request and response payloads in database ?? ITCAM for SOA ??
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-12T14:22:47Z at 2012-12-12T14:22:47Z by SystemAdmin
swlinn 100000E7QE1344 PostsACCEPTED ANSWER
Re: logging request and response payloads in database ?? ITCAM for SOA ??2012-12-12T03:42:27Z in response to SystemAdminHi Salla,
1) Logging to a DB from the appliance is probably not the best use case, especially when you're taking high transaction load. What I've seen more often is doing this type of audit logging using asynchronous MQ requests where a different process can take these messages and insert them into a database under less stressful conditions.
2)ITCAM for SOA doesn't log the content. It logs information about the messages so you can find out metrics such as average response times and message sizes of a particular service and the quantity of specific service requests over a given time interval.
3)this option is similar to the MQ option above, except the soap message is sent to a logging web service.
SystemAdmin 110000D4XK6772 PostsACCEPTED ANSWER
Re: logging request and response payloads in database ?? ITCAM for SOA ??2012-12-12T14:22:47Z in response to swlinnHey Steve,
It's always good to hear from you Sir :).
Thanks so much for your thoughts on this!
Yuppie yup and quite true, I always heard that DP talking to DB esp for this would be a costlier operation. Just wanted to get the opinion from the DP Gurus like ya !!!
Happy holiday and Merry Christmas!!!