All Apps and Add-ons

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

harishalipaka
Motivator

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.configuration

Identity

Thanks
Harish
1 Solution

richgalloway
SplunkTrust
SplunkTrust

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?

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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?

---
If this reply helps you, Karma would be appreciated.
0 Karma

richgalloway
SplunkTrust
SplunkTrust

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

---
If this reply helps you, Karma would be appreciated.
0 Karma

harishalipaka
Motivator

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 .

Thanks
Harish
0 Karma
Get Updates on the Splunk Community!

ATTENTION!! We’re MOVING (not really)

Hey, all! In an effort to keep this Slack workspace secure and also to make our new members' experience easy, ...

Splunk Admins: Build a Smarter Stack with These Must-See .conf25 Sessions

  Whether you're running a complex Splunk deployment or just getting your bearings as a new admin, .conf25 ...

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...