Getting Data In

Is there a dbconnect alternative that doesn't consume so much license?

davel1333
Engager

Is there an alternative to dbconnect for getting RDBMS data into Splunk?
I'm having some errors due to moving the data because my DB keeps changing, and the data in Splunk is not always up to date.
Also, I can't keep indexing all the data because this is consuming a lot of license.

nabeel652
Builder

The best option will be running scripts and just looking for the changed bits and sending to Splunk though HEC (or writing to file and monitoring). then dedup on the "unique key" in your data will give you all unchanged old records + changed new records. However, there is no out of the box solution for this other than dbconnect

richgalloway
SplunkTrust
SplunkTrust

Use the Rising Column feature of DB Connect to index only new data and save on your license.
Another option is to write your own modular input that uses JDBC to read the database the way to want to.

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

barriersbill
Explorer

yea the rising column should work, unless there isn't one then don't know what to do

0 Karma

vishaltaneja070
Motivator

@davel1333: If you don't want to consume licence or store data, then you can use dbquery command.

0 Karma

skalliger
SplunkTrust
SplunkTrust

Depends. Which DB are we talking about?

0 Karma
Get Updates on the Splunk Community!

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 ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...