Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

alexis
Contributor III

Decryption in Qlik Sense

Hi all

I have a serious issue and I am at a loss as to how to deal with this.

I have a client whose data is stored in an AES encrypted form and we need to read it. We have a number of challenges.

a) The very few references to Encryption/Decryption are in the form of JScript or VBScript functions that obviously work in Qlikview but not in Sense. Any idea how these functions can be incorporated in Sense in view of the lack of support for macros in Qlik Sense

b) What do people do as an alternative to encryption/decryption to deal with very sensitive data? We may be able to convince the client to remove the encryption ONLY if we can offer them a safe/safer method.

You assistance would be HUGELY appreciated.

Alexis

5 Replies
alexis
Contributor III

Re: Decryption in Qlik Sense

Apologies to be re-posting this but I am desperate for your views and ideas.

The client needs to be able to read his encrypted data and decrypt it once it gets processed by Qlik Sense.

Any ideas or suggestions would be very welcome

Alexis

Not applicable

Re: Decryption in Qlik Sense

Hi Alexis,

We are having the same situation for a client, and I was wondering if you were able to figure out a process for decryption. If you have implemented a process to decrypt the data after it's loaded please share.

Thanks

nauzaddoctor
New Contributor

Re: Decryption in Qlik Sense

+1, we're looking to solve the same problem but haven't got an answer as yet

stantrolav
Contributor II

Re: Decryption in Qlik Sense

You can run external file during reload with EXECUTE function. Run your decription Decrypt.vbs file by lines in script^

EXECUTE CMD.exe /c "C:\Test\Decrypt.vbs".

Of course for this option you should make some adjustments in QMC like disabling Standard Mode and open security for runing such files in Settings.ini file.

After vbs macro completed it must create decrypted table. Load it into Qlik. After loading in, delete it.

1. File on server:

"C:\ProgramData\Qlik\Sense\Engine\Settings.ini"

->>>>Create it with text.

[Settings 7]

OverrideScriptSecurity=1

2. Disabling Standard Mode: Disabling standard mode ‒ Qlik Sense

I appreciate if you give me points for this answer by likes.

mangalsk
Contributor III

Re: Decryption in Qlik Sense

‌can you plz guide on decrypt logic

Community Browser