When using an encrypted password (created from the Javelin menu) it is shown decrypted/plain text in the logfile when used in a Javelin SQL Server element.
The reason we use SQL Server encryption instead of the ENCRYPTXREF is that the performance of this FDM function is terrible.
it takes approximately 5 minutes to mask one value in 10,000 records.
With tables exceeding millions of records this would take days.
Using the EncryptByPassphrase function in theSQL server solves this for us.
The only problem now is that the password is shown.
Test Data Manager
Fast Data Masker
As per development, this is working as designed.
Logging is part of the Microsoft framework used by Javelin and there is nothing that can be done from a Microsoft perspective.