Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
root
Creator II
Creator II

Adding custom information in SAM tables

I have a RESTful service up and running. I have also setup SAM (Service Activity Monitoring" which is writing events to my DB. How can I add additional information to be logged by SAM? Something custom to my service...

How can I alter the events/ events_custominfo tables to allow saving custom information? Any examples will be appreciated to achieve this.

I am using TOS ESB 6.2.1 if that helps.

Thank you.
Labels (3)
5 Replies
root
Creator II
Creator II
Author

I looked at the suggested Threads. I believe both refer to a SOAP message. If I am using a RESTful service, how should I configure the interceptors or handlers? 
Is that supposed to be done in the "ROUTES"? I am new to this architecture and will appreciate some pointers. So far, I have always worked in the Integration perspective.
Any examples or screenshots will be appreciated.
root
Creator II
Creator II
Author

Any help please? Thank you.
Anonymous
Not applicable

Hi,
to insert custom information of RESTful services to SAM DB, we created a new service (this service is invoked via asynchronous messaging from mediation route)  that parses some input parameters from header/exchange and then transform these information into SOAP request that invokes ServiceActivityMonitoring service.By this, you can add as many custom keys (CUST_KEY) into EVENTS_CUSTOMINFO that references specific row from EVENTS table by EVENT_ID.
Or you could create a Bean that would sit somewhere in the flow and storing data into database.
root
Creator II
Creator II
Author

martin.pelikan wrote:
Hi,
to insert custom information of RESTful services to SAM DB, we created a new service (this service is invoked via asynchronous messaging from mediation route)  that parses some input parameters from header/exchange and then transform these information into SOAP request that invokes ServiceActivityMonitoring service.By this, you can add as many custom keys (CUST_KEY) into EVENTS_CUSTOMINFO that references specific row from EVENTS table by EVENT_ID.
Or you could create a Bean that would sit somewhere in the flow and storing data into database.

Hi Martin,
This is exactly what I want to do. Can you share some screenshots/ example code? This will be a good start point.
With reference to the second option, I have honestly never worked with beans directly. Any quick pointer will be appreciated. Thank you.