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

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

Fri, 05 Aug 2016 19:52:12 GMT

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.

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

Fri, 05 Aug 2016 19:52:56 GMT

Maybe Rob's suggestion to use Windows File Encryption?

He says it is also "transparent".

Fri, 05 Aug 2016 22:37:54 GMT

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.