Qlik Community

Qlik Server Side Extensions Discussions

Discussion Board for collaboration on Server-Side Extensions and Advanced Analytics Integration.

danielrozental
Honored Contributor II

AAI for Encrypting/Decrypting values

Hi all, I'm looking into using this new functionality as a way to encrypt/decrypt values in QlikView script/front end. It's probably will probably have better performance than using QlikView macros.

Any ideas or warnings you can think about on this?

Thanks

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: AAI for Encrypting/Decrypting values

I have created an example to do this in Python and found that on anything larger than 10,000 rows of data that the performance is too slow for this use case. I will be publishing this to my github account so that you can review it and see if you can make it any better.

Github Example: https://github.com/newmans99/QlikPrivacyIntegration

Just updated the github site (Sept 7, 11:51AM EST), please note it is still a Work In Progress but it is viewable. I will be continuing to improve it over the next few days.

8 Replies

Re: AAI for Encrypting/Decrypting values

Why you want to encrypt/decry-pt values?

danielrozental
Honored Contributor II

Re: AAI for Encrypting/Decrypting values

It's very sensible information.

Re: AAI for Encrypting/Decrypting values

Would you provide more information about real data?

danielrozental
Honored Contributor II

Re: AAI for Encrypting/Decrypting values

Let's say it's something like wages or credit card numbers. Information you don't want everyone to have access to it or have it stored somewhere without being encrypted.

Re: AAI for Encrypting/Decrypting values

Sure, Here let's think we have 30 USERS using the Dashboard and If we need to encrypt the data for specific USER of course there must Section Access involved because we need to hide some information for specific users. and may be if we need to show like as always CC has 16 digit number. Why can't we hide some thing like 1234-XXXX-XXXX-5678. So, Then i don't think this information useful to users and we can hide some sequence numbers to the USERS

And, As usual we can barring the information to using decry-pt and/or use Hidden script in script level but UI we need to custom for that..

Does this helps to you? If not may be i would ask some information related data set. No need to provide secure data as threatened bug

bvk
Contributor II

Re: AAI for Encrypting/Decrypting values

Hi Daniel,

Yes, this is a good use-case for SSE/AAI I created a proof of concept based on Java to do regular expressions. You can use the same methodology to do encryption/decryption.

GitHub - wbvreeuwijk/qs-aai-java: Example implementation of a Java based Server Side Extension

Regards,

Bas.

Employee
Employee

Re: AAI for Encrypting/Decrypting values

I have created an example to do this in Python and found that on anything larger than 10,000 rows of data that the performance is too slow for this use case. I will be publishing this to my github account so that you can review it and see if you can make it any better.

Github Example: https://github.com/newmans99/QlikPrivacyIntegration

Just updated the github site (Sept 7, 11:51AM EST), please note it is still a Work In Progress but it is viewable. I will be continuing to improve it over the next few days.

danielrozental
Honored Contributor II

Re: AAI for Encrypting/Decrypting values

Thanks a lot guys.

Community Browser