Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gandalfgray
Valued Contributor

Sharing Data Connections?

Hi

How do you grant access to other users to use a data connection you have created?

The Sense help says "To give access to the data connection to other users than the owner, edit the connection or go the Security rules page."


http://help.qlik.com/sense/en-US/online/#../Subsystems/Qlik_Management_Console_help/Content/QMC_Reso...


I can't really see where to do it neither in "Data connection edit" or "Security rules" page ...

Can someone give me a hint, please?

Tags (2)
7 Replies
Employee
Employee

Re: Sharing Data Connections?

Hello GandalfGray - to make sure of a few things.

If a user has been granted the ContentAdmin role - they will have access to ALL of the defined connections excluding the Folder-type (files) connection.

Is that sufficient for your use case or would you like to lock down specific connections to specific users / roles / groups etc?

If the latter - this can be done by setting up a new security rule.

I will provide you with some steps, once I learn more about which it is you would like to do.

Regards,

Mike T

Regards,
Mike Tarallo
Qlik
gandalfgray
Valued Contributor

Re: Sharing Data Connections?

Hmm

When logged in as a user (let's say MisterX) with ContentAdmin role, I do not have Data connections created by another user available, even though MisterX is listed under that connections associations with Read, Update permissions.

The first thing we would like is to be able to create one oledb data connections which all developers could use.

As it is now each developer must creates his own connection...

Regards

GG

Employee
Employee

Re: Sharing Data Connections?

OK cool - I need to check the ContentAdmin role suggestion again. (unless security rules were modified in some way) - a ContentAdmin role should have access to all connections regardless who creates them, but I will verify this again.

In regards to what you want to do - that can be achieved using the security rules (system rules) section in the data connection section of the QMC. Once the connection is created you can add a rule for which users and attributes you want to have access to it.

I am creating a video on this topic now - and will send to you shortly.

Mike

Regards,
Mike Tarallo
Qlik
gandalfgray
Valued Contributor

Re: Sharing Data Connections?

Thanks Michael!

Your answer led me into some experimenting.

I would like to avoid adding specific users to the data connection associations, so instead I did:

  1. Create a new Security Rule (calling it "Developer")
  2. Add the "Developer" role to all applicable users
  3. Add the Security Rule "Developer" to all applicable data connections

createnewsecurityruledeveloper.PNG.png

adddevelopertouser.PNG.png

addsecurityruletoconnection.PNG.png

Employee
Employee

Re: Sharing Data Connections?

Awesome - yes - that is one of  number of ways this can be achieved. The security rules engine is very flexible. I appreciate your willingness to explore and try it out, great job.

The video I am creating uses Active Directory groups pulled in from the user directory connector, and then locks the data connection down to those groups.

Mike

Regards,
Mike Tarallo
Qlik
scw
New Contributor III

Re: Sharing Data Connections?

Hi Michael - can you send us a link to this video? Thanks!

Employee
Employee

Re: Sharing Data Connections?

Hey Shyam,

You can see it here:

Qlik Sense Platform - Securing and Sharing Data Connections

Here is the main index for the platform videos:

New to Qlik Sense Enterprise Server Videos

- they are a bit older but should still be applicable. Since the release of Qlik Sense I am on the Cloud and Freemium team, so I don't get a chance to create many platform videos, but will try to when I can.

Here is the main index for all the videos:

New to Qlik Sense Videos

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Community Browser