Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gandalfgray
Specialist II
Specialist II

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?

9 Replies
Michael_Tarallo
Employee
Employee

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
Specialist II
Specialist II
Author

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

Michael_Tarallo
Employee
Employee

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
Specialist II
Specialist II
Author

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

Michael_Tarallo
Employee
Employee

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
Former Employee
Former Employee

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

Michael_Tarallo
Employee
Employee

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
AswainKumarDiageo
Contributor II
Contributor II

@Michael_Tarallo Can please share the video you created for providing access to the Qlik  Data connection with help of Active Directory groups.

I need to provide access to my developer team to access the data connection created from my end. I tried with the above-mentioned links which are not currently accessible.

Regards,

Aswain

 

 

barnabyd
Partner - Creator III
Partner - Creator III

For anyone that's interested, I had the same problem with a Data Connection that was not visible to other developers, even though I have given them ContentAdmin. I discovered that the ContentAdmin rule was restricted to the QMC and not the Hub, so the problem was fixed by expanding the context option to "QMC and the Hub".

CHeers, Barnaby.

Barnaby Dunn
BI Consultant