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.

View solution in original post

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
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!