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 数据库迁移服务

语言

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

相关内容