Qlik Catalog. Data connection to Hive using Kerberos

[OlegShidrikov]

Hello,

Our customer wants to create a Hive connection in Qlik Catalog, but he wants to do in using Kerberos. Is there an instruction how to create a connection to Hive using Kerberos?

Best regards, Oleg Shidrikov

[DmitryD · Accepted solution]

Hi Oleg,

Thank you for raising this question, would you be able to advise if the below section in the user guide contains the information you are looking for?

Chapter 2.5 Kerberos - Page 7 and Chapter 5.2  Kerberos Configuration - page 31 and 32

https://help.qlik.com/en-US/catalog/May2021/Content/Resources/PDFs/QlikCatalog_May_2021_MultiNode_In...

Many thanks for your time!
Kind regards,

Dimitry

[lyka]

Hello Oleg,

Did you find what youre looking for based on the link that we shared?

Thanks

Lyka

[kenechi06]

Download & Install the MIT Kerberos for Windows
Once Kerberos for Windows Installed, open c:\ProgramData\MIT\Kerberos5 folder (or installation location in your windows)
Overwrite the krb5.ini with the correct configuration from krb5.conf (from Linux)
Add new System Environment Variable “KRB5CCNAME” that point to D:\Tableau\Kerberos\krb5cache. This variable will store the location where the Kerberos cache file will be stored.
Test the Kerberos ticket request by running command in CMD