Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Data Architectures

Hi,

With reference to this doc - http://community.qlik.com/docs/DOC-1952

Has anyone tried N-tiers data architecture in your developments? or starting a QlikMart?

I'm trying to collect some info and ideas on how are you guys building your data architectures or ETL, concerns, best practices, etc...

Any thoughts are welcome.

Thanks.

13 Replies
techvarun
Specialist II
Specialist II

awesome thread

Regards

Not applicable
Author

Hi John,

Are you using Section Access or are you distributing based on "Reduction Method" and creating new QVW?

I used to use the latter, it took very long, so i changed to Section Access and only single QVW is distributed.

johnw
Champion III
Champion III

We use the reduction method with new QVW. I don't think any of our applications use section access. Most applications have only one version, and we just control who it is distributed to. But we do have at least one application that distributes based on user ID, but I think it's small enough that it doesn't have problems. We also have a few cases where we remove information by associating it with a flag value, and then reducing based on the value in the flag. Some people get the reduced version, while others get the full version. For instance, pricing is sensitive data. Our shipping application includes the proceeds for the shipments, and the proceeds shows up in separate reports on separate tabs. But those tabs disappear when the flag isn't set, and so does all of the data associated with it, so the proceeds data is not there at all, not just not easily accessible. So one version has the tabs and data, one does not. The tabs are technically still there, just hidden, but they won't display anything useful since the underlying data is missing.

Anyway, I'm not saying any of this is the right or wrong way to do anything; it's just what we're doing. Unlike many shops, I don't think we set out with a good conception of how we wanted to manage security and the distribution of information. It just kind of fell together over time based on specific needs. We're probably not the people to copy when it comes to security and distribution.

Not applicable
Author

nicksatch‌ I am trying to see the document but it is saying unauthorized access.

Thanks