Handling PII data using DMS.

Question

How to handle or mask PII data using AWS DMS only at minimal cost?

I am replicating data from source db to target db using AWS DMS and SQL Developer. Replicating data from Non-Prod to Prod AWS accounts.
We are replicating large number of data and for this I need an approach which is also cost effective.

Accepted Answer

With transformation mapping rules : https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/, you can replicate data as masked by encoding it in the dms replicator before it reaches the target.

Answer

Hi,

DMS offers masking features in the service: see Antonio's answer.

But, you may also need more sophisticated architectures with an intermediate step where you can apply more sophisticated techniques than what DMS provides out of the box. This blog post is then very interesting: https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/

Best,

Didier

Handling PII data using DMS.

Relevant content