topic Re: Decrypt Data from DES Block Cipher Enyryption in QlikView

Decrypt Data from DES Block Cipher Enyryption

Mon, 01 Feb 2016 14:53:30 GMT

Hello

I have encrypted Data from a Database.

The Encyrption Method is "DES Block Cipher"

e.g. a encryped number is looking like this: 1q4zxq1phbha9

Is there any function in Qlikview for decrypt such Data?

I also searched for vbscript Macros but didn´t find any working snippets.

Thank you for any advise

Re: Decrypt Data from DES Block Cipher Enyryption

Gysbert_Wassenaar — Mon, 01 Feb 2016 16:57:42 GMT

No, there isn't. You can try implementing one yourself in either vbscript or javascript. For example using crypto-js

Re: Decrypt Data from DES Block Cipher Enyryption

Tue, 02 Feb 2016 08:26:19 GMT

Hello Dan,

thank you for your apply.

In your sample App you only have the AES encryption method, am i right?

Re: Decrypt Data from DES Block Cipher Enyryption

Tue, 02 Feb 2016 16:17:45 GMT

Thank you Dan,

This function uses the method 3DES

But in my Database I have DES method.

So I used:

function encryptDES(value, key) {

return CryptoJS.DES.encrypt(value, key).toString();

}

function decryptDES(value, key) {

return CryptoJS.DES.decrypt(value, key).toString(CryptoJS.enc.Utf8);

}

But now my Problem is, with this Method I´m getting way longer encrypted numbers.

In my Database the encrypted Numbers only have 13 characters.

Re: Decrypt Data from DES Block Cipher Enyryption

Thu, 04 Feb 2016 08:10:50 GMT

Hey Dan,

The Numbers in my Database are encrypted to 13 characters.

With the method from above, i get longer encryption.

Not the number in the Database has 13 digits.

Re: Decrypt Data from DES Block Cipher Enyryption

Thu, 04 Feb 2016 19:03:42 GMT

I'm sorry confusing you.

My data is already encrypted. I Know its encrypted with DES block cipher.

Now I want to decrypt it. With the code from above it doesn't work. Because

the entries are all only 13 chars long.

When I use the encrypt and decrypt method with a hard coded number it's

working. like: encrypt(94175, key) But then I get a longer encryption than

13 chars.

Hope it makes it clear

Am 04.02.2016 19:51 schrieb "Dan Greeberg" <qcwebmaster@qlikview.com>:

Re: Decrypt Data from DES Block Cipher Enyryption

Mon, 08 Feb 2016 10:55:42 GMT

Thank you,

I'm getting different results as I'm expecting. Is there any possibility to adjust the code from crypto-js?