For the Json column, I selected the Json column I wanted and selected Format Encrypt, but FDM replaced all of the rows with the same value [\"$[0]['Number']\"] instead of format encrypting the last 4 digits of the number.
[{"TypeId":11,"LocalizedType":"Cadastro de Pessoas Físicas","EnglishType":"Registration of Individuals","Number":"
[\"$[0]['Number']\"]","IssuanceDate":"","ExpirationDate":"","AddedBy":"genesis","DateAdded":"2017-06-01T15:53:41.517"}]
Original Message:
Sent: 01-28-2020 11:33 AM
From: Scott Schmitz
Subject: SQL Server Temporal Tables
Hi Don,
The answer to both is "Yes". I was able to demonstrate this on the AdventureWorks database in SQLServer 2016. Ensure you have the latest FDM, request access to the patches from Support.
Original Message:
Sent: 01-17-2020 09:37 AM
From: Don Pastorius
Subject: SQL Server Temporal Tables
2 questions:
1. Can FDM scrub PII data in a Sql Server Temporal tables?
2. Can FDM scrub PII in JSON stored in a column in Sql Server?