Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)
avatar
Expert Contributor

Pre-requisites

Process

Step 1: Install the [Impala ODBC Connector 2.7.0 for Cloudera Enterprise] 

Step 2: Copy the ODBC folder to Power BI Desktop folder

Assume your Power BI Desktop is in [ C:\Program Files\Microsoft Power BI Desktop\ ], then please copy the ODBC Driver [ C:\Program Files\Cloudera ODBC Driver for Impala ] to [C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Cloudera ODBC Driver for Impala]

Step 3: Edit the config file

[ C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Impala ODBC Driver.ini ]

[Simba Impala ODBC Driver]
# Oringinally PowerBI will use its embedded driver, we can change it to Cloudera version
# Driver=Simba Impala ODBC Driver\ImpalaODBC_sb64.dll
Driver=Cloudera ODBC Driver for Impala\lib\ClouderaImpalaODBC64.dll
# If you don't use SSL
SSL=0

 

 

 

Step 4: Run Power BI Desktop

If you want to use Windows AD Kerberos, then please don't install MIT Kerberos, and make sure you are using the Windows AD domain account to log in and run the Power BI Desktop application.

* Reference :

In the [Cloudera-ODBC-Connector-for-Impala-Install-Guide.pdf], it mentioned that, 

==============

  • Configuring Kerberos Authentication for Windows
  • Active Directory
    • The Cloudera ODBC Connector for Apache Impala supports Active Directory Kerberos on
      Windows. There are two prerequisites for using Active Directory Kerberos on Windows:
      • MIT Kerberos is not installed on the client Windows machine.
      • The MIT Kerberos Hadoop realm has been configured to trust the Active Directory realm,
        according to Apache's documentation, so that users in the Active Directory realm can
        access services in the MIT Kerberos Hadoop realm.

==============

Step 5: Test Connection using ODBC

Open the [ODBC Data Source (64-bit)] application, and add a new DSN for testing.

zzeng_0-1724938549611.png

I didn't use SSL, so I left the SSL un-checked.

zzeng_1-1724938574098.png

For debug, you can set the log level to DEBUG.

zzeng_2-1724938645149.png

As we will be using Kerberos to connect to Impala, please ensure that the AD server and DNS server are correctly configured.

zzeng_3-1724938752729.png

Step 6: Fetch data in Power BI Desktop

In Power BI Desktop, use the [Get data -> more],

zzeng_4-1724938813608.png

Input [Impala] to search for the connector,

zzeng_5-1724938864650.png

Then, input the server info:

zzeng_0-1724939419733.png

After that, you can use Windows Authentication (as Kerberos), input the 

  • DOMAIN\account
  • password

Then you can see the window below:

zzeng_0-1724938968895.png

 

At last, you can see the data after loading:

zzeng_1-1724939523222.png

942 Views
0 Kudos