topic Re: Adding External Users in QMC in Integration, Extension & APIs

Adding External Users in QMC

baarathi — Thu, 08 Nov 2018 13:51:13 GMT

Is it possible to add external users to QMC through API, Actual scenario is I have List of users in SQL Server DB and I want to add them in QMC. The problem is I don't want to add them using ODBC User Directory Connection (i.e. restrict access to the database, instead will provide the API).

Any thoughts/suggestion, will much appreciated.

Re: Adding External Users in QMC

garystrader — Thu, 08 Nov 2018 15:04:46 GMT

QRS API has a POST method endpoint /qrs/user that can be used to add users.

You could use PowerShell and Qlik-Cli for convenience and run New-QlikUser to add users. You could read values from a CSV using PowerShell and pipe to New-QlikUser to batch load them.

Re: Adding External Users in QMC

Levi_Turner — Thu, 08 Nov 2018 17:09:50 GMT

Hey Baarathi,

Why do you need to add users? When a user auths, a record inside of Sense will be created if one doesn't already exist?

Re: Adding External Users in QMC

garystrader — Thu, 08 Nov 2018 17:22:07 GMT

Hey Levi,

I'm not sure what Baarathi is trying to do, but we had a scenario where a customer asked if we could bulk load users and automatically assign roles/properties/tags to those users before they logged in the first time so that existing security rules would automatically apply to them. We never implemented it so I'm not sure if it works or if it's a good use case for this.

Re: Adding External Users in QMC

Levi_Turner — Thu, 08 Nov 2018 17:26:31 GMT

Ahh, in that scenario, a UDC seems more appropriate and then leverage attributes from the UDC in rules. But that may not be possible.

Re: Adding External Users in QMC

garystrader — Thu, 08 Nov 2018 17:33:43 GMT

That's an intriguing option - load a custom attribute from any UDC. Use QRS API to read the custom attribute for each user and assign a role/property/tag/whatever to the user depending on the value(s) in the custom attribute. Then it's completely UDC driven. But it's only batch mode updates to those roles/properties/tags.

Re: Adding External Users in QMC

Levi_Turner — Thu, 08 Nov 2018 18:01:17 GMT

I was more envisioning using the UDC attributes directly rather than assigning roles as such. But that's purely for an authorization framework rather than using tags as ways of filtering things. Heck, if you wanted to go crazy, you could always chain a UDC task sync with an external process which calls a script to assign roles, etc using the QRS Notification API: https://eablog.qlikpoc.com/2018/11/01/qlik-sense-repository-notification-api/

Re: Adding External Users in QMC

baarathi — Fri, 09 Nov 2018 06:31:01 GMT

Hello Gary and Levi,

Thank you for your inputs. May be I have to be more clear on my request.

We are using Active Directory UDC to pull our internal Users from AD to access Hub. Like wise, we wanted our vendors (external users) also to access Hub to view few dashboards. But, these vendors are not part of our AD, they are maintained in a Database and we have one API to pull the list of users from the database and one more API to authenticate them for other applications.

We do not want to expose the database directly to Qlik Sense via SQL ODBC UDC. Instead we would like to use the API to pull the list of vendors to Qlik Sense.

Re: Adding External Users in QMC

Levi_Turner — Fri, 09 Nov 2018 13:38:35 GMT

Again, why do you need to have a user record beforehand?

Re: Adding External Users in QMC

PuriVelasco — Fri, 16 Oct 2020 15:13:19 GMT

Hello @baarathi

Have your solved your problem? I have a similiar question.

Thank you.

Re: Adding External Users in QMC

baarathi — Tue, 27 Oct 2020 19:12:58 GMT

@PuriVelasco Yes, done through header authentication

Re: Adding External Users in QMC

PuriVelasco — Wed, 28 Oct 2020 09:52:01 GMT

@baarathi thank your for your answer. Could you respond me other two things?:

Do you use this system with seccion access for applications?

Do you known the password of your users?

Thank you again.

Re: Adding External Users in QMC

baarathi — Sat, 31 Oct 2020 19:56:38 GMT

@PuriVelasco sorry for the delayed response. Please feel comfortable to connect through my linkedin.

yes, I have used section access. I could not understand your second question. Could you please explain it again.

Re: Adding External Users in QMC

PuriVelasco — Thu, 05 Nov 2020 12:56:43 GMT

Thank you very much Baarathi.

I solved the question with the virtual proxy of qmc and Active Directory from Azure.