Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-10-04 04:59 PM

Decrypting data in Qlikview

Hi Gurus,

I just has been asked by my Boss to find out if there is a way to decrypt data in Qlikview if it is already encrypted in a DB.

We are using SQL Server 2008 R2 as souce DB for our reports.

Is there a way to decrypting data in Qlikview?

Many thanks in advacne.

TA

1,019 Views
0 Likes
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2012-10-05 03:51 AM

If you know the exact encryption algorithm of the encryption you might be able to write code in qlikview te decrypt it. I strongly recommend against this. Use the database features to enable Qlikview access to unencrypted data through views or stored procedures. You can use database security features to make sure that access to such views/sp's is restricted so only legitimate access for extraction purposes for qlikview is allowed.


talk is cheap, supply exceeds demand
366 Views
0 Likes