Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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?

Argomenti
Migrazione e modernizzazione
Tag
Servizio di migrazione dei database AWS
Lingua
English
Abhijeet
posta 4 mesi fa237 visualizzazioni
1 Risposta
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
ESPERTO
Didier_Durand
con risposta 4 mesi fa
profile picture
ESPERTO
Giovanni Lauria
verificato un mese fa
  • Abhijeet
    4 mesi fa

    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?

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente