How to mask PII data using DMS without adding a column

I am replicating data from source db to target db within two different AWS accounts. I want to mask and replicate the column data to target db during ongoing replication in same column which contains PII data. I am using transformation rules for this but unable to do it. Because I don't want to add new column and delete the old one which contains PII data. Can anyone suggest me how to achieve this?

主題

遷移與現代化

標籤

AWS Database Migration Service

語言

English

Abhijeet

已提問 4 個月前檢視次數 237 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

Hi,

this blog post describes a solution to your need: https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/

Best,

Didier

專家

Didier_Durand

已回答 4 個月前

專家

Giovanni Lauria

已審閱 1 個月前

Abhijeet
4 個月前
Hi Didier, Thanks for answering my question but this blog post is not helping me to achieve my goal. Because it doesn't have any approach to mask the replicated column data in real time in same column. Do you have any other solution for this?

How to mask PII data using DMS without adding a column

相關內容