Skip to Content
Jul 06, 2018 at 05:15 PM

SAP's support for "Always Encrypted" functionality offered by MS SQL 2016 Server


Hello Community,

We are trying to explore options to protect sensitive data in SAP especially customer SSN#s. We are inclined to use column based data encryption to meet the requirement while having minimal impact to system performance. I have found OSS Note# 1380493 (SQL Server Transparent Data Encryption (TDE)) that talks about TDE (Transparent Data Encryption) in SQL Server. However, the document is from 2009 and as per the note, SAP did not support column based encryption. I did find a question in the community "SQL 2016 Always Encrypted Columns" that talks about utilization of "Always Encrypted" functionality in MS SQL 2016.We currently are in the process of upgrading to MS SQL 2016 Server and would like to utilize this functionality to protect sensitive information. Is there a note or some documentation that SAP provides on its support for data encryption in MS SQL 2016 Server?

Thanks for your valuable response in advance!

Best Regards,

Vikas Devrani