Splunk DB Connect is failing with an error to connect with ODBC Impala

[Krish_Splunk]

Hi,

I have been able to login to Impala ODBC using my DSN as below.

isql -v Impala_DB

But when ever I am using Splunk DB Connect to create an External Database Connection via ODBC it is failing with an error like this.

Encountered the following error while trying to save: In handler 'databases': JDBC driver (sun.jdbc.odbc.JdbcOdbcDriver) for database type ODBC is not installed

I have checked the internet and it is said that Oracle has stopped providing JDBC support as of 1.8 java version which I have been using.
Not sure what to do now? Please help.

[acharlieh]

One correction, Oracle stopped shipping the JDBC-ODBC Bridge driver in Java 1.8. JDBC itself is still very much supported.

Now I'm assuming by Impala you mean the Cloudera Product you may have a few options here (none of which I've personally tried, but am piecing together via Documentation. YMMV).

• First of course is to go get the JDBC drivers for Impala and Setup DBConnect with an unsupported database so you can then create connections to Impala.
• Depending on what you're doing with the data, also in the realm of just outside of supported, you may be able to fight the HadoopConnect App to get what you need (with that app, I really mean I mean fight).
• But in the realm of actually supported technologies have you considered looking at Hunk?

[Krish_Splunk]

Hi Guys,

Any idea on this ?

[jcoates_splunk]

use DBX version 1.1.7 with the unsupported Java instead?