topic connecting SPLUNK to ODBC Data Base in Getting Data In

connecting SPLUNK to ODBC Data Base

Moshe — Mon, 01 Apr 2024 11:00:59 GMT

Hi,

I'm looking for a way to connect the SPLUNK to a ODCB data base, so the Splunk will be able to pull any data needed from that data base.

So far, I have been told that the SPLUNK is working with JDBC and the other product is working with ODBC, so there is no way to make that connection.

Can someone tell me otherwise?

Re: connecting SPLUNK to ODBC Data Base

kiran_panchavat — Mon, 01 Apr 2024 14:19:56 GMT

@Moshe Hey, Please find the below documents for your reference

The Splunk ODBC Driver - Splunk Documentation

Configure the Splunk ODBC driver with Microsoft Power BI - Splunk Documentation

using-the-splunk-odbc-driver-tech-brief.pdf

Re: connecting SPLUNK to ODBC Data Base

PickleRick — Mon, 01 Apr 2024 14:27:53 GMT

ODBC is not a database but a standardized way of accessing the database - any database for which there is a n appropriate ODBC driver.

So there is no such thing as "ODBC database".

Same goes for JDBC - it's another abstraction layer providing common interface to databases.

Question is what database you have and what do you want to do with it and is there a jdbc driver for your particular database because if there is you can use the DBConnect with proper jdbc data source.

Re: connecting SPLUNK to ODBC Data Base

tscroggins — Tue, 02 Apr 2024 02:42:07 GMT

Hi @Moshe,

Before Java 8, Oracle (and Sun prior to its acquisition) included a JDBC-ODBC bridge driver with Java for Windows. Java 7 support ended in 2022, and Splunk DB Connect support for Java 7 ended many years ago.

If no JDBC driver is available for your data source, you may be able to find a current JDBC-ODBC bridge solution from OpenText (formerly Micro Focus, which acquired Serena Software and Merant), CData, or another vendor. Those vendors may also sell a JDBC driver for your data source; however, not all JDBC drivers support the interfaces required by Splunk DB Connect.

Which ODBC driver and/or database platform are you trying to query? A scripted input might be the easiest solution to your problem.

Re: connecting SPLUNK to ODBC Data Base

Moshe — Sun, 07 Apr 2024 14:40:11 GMT

Hi @PickleRick

Thank you for your replay, as you probably noticed, I'm not a Data Base person.

can you please explain me how I can find out what kind of Data Base I have?

and what kind of data base there are?

Re: connecting SPLUNK to ODBC Data Base

PickleRick — Sun, 07 Apr 2024 15:03:57 GMT

Well, since you need to connect to an existing database, it must have been set up and be maintained by someone. That's the easiest way to find out - go and ask 🙂

You can find most popular engines here https://en.wikipedia.org/wiki/Relational_database#List_of_database_engines (among other sources).