- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?)
michaelba
Explorer
02-21-2017
01:22 PM
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.
- What are we overlooking?
- Why is DBConnect unable to retrieive the results?
- How can we disable 'selectMethod=cursor' for the connection object, I suspect this may be issue?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
martin_mueller

SplunkTrust
02-21-2017
01:45 PM
dbxquery
supports stored procedures, inputs don't.
http://docs.splunk.com/Documentation/DBX/3.0.0/DeployDBX/Commands#procedure
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
michaelba
Explorer
02-21-2017
01:50 PM
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.
