topic Re: Does Splunk DB Connect 1.2.0 support stored procedures? in Getting Data In

Does Splunk DB Connect 1.2.0 support stored procedures?

Peckzter — Tue, 11 Aug 2015 14:51:56 GMT

Can anyone confirm whether Splunk DB Connect 1.2.0 supports stored procedures?

Re: Does Splunk DB Connect 1.2.0 support stored procedures?

s2_splunk — Thu, 13 Aug 2015 21:12:27 GMT

Can you clarify what you are asking? In general, stored procedures are invoked via SQL EXEC command, so if your JDBC driver fully supports the full SQL language, I don't see why it shouldn't work.

But please do explain your use case.

Re: Does Splunk DB Connect 1.2.0 support stored procedures?

jensonthottian — Fri, 14 Aug 2015 20:37:06 GMT

Splunk DB Connect currently does not support stored procedures. Have read somewhere that this feature might be available in future releases,

Re: Does Splunk DB Connect 1.2.0 support stored procedures?

joao_amorim — Tue, 29 Sep 2020 10:57:59 GMT

I run two SP's in SQL with DB Con v1 and they work so probably those work too.
Just do EXEC stored_proc_name