Dynamics Community Forum Thread Details

Data Export Service

Hi All -

I am planning to use Data Export Service to replicate Dynamics data to Azure SQL database for some offline/reporting purposes. The method is outlined in below article. Following this article i was able to make it work without any issue.

https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database

Few of my entities has PII data and as per my companies security guide lines i have to make sure data is encrypted at rest and transit along with always encrypted.

I know encryption at rest (TDE) is default feature of Azure SQL however i still have below two question

Can i enable always encryption (column level encryption) and still do data replication
Can i change my connection string to include Encrypt=True and TrustServerCertificate=False in connection string in key vault and it will do encryption in transit as it say in MSFT docs below ?

https://docs.microsoft.com/en-us/azure/azure-sql/database/security-overview#transport-layer-security-encryption-in-transit

Any help around this will be very helpful.

Quick Links