All Apps and Add-ons

DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?)

michaelba
Explorer

Splunk/DBConnect,

DBConnect 3.0 is unable to run our storedprocedure that is saved in the MS-SQLServer instance. Using SQL Management Studio, we've confirmed this storedprocedure returns 25 records.

  1. What are we overlooking?
  2. Why is DBConnect unable to retrieive the results?
  3. How can we disable 'selectMethod=cursor' for the connection object, I suspect this may be issue?

alt text

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

dbxquery supports stored procedures, inputs don't.

http://docs.splunk.com/Documentation/DBX/3.0.0/DeployDBX/Commands#procedure

0 Karma

michaelba
Explorer

No we can't use dbxquery because were trying to forward our data to Splunk Cloud.

What's the work around? The data needs to be forwarded from on-premise to splunk-cloud. We've been using inputs in DBConnect to do this, how do we get the same result given some of our data is coming from stored-procedures.

0 Karma
Get Updates on the Splunk Community!

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...