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?

demandé il y a 4 mois238 vues
1 réponse
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
répondu il y a 4 mois
profile picture
EXPERT
vérifié il y a un mois
  • 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?

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions