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

*********All the Best***********
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 .

*********All the Best***********
0 Karma
Get Updates on the Splunk Community!

New Splunk Observability innovations: Deeper visibility and smarter alerting to ...

You asked, we delivered. Splunk Observability Cloud has several new innovations giving you deeper visibility ...

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...