Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

jblomqvist
Valued Contributor

What type of Attributes can I create for Users imported via spreadsheet?

Hello,

We would like to import users via a spreadsheet.

What type of Attributes can I create for Users imported via spreadsheet?

For example we have a sheet with the UserID values. In association in another sheet in the same file we have columns such as Name, Department, Country, Role etc provided per user. Can we import these values as attributes?

Is there a limit on how many attributes you can import? Do these attribute values have to have specific column names so Qlik Sense user directory connector can read it correctly?

4 Replies
Employee
Employee

Re: What type of Attributes can I create for Users imported via spreadsheet?

How do you intend to authenticate these users?

You can import any attribute name that you want. Best practice is to not import more attributes than needed for your security rule setup. For example if you do not use department and country as part of your authorization, then theses values will not add any value in Qlik Sense.

This Support article Qlik help page might be helpful in setting up the UDC from Excel; https://support.qlik.com/articles/000037143
https://help.qlik.com/en-US/sense/February2019/Subsystems/ManagementConsole/Content/Sense_QMC/ODBC-e...
Highlighted
Partner
Partner

Re: What type of Attributes can I create for Users imported via spreadsheet?

Hello,
are you understand is you can't login in QlikSense as this users without custom auth module?
By default QS support only windows Auth
Employee
Employee

Re: What type of Attributes can I create for Users imported via spreadsheet?

Qlik Sense supports various authentication methods.
By default Windows auth is enabled and you can get authenticated with the user used during install or the service account.

https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense...

Attributes are utilized after successful authentication. Modern SSO authentication solutions like SAML and JWT provide attributes during authentication, which means UDC does not add any value. Hence it is relevant to confirm how you intend to authenticate the users?
Employee
Employee

Re: What type of Attributes can I create for Users imported via spreadsheet?

I am not seeing anything accepted as a solution. @ToniKautto 's answer seems quite right.

To directly address your questions:

  • For example we have a sheet with the UserID values. In association in another sheet in the same file we have columns such as Name, Department, Country, Role etc provided per user. Can we import these values as attributes?

Yes, so long as the fulfill the spec (userid,name for the Users Sheet / CSV / Table / View and userid,type,value for the Attributes Sheet / CSV / Table / View).

  • Is there a limit on how many attributes you can import?

Technically, I am sure there's a limit. At minimum something on the order of 2^64-1 as a 64 bit process. Practically, at scale, we've seen performance impacts on QRS intensive activity when we start to talk about millions of attributes across all users.

  • Do these attribute values have to have specific column names so Qlik Sense user directory connector can read it correctly?

userid,type,value as outlined in the help doc that @ToniKautto pointed to.