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

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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...