All Apps and Add-ons

Does Splunk DB Connect 2.4 support queries that rely on storedprocs?

michaelba
Explorer

Documentation is unclear.

Does Splunk DB Connect 2.4 support queries that rely on storedprocs? Given that Splunk DB Connect runs queries with a cursor, does that require any additional boiler plate code in my original query?

We're unable to run a plain old: EXEC myStoredProc. The JDBC driver produces an error: No results parsed. However, we've verified using Sql Management Studio that the same query returns at least 25 records.

0 Karma
1 Solution

mchang_splunk
Splunk Employee
Splunk Employee

We'll have DB Connect 3.0 supporting dbxquery for stored procedures.
It will be released in couple days.

View solution in original post

mchang_splunk
Splunk Employee
Splunk Employee

We'll have DB Connect 3.0 supporting dbxquery for stored procedures.
It will be released in couple days.

michaelba
Explorer

That's excellent news. This is a significant blocker for our operations team. Please feel free to message me, if you'd like to test any private betas.

0 Karma

mchang_splunk
Splunk Employee
Splunk Employee

DB Connect 3.0 is now released 🙂
https://splunkbase.splunk.com/app/2686/

jcoates_splunk
Splunk Employee
Splunk Employee
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...