Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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

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

Contributor
Contributor

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

Partner
Partner

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.

Creator III
Creator III

‌can you plz guide on decrypt logic