Support Questions

Find answers, ask questions, and share your expertise

Access Impala from Oracle SQL Developer or similar tool

avatar

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

T.

 

1 ACCEPTED SOLUTION

avatar
Explorer
10 REPLIES 10

avatar
Contributor

@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!