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.
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
Add a feature to copy always encrypted column data to always encrypted column of another Azure SQL database