topic Re: SPLUNK DB 3.1.1 SQL Drivers in Deployment Architecture

SPLUNK DB 3.1.1 SQL Drivers

pfabrizi — Wed, 31 Jan 2018 12:32:24 GMT

I have SPLUNK DB Connect installed and trying to configure it for SQL using Windows Auth. We get an error and it looks like it needs a driver, I have the JDK installed but is there a MS SQL driver needed?

Thanks!

Re: SPLUNK DB 3.1.1 SQL Drivers

harsmarvania57 — Wed, 31 Jan 2018 14:20:31 GMT

Hi @pfabrizi,

I suggest you go through Splunk DB Connect perquisite first http://docs.splunk.com/Documentation/DBX/3.1.1/DeployDBX/Prerequisites

And in this document http://docs.splunk.com/Documentation/DBX/3.1.1/DeployDBX/Installdatabasedrivers#Supported_databases , they have provided all supported database with JDBC driver version.

JDBC driver is require to connect to database from Splunk DB connect.

I hope this helps.

Thanks,
Harshil

Re: SPLUNK DB 3.1.1 SQL Drivers

pfabrizi — Wed, 31 Jan 2018 17:18:36 GMT

Thanks, I found the drivers I needed and then we had to configure the sql connection string like we did in 2.x although the documents didn't indicate those settings.