Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist
Author

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

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
Not applicable

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

stantrolav
Partner - Creator II
Partner - Creator II

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
Creator III
Creator III

‌can you plz guide on decrypt logic