How to Connect to CDW Impala VW Using the Power BI Desktop / Service + Cloudera ODBC Impala Driver with Basic Authentication

[#1]

• Summary
• Pre-requisites
• How-To-do in Power BI Desktop
• Step1 : Install the [Impala ODBC Connector 2.7.0 for Cloudera Enterprise]
• Step 2: Copy the ODBC folder to Power BI Desktop folder
• Step 3: Edit the config file to specify ODBC Driver
• Step 4: Edit the config file to specify ODBC Driver parameter
• How-To-do in Power BI Service (On-premise Data Gateway)
• Step 1: Edit the config file to specify Driver
• Step 2: Edit the Simba .ini file to specify Driver parameter

Summary

Last week I posted an article [How to Connect to Impala Using the Power BI Desktop + Cloudera ODBC Impala Driver with Kerberos Auth...],

So far (2024 Sep),  CDP Public Cloud CDW supports Basic Authentication (HTTP), today I will share how to Connect to CDW Impala VW Using the Power BI Desktop + Cloudera ODBC Impala Driver with Basic Authentication.

Pre-requisites

• Power BI Desktop Edition 
  • https://www.microsoft.com/en-us/power-platform/products/power-bi/desktop
• Impala in CDP Public Cloud CDW
• Impala ODBC Connector 2.7.0 for Cloudera Enterprise
  • https://www.cloudera.com/downloads/connectors/impala/odbc/2-7-0.html

How-To-do in Power BI Desktop

Step1 : 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 to specify ODBC Driver

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

Step 4: Edit the config file to specify ODBC Driver parameter

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Cloudera ODBC Driver for Impala\lib\cloudera.impalaodbc.ini

[Driver]

AllowHostNameCNMismatch = 0
CheckCertRevocation = 0
TransportMode = http
AuthMech=3

* Cloudera CDW Impala VW doesn't need [httpPath] parameter, while Cloudera Datahub Impala cluster need [httpPath=cliservice]. Please be careful.

Then save these two files, and restart your Power BI Desktop.

How-To-do in Power BI Service (On-premise Data Gateway)

Step 1: Edit the config file to specify Driver

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

[Simba Impala ODBC Driver]
# Driver=Simba Impala ODBC Driver\ImpalaODBC_sb64.dll
Driver=Cloudera ODBC Driver for Impala\lib\ClouderaImpalaODBC64.dll

Step 2: Edit the Simba .ini file to specify Driver parameter

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Cloudera ODBC Driver for Impala\lib\cloudera.impalaodbc

[Driver]

AllowHostNameCNMismatch = 0
CheckCertRevocation = 0
TransportMode = http
AuthMech=3

Reference:

• https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Impala-connector-SSL-certificate-error/m-...