All Apps and Add-ons

Trying to connect to sybase db.

pdjhh
Communicator

Hi,

I'm trying to connect to a sybase data source but DBX v2 is saying it doesn't have the driver. A search says I need to download jconn(n).jar and install it but I can't find the file anywahere that doesn't require a login. Can anyone point me at a copy of the required file I wonder? Don't know why it's not there in the first place if Splunk says it's supported. Same thing happened for jtds.

Tags (2)
0 Karma

acharlieh
Influencer

To answer your question: "Don't know why it's not there in the first place if Splunk says it's supported"

DBConnect leverages the JDBC API to talk to Databases. This API is standardized, however every Database vendor creates, maintains, and more importantly in this case licenses their JDBC Driver used to translate from the API to actual interactions with their own database.

  1. Splunk will test and support certain databases, but likely will not have the rights to redistribute proprietary software, that's on you, who has licensed the databases you are using from the companies who produce them. (Such agreements for proprietary databases would likely come with massive costs to Splunk).
  2. While Splunk would test many different databases with their product, most people will use only one or two different kinds of databases, thus shipping all of the supported JDBC drivers would bloat the size of DBX unnecessarily for most people. Very few would need all the drivers. (not to mention all the versions of all the drivers, there sometimes can be an interesting matrix of which JDBC driver you need to connect to which version of each database for what features... cough cough Oracle cough cough)
  3. Not to mention bugs happen. That would be a massive investment of time to repackage and re-ship all of the database drivers each time there is a bug that might impact someone. It's less time for Splunk to have you take responsibility for staying on top of the issues with the Databases you choose to run in your environment, and which driver bugs you would encounter with your data and access patterns.

Hopefully this helps you understand some reasons why it's better to not ship JDBC drivers with DBConnect.

pdjhh
Communicator

I had to get someone with an SAP account to download it for us in the end.

0 Karma

fdi01
Motivator
0 Karma

pdjhh
Communicator

Hi. Thanks for the response but that page is my problem. It tells you to log in to support.sap.com to get the file and you need a sap contract number to be able to do that.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...