Support SQL Database Always Encrypted sources or destinations
With the recent increase with privacy and security concerns, namely GDPR, the need for using Always Encrypted on SQL Server or Azure SQL Database is also increasing. The problem is that in the moment that we enable this security features in SQL we can't use ADF anymore as the Dara Flow orchestration. Without this feature more secure enterprise scenarios are being left out.
Nuno Centeno
shared this idea
4 comments
-
Yingqin Gu
commented
This feature is now supported in ADF: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database#using-always-encrypted
-
Inder Rana
commented
I just documented this workaround which allows using Always Encrypted Azure SQL Database column data in ADF or Power BI. Maybe this will be helpful so sharing the link - https://medium.com/@isinghrana/access-azure-sql-always-encrypted-data-in-power-bi-reports-using-managed-identity-and-odbc-9ed5c54a2cc9
-
Jukka Lahtinen
commented
-
Anonymous
commented
Add a feature to copy always encrypted column data to always encrypted column of another Azure SQL database