Deployment Architecture

SPLUNK DB 3.1.1 SQL Drivers

pfabrizi
Path Finder

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!

Tags (1)
0 Karma
1 Solution

harsmarvania57
Ultra Champion

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

View solution in original post

0 Karma

harsmarvania57
Ultra Champion

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

0 Karma

pfabrizi
Path Finder

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.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...