topic Re: Is there a dbconnect alternative that doesn't consume so much license? in Getting Data In

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

davel1333 — Wed, 29 May 2019 04:36:37 GMT

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.

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

skalliger — Wed, 29 May 2019 09:33:47 GMT

Depends. Which DB are we talking about?

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

vishaltaneja070 — Wed, 29 May 2019 10:17:03 GMT

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

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

richgalloway — Wed, 29 May 2019 13:25:53 GMT

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.

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

nabeel652 — Thu, 30 May 2019 23:52:12 GMT

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

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

barriersbill — Sun, 09 Jun 2019 05:31:47 GMT

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