Can you help me with an issue I'm having with Splunk DB connect?

[harishalipaka]

Hi All,

I have installed Splunk DB Connect App(version 3.1.3) in my Local host (7.0.0 version) and SQLServer 2012.

I am getting data from SQL to Splunk succesfully. But am unable to export the data from splunk to SQLserver .

I am not getting any error.

I attached my configuration,identy screenshot pls look into that and let me knnow if i did any mistakes.

[richgalloway · Accepted solution]

Nothing in the query in the comment above sends output to DB Connect. It just displays results in your browser. You need a dbxoutput command. See http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/HowSplunkDBConnectworks#Database_outputs.
Do you have an output defined in DB Connect? Does the identity defined in DB Connect have permission to write to the database?

[richgalloway]

How are you trying to export data from Splunk to SQL Server? What is your query?

[harishalipaka]

hi @richgalloway

ThanQ for your reply . Am using this query--->

index="my index name" |eval Tag="hari" ,Value=123 |table Tag Value

I have tried using another queries ,saved search and lookup also ,i didn't get .