https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179592#M98358 <P>Sorry, but I'm not allowed to share our code. It's pretty basic stuff, though, using standard Java SQL classes to send a query and retrieve the results.</P> Mon, 10 Mar 2014 12:27:38 GMT richgalloway 2014-03-10T12:27:38Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179585#M98351 <P>Hi<BR /> How to get data from database without using Splunk DBConnect.?</P> <P>Any help is appreciated.</P> <P>Cheers.</P> Mon, 10 Mar 2014 10:44:04 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179585#M98351 harshavrath 2014-03-10T10:44:04Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179586#M98352 <P>DB Connect IS how you would get data from databases with Splunk. Can you tell us more about why you can't use it?</P> Mon, 10 Mar 2014 10:46:43 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179586#M98352 Ayn 2014-03-10T10:46:43Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179587#M98353 <P>My company does not want any additional apps/software so exploring my options to access Database data in Splunk.</P> Mon, 10 Mar 2014 10:50:02 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179587#M98353 harshavrath 2014-03-10T10:50:02Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179588#M98354 <P>If you don't want to use DB connect you will have to build your own scripted or modular input - essentially you would have to reimplement DB Connect.</P> Mon, 10 Mar 2014 10:55:10 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179588#M98354 dart 2014-03-10T10:55:10Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179589#M98355 <P>You mean i need to write a script which queries the DB and saves the results into a text file which can be supplied to Splunk for indexing.</P> Mon, 10 Mar 2014 10:59:06 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179589#M98355 harshavrath 2014-03-10T10:59:06Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179590#M98356 <P>Before DB Connect existed, we wrote Java programs to read data from databases. Those programs are still used. The programs are launched by a shell script as a Splunk scripted input and anything the program writes to stdout is indexed by Splunk so there's no need for a text file. Of course, your program could be written in python or perl or anything you like.</P> <P>Our Java programs seem to be able to handle more complex queries than DB Connect. The programs also transform some data before passing it to Splunk - something DB Connect cannot do.</P> Mon, 10 Mar 2014 12:05:19 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179590#M98356 richgalloway 2014-03-10T12:05:19Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179591#M98357 <P>Hi thanks for the info.<BR /> Is there any link where i can refer the java code that you are mentioning.</P> Mon, 10 Mar 2014 12:09:51 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179591#M98357 harshavrath 2014-03-10T12:09:51Z https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179592#M98358 <P>Sorry, but I'm not allowed to share our code. It's pretty basic stuff, though, using standard Java SQL classes to send a query and retrieve the results.</P> Mon, 10 Mar 2014 12:27:38 GMT https://community.splunk.com/t5/Getting-Data-In/Getting-Data-from-Database-s/m-p/179592#M98358 richgalloway 2014-03-10T12:27:38Z