Press OK and you should be able to see your database and tables in Cloudera Impala CDH cluster and do any visualization in PowerBI.Ħ. Canonicalize Principal FQDN – what does it mean?Ī service or account may have multiple principal names.
It will show a dropdown for your recently created ODBC DSN for Impala with whatever name you specified. Select More->Other->ODBC option->connect.After ODBC Test is successful then go to the Power BI desktop and click on Get Data.Make sure you got a new kerberos ticket in the MIT Kerberos client using your userid and password. Test the connect if successful otherwise it wont work.Transport Buffer size=1000, Delegation UID leave blank. Leave the Delegate Kerberos Credentials and Use Keytab as blank. Host=Impala datanode hostname, Port=21050, Database=default, Authentication Mechanism=Kerberos, Realm=Your kerberos realm, Host FQDN=_HOST, Service Name=impala.While creating the ODBC DSN use the following parameters:.(created by Simba Technologies) but best to download the Cloudera ODBC Driver for Impala or Hive from Cloudera website. I used the MicroStrategy Impala ODBC driver client version 1. Install the MIT Kerberos client for Windows and make sure you have successfully got a ticket to the Cloudera CDH cluster.The below blog only shows Impala driver but you can use same procedure with Hive driver also. Microsoft Power BI desktop is free and is able to successfully connect to a Cloudera Impala or hive database with Kerberos security enabled.
0 kommentar(er)
