web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Masking sensible data for AX 2012 R2

(0) ShareShare
ReportReport
Posted on by

Hi all of you, I am just thinking over how to deal with all the data that our AX developers on its devboxes playing with. I would like to mask some columns (pan card, NationalIdCar, names..

Whenever we update a non productive environment with PROD data we have this issue.

At the same time I entirely reject TDE strategy.

Any hint or comment would be greatly appreciated!

 

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    302,698 Super User 2026 Season 1 on at

    Hi Enric,

    It would be possible to write a script that will scramble the data. At one of our customers they replaced names with record IDs or other coding like customer account numbers.

  • Suggested answer
    Martin Dráb Profile Picture
    238,601 Most Valuable Professional on at

    I agree with changing the data, rather then trying to keep and hide it.

    One of the easiest way is to run a SQL script as part of data migrations with Test Data Transfer Tool.

    Transparent Data Encryption (TDE) couldn't possibly help; it's a different kind of protection.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Volodya Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Volodya 2

#2
tgudwanski Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. tgudwanski 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans