The following patch will allow masking of a uniqueidentifier column in SQL Server: FastDataMasker-184.108.40.206.zip
If you have this issue and need the mentioned patch, please open a Support case and request this patch or newer. If you are installing a newer GA version after September 7, 2017, please verify with Support that this patch is included in that GA version.
There are ONLY 2 ways you can mask this type of column in SQL Server
- Use FDM function GUID
- Use function SQLFUNCTION and newid() as the parameter one value
Any other function will result in SQL Server rejecting the value as an invalid identifier.
If you have the same values in MYSQL and need consistent masking you will have to use GUID and cross reference in both masks.
In both cases, you will have to connect to the same cross reference table.
Another thing to be aware of, if you have the table to be masked open in a SQL window in Datamaker, it often will lock the table causing FDM to hang.
Close the SQL window to allow FDM to resume masking.