By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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?

Topics
Migration & Modernization
Tags
AWS Database Migration Service
Language
English
Abhijeet
asked 3 months ago208 views
1 Answer
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
EXPERT
Didier_Durand
answered 3 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
  • Abhijeet
    3 months ago

    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?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content