question Access Impala from Oracle SQL Developer or similar tool in Archives of Support Questions (Read Only)

Access Impala from Oracle SQL Developer or similar tool

Tomas79 — Tue, 21 Apr 2026 13:56:15 GMT

Hi guys,

has anybody experience how to setup an access from SQL Developer to Impala via JDBC/ODBC?

I have read a discussion forum (outdated) where it states that Oracle does not support Impala, better said Oracle has a whitelist of connectors,

Impala is not there.

If SQL Developer cannot be used, do you have any suggestion what tool should use a Oracle developer who needs to access Imapal (and

dont want to use Hue, neither impala-shell)?

Thanks

Re: Access Impala from Oracle SQL Developer or similar tool

Nickd — Fri, 20 Nov 2015 11:46:03 GMT

DB Visualiser

Re: Access Impala from Oracle SQL Developer or similar tool

Tomas79 — Thu, 26 Nov 2015 07:54:02 GMT

I tried the eval version, after some issues finally managed to connect to Impala and Hive as well.
Thanks

Re: Access Impala from Oracle SQL Developer or similar tool

Safeway — Fri, 04 Mar 2016 03:54:27 GMT

Hello,

Were you able to connect to HDFS using Impala via SQL Developer?

please share the details.

Thanks

Bhupal

Re: Access Impala from Oracle SQL Developer or similar tool

Tomas79 — Mon, 14 Mar 2016 21:36:34 GMT

Update: try Toad for Hadoop. It supports Impala and Hive with Kerberos, unfortunately the combination LDAP+Kerberos is not supported (yet).

Very nice tool, you can access impala, other databases, hdfs in one place. The cool thing is that if you use Cloudera Manager, the tool connects to the CM and fetches all the config info, so you dont have to configure the impala ports, and resource manager address, hdfs namenode etc etc.

Re: Access Impala from Oracle SQL Developer or similar tool

CuckooKernel — Mon, 16 May 2016 22:43:50 GMT

I wonder if you were able to access Impala or Hive on *kerberized* cluster or on a cluster with any kind of authentication mecanism. Please do tell.

Re: Access Impala from Oracle SQL Developer or similar tool

Tomas79 — Tue, 09 Aug 2016 14:31:25 GMT

Yes, it works with kerberized cluster.

Re: Access Impala from Oracle SQL Developer or similar tool

CuckooKernel — Tue, 09 Aug 2016 16:22:25 GMT

Could you please tell me *what* works with kerberized cluster? Toad for Hadoop, DB Visualizer, another tool?

Re: Access Impala from Oracle SQL Developer or similar tool

Tomas79 — Tue, 09 Aug 2016 17:04:43 GMT

Toad for Hadoop.

Re: Access Impala from Oracle SQL Developer or similar tool

MyCluster — Wed, 07 Dec 2016 18:59:06 GMT

you can connect hive (kerberised cluster / SSL TLS enabled) from SQL Developer.

I am trying to connect (kerberised cluster / SSL TLS enabled) Impala from SQL Developer, is it working for any one?

Re: Access Impala from Oracle SQL Developer or similar tool

dna_29a — Wed, 16 Aug 2017 16:30:14 GMT

@Tomas79 wrote:
Update: try Toad for Hadoop. It supports Impala and Hive with Kerberos, unfortunately the combination LDAP+Kerberos is not supported (yet).

Not supported, but where is a trick how to connect to Impala under Kerberos + LDAP in TOAD for Hadoop.

1) First, select in TOAD Impala + LDAP only (without Kerberos) and check connection. It fails, well.

2) Enable Kerberos in TOAD (LDAP auth options will become unalivable), but still actual. Check connection again.

3) Success!