Getting Data In

Query on the SQL Version 2017 | Splunk DB Connect

kiranpanchavat1
Path Finder

Hello Guys, 

We have to integrate one of the SQL server with Splunk and the current version is  SQL 2014. We are using splunk db connect app to configure it. 

Kindly confirm if SQL team can upgrade to 2017 , is it compatible with splunk db connect or do they need to upgrade it to SQL 2019 ? 

Provide any solutions/documents on this .

Labels (2)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

Hi

I haven't try this (yet) by myself, but here is MS SQL compatibility matrix SQL version compatibility. Based on that JDBC Driver 9.4 should be compatible for all those MS SQL Server versions.

Based on documentation at least DBX 3.6.0 should work also with MS SQL Server 2014. It seems that DBX 3.6.0 was the last "old school" version where you install drivers "manually" and 3.7.0 has own TA/SA for drivers instead of pure jar.

r. Ismo

View solution in original post

isoutamo
SplunkTrust
SplunkTrust

Hi

I haven't try this (yet) by myself, but here is MS SQL compatibility matrix SQL version compatibility. Based on that JDBC Driver 9.4 should be compatible for all those MS SQL Server versions.

Based on documentation at least DBX 3.6.0 should work also with MS SQL Server 2014. It seems that DBX 3.6.0 was the last "old school" version where you install drivers "manually" and 3.7.0 has own TA/SA for drivers instead of pure jar.

r. Ismo

Get Updates on the Splunk Community!

Digital Resilience Assessment Launch | How prepared are you for disruption?

Disruption is inevitable. The question is – how prepared are you to handle it? In today’s fast-moving digital ...

Buttercup Games: Further Dashboarding Techniques (Part 2)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Index This | What is the next number in the series? 7,645 5,764 4,576…

February 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...