Decryption in Qlik Sense

[alexis]

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

[alexis]

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

[#3]

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

[Anonymous]

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

[stantrolav]

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]

‌can you plz guide on decrypt logic