OBIEE connect to impala

1
votes

I'm trying to connect OBIEE to Impala. Where I try my test, I encounter a problem that I can't
resolved,here comes my steps:

  1. download the Cloudera latest Impala ODBC driver for windows,and import metadata from impala,I can finally successfully see data in Admin Tools like this: enter image description here

  2. upload the rpd file to the server,and download cloudera impala odbc driver for linux,and configure it,in the end ,I can do it like this which shows I have configure the driver successfully: enter image description here

  3. I try to create new analysis through 【Create Direct Database Request】 to test weather I can successfully connect Impala, but I can never connect it due to the reason like this,I can never fingure out why: enter image description here

Is there anybody successfully do it or tell me how I can resolve the problem? Thanks!

1
odbcclouderaobieeimpala
I can't read error text on second screenshot. Can you copy-paste it as text? Thanks – Tagar

1 Answers

0
votes

I recommend connecting directly to Hive instead. According to Oracle's documentation Impala connectivity is not directly supported. OBIEE is built connect to Hive and Impala is not referenced:

http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/deploy_rpd.htm#BABGIAJH