topic Adding custom information in SAM tables in Talend Studio

Adding custom information in SAM tables

root — Sat, 16 Nov 2024 10:04:55 GMT

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.

Re: Adding custom information in SAM tables

Anonymous — Thu, 16 Feb 2017 06:41:29 GMT

Hi,

Please have a look this thread: https://community.talend.com/t5/Archive/sam-store-headers/td-p/183085 and https://community.talend.com/t5/Design-and-Development/Implementing-a-PasswordHandler-for-Service-Activity-Monitoring/td-p/190648

Regards.
Xilai

Re: Adding custom information in SAM tables

root — Mon, 20 Feb 2017 11:56:38 GMT

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.

Re: Adding custom information in SAM tables

root — Tue, 21 Feb 2017 13:26:34 GMT

Any help please? Thank you.

Re: Adding custom information in SAM tables

Anonymous — Wed, 22 Feb 2017 10:06:33 GMT

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.

Re: Adding custom information in SAM tables

root — Wed, 22 Feb 2017 15:17:49 GMT

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.