Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
karthickv
Not applicable

Connection in Qlik Sense

Hi All,

To allow few Business Admins to create their own QVF files and to govern it by controlling the connections, I want to know the possibilities of the below

  1. Restrict Business Users to use only few connections.
  2. Disable ‘Create new connection’ option to Users. (Meaning they can make use of predefined connections but not create new connection).

With a snapshot would be more helpful.

Thanks in advance,

Karthick V.

1 Solution

Accepted Solutions
vlad_komarov
Not applicable

Re: Connection in Qlik Sense

Karthick,


Yes, you can do it.


First, you need to create these Connections. They will be produced with default set of rules, most of them generic (applicable to all Connectors):

Screen Shot 2017-04-07 at 7.07.23 AM.png

As you can see Security Admins and Content Admins have full ability to modify/add/delete these Connectors.

So, just make sure that your BA will not be set as these Admins....


I would recommend to create a Custom Property for your BAs. For example, this is how I've done it for my team:

Screen Shot 2017-04-07 at 7.13.08 AM.png

So, for "Consumers" you can create a New Rule in Connections that will give then Read Only access:

Screen Shot 2017-04-07 at 7.08.08 AM.png


And of course you can do it for all Connectors (like above) or you can do different approach for different Connectors (just update the property in Resource Filter line):

Screen Shot 2017-04-07 at 7.17.38 AM.png


I hope it will help!


Regards,

Vladimir

9 Replies
simondachstr
Not applicable

Re: Connection in Qlik Sense

vlad_komarov
Not applicable

Re: Connection in Qlik Sense

Karthick,


Yes, you can do it.


First, you need to create these Connections. They will be produced with default set of rules, most of them generic (applicable to all Connectors):

Screen Shot 2017-04-07 at 7.07.23 AM.png

As you can see Security Admins and Content Admins have full ability to modify/add/delete these Connectors.

So, just make sure that your BA will not be set as these Admins....


I would recommend to create a Custom Property for your BAs. For example, this is how I've done it for my team:

Screen Shot 2017-04-07 at 7.13.08 AM.png

So, for "Consumers" you can create a New Rule in Connections that will give then Read Only access:

Screen Shot 2017-04-07 at 7.08.08 AM.png


And of course you can do it for all Connectors (like above) or you can do different approach for different Connectors (just update the property in Resource Filter line):

Screen Shot 2017-04-07 at 7.17.38 AM.png


I hope it will help!


Regards,

Vladimir

karthickv
Not applicable

Re: Connection in Qlik Sense

You are a MASTER Vlad !

This is exactly what i am looking for.

Thank you very much,

Karthick V.

karthickv
Not applicable

Re: Connection in Qlik Sense

Vlad,

Can you please share a screenshot on how can I assign my BA to 'Consumer' ?

Thanks,

Karthick V.

vlad_komarov
Not applicable

Re: Connection in Qlik Sense

Sure, here you go:

1. Users--> Edit User (you can select multiple Users and do a bulk change):

Check the Roles first:

Screen Shot 2017-04-07 at 8.01.05 AM.png

And then apply the Custom Property:

Screen Shot 2017-04-07 at 8.01.29 AM.png

Please note that the UserType property was created by me, so you can have your own like "BA User" and "End User", for example.

Regards,

Vlad

karthickv
Not applicable

Re: Connection in Qlik Sense

Hi Vlad,

Despite following all the steps mentioned above, the User is still able to see 'Create New Connection'.

Can you kindly suggest ?

Thanks,

Karthick V.

karthickv
Not applicable

Re: Connection in Qlik Sense

Thank you Martin !

vlad_komarov
Not applicable

Re: Connection in Qlik Sense

Could you send your QMC screenshots? Some step is probably missing...

BTW, Did you apply all above to specific Connector(s), or to all of them?

VK

karthickv
Not applicable

Re: Connection in Qlik Sense

Hi Vlad,

Though we could see 'Create New connection', Folder option is not enabled but others are visible. So we are partly happy.

Will we be able to control other connections also ? (ODBC, OLEDB,....)

Before Applying Rules:

After applying rules.png

After applying Rules ('Folder' option is disabled):

Before applying rules.png

Thanks,

Karthick V.