Solved: Query on the SQL Version 2017 | Splunk DB Connect

kiranpanchavat1 · ‎12-27-2021

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 .

isoutamo · ‎12-27-2021

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 · ‎12-27-2021

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

Query on the SQL Version 2017 | Splunk DB Connect

heavy forwarder

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

Thanks for the Memories: .conf26 Took Learning to New Heights

Best Practices: Splunk auto adjust pipeline queue

Join the Conversation