How to mask PII data using DMS without adding a column

0

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?

質問済み 4ヶ月前237ビュー
1回答
0

Hi,

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

Best,

Didier

profile pictureAWS
エキスパート
回答済み 4ヶ月前
profile picture
エキスパート
レビュー済み 1ヶ月前
  • 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?

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ