This directory contains a number of scripts to help you integrate Sql Data Catalog with Data Masker.

Tag a column for masking.ps1

This Powershell demonstrates how you'd tag a column of the AdventureWorks database so that it will be picked up by the following script.

Generate masking set from catalog.ps1

This Powershell script takes as input a masking set definition file.

$inputMaskingSetPath = "AdventureWorks.DMSMaskSet"

It will load this file, and then process the columns of the given instance and database

$instanceName = 'sql-server1.domain.com'
$databaseName = 'AdventureWorks'

to generate a masking set which will be saved into the output file.

$outputMaskingSetPath = "AdventureWorks Generated.DMSMaskSet"

DataMaskerHelpers.ps1

The DataMaskerHelpers.ps1 file contains some utility functions that the other scripts use.