Getting Data In

What is the best practice for importing SQL data in Splunk Cloud?

lcroce
New Member

Hi everyone,

Splunk noob here and I'm trying to import song logging data that I want to correlate with data from a SQL table so that I can include things in reports not in logs like people's names. I can import the logs easy enough, but I'm not sure what's the best way to go about getting the SQL data in. I know that I can import via a CSV and that there's also some SQL import scripts, but what would be the best way to import this?

0 Karma
1 Solution

sundareshr
Legend
0 Karma

sundareshr
Legend
0 Karma

lcroce
New Member

Unless I'm missing something, it doesn't look like this would work well with SplunkCloud or am I missing something?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

The steps the use the web interface should work in Splunk Cloud. You cannot edit .conf files. You can ask tech support to edit them for you, but that shouldn't be necessary if the web interface worked. Of course, this assumes your SQL database can be reached from the cloud.

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

lcroce
New Member

So basically, I'm limited to csv style import because this database is internal only. Thanks, though. I'll keep this in mind for the future.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Check out the Splunk DB Connect apps at https://splunkbase.splunk.com/app/958/ and https://splunkbase.splunk.com/app/2686/,

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

This Week's Community Digest - Splunk Community Happenings [9.26.22]

Get the latest news and updates from the Splunk Community here! Upcoming User Group Events! 👏 Check ...

BSides Splunk 2022 - The Call for Papers is now Open!

TLDR; Main Site: https://bsidessplunk.com CFP Site: https://bsidessplunk.com/cfp CFP Opens: December 15th, ...

Sending Metrics to Splunk Enterprise With the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...