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

검토됨 한 달 전

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

관련 콘텐츠