Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New to qlik sense , i am trying to add new test users to qlik via EXCEL ODBC UDC, can i add a password column to my Excel sheet so my users can authenticate with this password ?
I need these users to test my section access security rules.
thanks a lot for your help.
Hi @hudhud_hoda ,
The advantage of importing user from excel file is,
User's information upload to Qlik Sense prior to user login/authenticate to Qlik Sense. After the user synced to Qlik Sense via Excel, the Qlik sense admin can assign the concerned license to the new user as well as security rule, etc. Everything is prepared before the new user's first login to avoid any surprise about the user's privilege in Qlik Sense.
For creating test users in Qlik Sense, you can create local user in Windows server. Then use this server credential login to Qlik Sense. Refer to this article.
https://support.qlik.com/articles/000034159
Hope this helps.
Hi @hudhud_hoda
unfortunately, Excel doesn't have an authentication module. This means you still need an external authentication module like AD or Windows server local user etc.
Thank you very much for your answer, I don't understand then what is the advantage of adding users with Excel ODBC ???
all I wanted was to create some test users so that I could log in from my Windows account to their Qlik space and see if Section Access works. Is there any way to do this?
Hi @hudhud_hoda ,
The advantage of importing user from excel file is,
User's information upload to Qlik Sense prior to user login/authenticate to Qlik Sense. After the user synced to Qlik Sense via Excel, the Qlik sense admin can assign the concerned license to the new user as well as security rule, etc. Everything is prepared before the new user's first login to avoid any surprise about the user's privilege in Qlik Sense.
For creating test users in Qlik Sense, you can create local user in Windows server. Then use this server credential login to Qlik Sense. Refer to this article.
https://support.qlik.com/articles/000034159
Hope this helps.
thanks a lot, I really appreciate your explications, I will test the solution and let you know if it works with me .