Which command can I use to get data from a database? (not "dbxquery")

[agentsofshield]

I usually use "dbxquery" but it only works in the search app. I'm trying to export data from a database through Splunk SDK, so I'd like to know if there's an alternative command for the same purpose.

[agentsofshield · Accepted solution]

I solved it, my mistake was that the query originally included a lot of quotations, so I added a config file where I wrote all the queries, then imported it to the script with this:

https://docs.python.org/2/library/xml.etree.elementtree.html

So, it's mostly a Python issue not a Splunk issue.

[horsefez]

Hi @agentsofshield,

have you found the DB-Connect app yet?

https://splunkbase.splunk.com/app/2686/