Splunk DB Connect: How to track a stored procedural call from Middleware to a database?

[hemendralodhi]

Hi Team,

We have a requirement where Middleware needs to execute a stored procedural call (read only) against DB and that need to be tracked in Splunk. The client doesn't want to log the invocation call data in any log file. How can we achieve this? I was reading about the Splunk DB Connect app which can trigger a stored procedural call, but that may not be applicable here as that will be a different trigger from Splunk itself, but we need to track the data b/w Middleware <-> DB.

Please advise.

Thanks
Hemendra

[woodcock]

You could perhaps use Http Event Collector:
http://dev.splunk.com/view/event-collector/SP-CAAAE6M

[woodcock]

You could also put it in a docker container and use the container-logging.

[hemendralodhi]

Thanks for your response but these are oracle call and going from app to db directly. HTTP(S) is not being used.

[jcoates_splunk · Accepted solution]

"I want to know what happened across multiple systems but I refuse to write a log file"... the only possible answer is network monitoring. Try the Splunk Stream App?

[hemendralodhi]

Hello,

Thanks for your reply. I am trying to do POC on stream app and it is looking good but facing some issue, posted different question for that.