Create masked data for software development, testing, training, and data mining. You can maintain data relationships in the masked data and maintain referential integrity between database tables.

The Data Masking transformation provides masking rules based on the source datatype and masking technique that you configure for a column. For strings, you can restrict which characters in a string to replace. You can restrict which characters to apply in a mask. For numbers and dates, you can provide a range of numbers for the masked data. You can configure a range that is a fixed or percentage variance from the original number. The Data Integration Service replaces characters based on the locale that you configure for the transformation.