Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tens
Partner - Contributor III
Partner - Contributor III

Connecting to Oracle with Kerberos Authentification

Hello community, 

I have a problem for creating an Oracle Database Connection. This database is using an Kerberos Authentification. I had no problem with sqlplus client on the qlik sense server to connect to the database, I just have to generate a ticket with an okinit command before. But when I tried to connect inside Qlik Sense with the Oracle Connection (Simba ODBC connection), it failed. I think that odbc SIMBA driver tried to connect to the database with a login and password and not with a Kerb ticket. How can I make understand to Qlik to use a Kerberos ticket to connect the Oracle Database please ? 

For the moment, I obtained this error in reply :  ORA-01017 Invalid Username/Password. 

I'm running on Qlik Sense Enterprise August 2021.

Thank a lot 

Labels (2)
3 Replies
Vinay_B
Support
Support

Hi @tens Please check the below post and let me know if it helps.

https://community.qlik.com/t5/Knowledge/Kerberos-authentication-with-Qlik-Sense/ta-p/1714592

Thanks!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!
tens
Partner - Contributor III
Partner - Contributor III
Author

Hi Vinay_Bhat, 

 

Thank for your answer. I already followed this post  Is the goal of this post to use Kerberos Authentification to get an access to Qlik Server ? If it is I'm not sure that it can answer to my problematic. Here I'm already log in Qlik, I just want to create an Oracle Data Connection that used Kerberos Authentification. I'm really not an expert into Kerberos, but if I'm logging into Qlik via Kerberos Authentification, can I use the same ticket to have an access to Oracle Database ? it seems that I need two differents tickets but maybe I missunderstood something in the way how works Kerberos... 

Thanks

tens
Partner - Contributor III
Partner - Contributor III
Author

Double posting but i can detail my problematic with good keywords. My problematic  is: Is Qlik sense can use Unconstrained Delegation or Constrained Delegation to authentificate a user on Oracle Database ?