question odbc connection issue with qliksense in Support Questions

odbc connection issue with qliksense

badsha — Fri, 02 Aug 2024 11:52:30 GMT

When trying odbc connection it is successful here. But when trying to connect from Qliksense, it is throwing an error

"Error: Connector connect error: SQL##f - SqlState: 28000, ErrorCode: 9, ErrorMsg: [Amazon][ThriftExtension] (9) Error occurred while authenticating via SASL. Error details: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Matching credential not found)"

What might be the issue?is it issue with kerbeors? then what is the solution?it is happening with all the conenctions.

Re: odbc connection issue with qliksense

VidyaSargur — Mon, 05 Aug 2024 09:55:49 GMT

@badsha, Welcome to our community! To help you get the best possible answer, I have tagged our Kerberos experts @vamsi_redd @Sean who may assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: odbc connection issue with qliksense

vamsi_redd — Tue, 06 Aug 2024 10:17:18 GMT

Hi @badsha, did you configure kerberos in the windows client machine

https://community.cloudera.com/t5/Community-Articles/User-authentication-from-Windows-Workstation-to-HDP-Realm/ta-p/245957

Please configure this, if you can't install kerberos, then you can access the hive though knox and you can using ldap credentials

Re: odbc connection issue with qliksense

VidyaSargur — Mon, 19 Aug 2024 04:51:08 GMT

@badsha, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.