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!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...