Hi, Can splunk read data from Microsoft SQL Server 2008? We have an application which logs business exceptions to SQL database, currently we have a customized dashboard which shows these exceptions to business users, we are considering to use Splunk for all kinds of exceptions including business exceptions, is there a way to display SQL data (business exceptions) using Splunk.
Directly, no. Splunk does not have any native interface to an SQL database of any kind. The supported method for doing this is with a 'scripted input' where Splunk periodically runs a shell script of your design and indexes its output. That shell script is free to connect to a database and extract whatever data it desires.
There are some add-on apps in Splunkbase that provide examples / implementations of this scripted input. The first one I found was http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input . I have not tried it, and don't know if it will work for your purpose or not.