Getting Data In

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

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.

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

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, an upvote would be appreciated.
0 Karma

Explorer

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

0 Karma

Motivator

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

0 Karma

SplunkTrust
SplunkTrust

Depends. Which DB are we talking about?

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!