All Apps and Add-ons

db connect does not load my data

Lynda_Sadi1275
Path Finder

Hello,
I connected my Oracle database with Splunk using db connect, but it does not recover the data.
Someone can help me please.

0 Karma

kmaron
Motivator

Are you running queries against your database? Connecting the database just allows you to then run queries against it and put the results of those queries into Splunk.

0 Karma

Lynda_Sadi1275
Path Finder

If I understand correctly you want to tell me that I can not perform SPL requests on this data??
for example, I run this query to see if it has recovered the data from Oracle but it shows me that type CSV returned sourcetype=*|stats count by sourcetype as shown in the following figure.alt text

0 Karma

MikaJustasACN
Path Finder

Did you actually ran the SQL query first to store the data in an index or trying to run searches in database using SPL?

0 Karma

Lynda_Sadi1275
Path Finder

I'm trying to run SPL queries on this data, I'm trying to put find event, but no event is found

0 Karma
Get Updates on the Splunk Community!

Introducing Edge Processor: Next Gen Data Transformation

We get it - not only can it take a lot of time, money and resources to get data into Splunk, but it also takes ...

Take the 2021 Splunk Career Survey for $50 in Amazon Cash

Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey. Last year’s ...

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...