Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

How can i publish a data connection to all users from qmc?

how can i publish a data connection to all users from qmc? so one ole db connection created by me will be  visible to all users in  connection pane area at Qliksense?

11 Replies
shraddha_g
Partner - Master III
Partner - Master III

Write a security rule fir data connection for users.

If users have deployment role assigned then create new associated rule as user with role having value as Deployment Admin

ananyaghosh
Creator III
Creator III
Author

Hi, I do not understand your explanation. Kindly can u give me step by step screen shots and code for this to clear understanding.

Thanks,

Sandip

shraddha_g
Partner - Master III
Partner - Master III

1. Login to QMC

2. Select Data Connection from Left Side Panel.

3. Select Data Connection and Click on Edit button on bottom.

4. Click on Security Rule from Right under Associated Items.

5. Click on Create Associated Rule from bottom.

6 .Create Security Rule as Below.(If you have assigned Deployment Admin Role to user. If number of users are less the you can assign it to individual user by selection userID instead of roles and userID of user at place of DeploymentAdmin).

7. Click on apply.

ananyaghosh
Creator III
Creator III
Author

Hi ,

I have used as it is as shown below in the below screen shots:

But another user does not view the connection name in their connection pane area. Please suggest what to do now.

shraddha_g
Partner - Master III
Partner - Master III

What security role you have assigned to your users?

shraddha_g
Partner - Master III
Partner - Master III

You can also try with creating Custom Property.

Go to Custom Property -> Create New -> Give name to Custom Property as say DataConnectionAccess -> From Checkboxes check Users -> Set Value as Yes and No

Now go to Users sections

Select user whom you want to give access - > From right pane click on custom Property - > assign value as Yes

Now follow the steps to create security rule for Data connection as stated in my previous reply.

now create security rule as

Let me know whether it works for you

thomaslg_wq
Creator III
Creator III

Hi Sandip, just change the condition text with :

!user.IsAnonymous()

and it will work for every users

ananyaghosh
Creator III
Creator III
Author

Hi,

Can u give me a proper example with a screenshot. How can I put this condition text ?

Thanks,

Sandip

shraddha_g
Partner - Master III
Partner - Master III

When you will create security rule, on right pane click on Advanced and put that in 'Conditions'