Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avoid unencrypted file on-disk: Loading file from database; or loading encrypted data from disk

I have XML files saved on my computer.

I have a load script which can load the correct data from the XML File.

The data could be sensitive data, and certain regulations prevent me from saving XML File to disk, unencrypted.

  1. I can save this XML as a varbinary(max) in SQL Server, stored with FILESTREAM enabled,  and TDE enabled, (so the data is encrypted-at-rest. ) SQL will transparently "decrypt" when we make a query. However, can I load data from a file stored in a database?
    1. Note I am not  asking if I can load data from a database: of course I can.
    2. I am asking if I can treat the contents of a database cell, as if it were the contents of a file -- thus avoiding any sensitive data written-to-disk.
  2. Alternatively I suppose I could look into encrypting the data on-disk; but will Qlikview know how to decrypt?
    1. Any suggestions here?
    2. Note I am not asking how to encrypt/decrypt QVDs: I don't have a QVD yet.

Thank you.

2 Replies
Not applicable
Author

Maybe Rob's suggestion to use Windows File Encryption?

He says it is also "transparent".

https://community.qlik.com/thread/154015

Encrypting File System - Wikipedia, the free encyclopedia

Not applicable
Author

However, I'm still interested to know whether I can read files from a database;

I'd rather not configure disk encryption --

I discovered there are alternatives to Windows EFS Encryption:

3rd Party Encryption tools like Bitlocker and Vormetric, etc.