Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Does Qlik Store data Internally?

I have a data connection to SQL server which have sensitive data.

1. I want to know when I connect using Qlik , will qlik create a copy of this data internally and store it in repository. Is this encrypted or it can be accessed?

2. Can anyone not having access to the SQL DB, but access to app can access this data.

 

Thank You,

Labels (2)
2 Solutions

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Does Qlik Store data Internally?

Qlik will store these data internally and they are not encrypted - but you could with Section-Access control who get access to these data.

- Marcus

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

Re: Does Qlik Store data Internally?

With section access you could limit either rows as well as columns - to control the columns you need to exclude them within OMIT.

- Marcus

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Does Qlik Store data Internally?

Qlik will store these data internally and they are not encrypted - but you could with Section-Access control who get access to these data.

- Marcus

View solution in original post

Highlighted
New Contributor II

Re: Does Qlik Store data Internally?

Thank you for your answer. 

With Section Access we can limit the data in rows. Can we limit the columns. Eg. Certain users can see the address, phone no of a person but not all.

Thanks

Highlighted
MVP & Luminary
MVP & Luminary

Re: Does Qlik Store data Internally?

With section access you could limit either rows as well as columns - to control the columns you need to exclude them within OMIT.

- Marcus

View solution in original post

Highlighted
Digital Support
Digital Support

Re: Does Qlik Store data Internally?

In addition to Marcus' comments, here are some links that will be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

Those should come in handy while working upon things.  There is also the Scrambling tab in the Settings\Document Properties of the app that contains the sensitive data where you can scramble the values, but that is going to do so for everyone, so if some folks need to see it, that will not work.  The OMIT system field in Section Access should be the way to go per Marcus' comments.  

Be sure to give Marcus credit as well by using the Accept as Solution button on his post(s) that helped, you can mark more than one response as the solution if multiple ones did help.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.