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

[michaelba]

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?

[martin_mueller]

dbxquery supports stored procedures, inputs don't.

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

[michaelba]

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.