Data classification filters
How many pre-existing sensitive data classification filters ship with the product?
There are 59 pre-existing sensitive data classification filters.
Can filters have more than one set of criteria for finding potentially sensitive columns?
Yes, it is possible to find columns by name or field value with regex or length.
If so, can these criteria be configured to be AND or OR?
Yes, filters can have more than one criteria.
Can I ignore certain columns, so they aren't treated as sensitive?
Yes, there is a possibility to check columns that will be classified or just uncheck the ones that are not considered as classified. These will be considered as “ignored”.
How can I tell if a column has been classified?
Classified columns have a red dot icon in the bottom-right corner. Also, there is the Classified column that will display the applied mask:
Can I create and/or modify data classification filters?
Yes, you can create and modify your custom filters.
If so, can I share my custom filters with my team via export/importing?
Yes, there are options to import and export a filter list.
Does column name search support wildcards?
Yes, additionally you can add more than one value for a column name search.
Does field value search support Regular expressions?
Can I see a summary of sensitive data classification results?
Yes, at the end of the data masking process result dialog is shown.
Can I create a report of sensitive data classification results?
Yes, it is possible after the data masking process is completed.
Can I see the particular filter that classified the column?
Yes, in the main grid after classification is finished, you have information on which filter was used to classify specific columns.
You can access all filters from the toolbar menu by clicking the Filter button in the Home tab which will take you to the Manage data classification filters window.
Can I see all of the columns that a particular filter classified?
Yes, you can filter the main grid by using a filter option in the header of the Classified column and choose to see only columns that match the wanted filter.
Can I manually classify a column that wasn't classified?
Yes, every column can be manually classified using check boxes next to the column name in the main grid.
Can filters be individually enabled/disabled?
Yes, by using the Check/uncheck option in the Manage data classification filters window.
Masks
What is the Sensitive data mask?
Sensitive data mask is functionality that creates a structurally similar but inauthentic version of an organization's data that can be used for purposes such as software testing and user training. The purpose is to protect the actual data while having a functional substitute for occasions when the real data is not required.
What types of masks are there?
There are the Substitution and Redaction mask types.
What is the Substitution mask?
Substitution is a mask type that uses generators to replace data entirely.
What is the Redaction mask?
Redaction is a mask type that uses specific value or part of it and replace it with custom value.
What types of substitution masks are there?
Currently, there are seven substitution masks types: Use original, Random, Predefined, Regular expression, Specific value, SQL script, and External sources.
Can data be masked at the individual row level?
Yes, a specific row can be masked with substitution mask type when row-level is chosen or using a reduction mask.
Can I share masks I've created with my team by export/import?
Yes, under the Manage mask window there are import and export buttons that can be used for sharing masks.
Can I see all the columns that a particular mask has been assigned to?
Yes, the main grid can be filtered by using the filter option in the header of the Mask name column and choose to see only masks which are wanted to filter.
Can I assign a mask to more than one column?
Yes, in the "Apply to masks" window can be chosen the columns on which will be applied one mask
Can I process a column with more than one mask?
No, since a column can only have one mask it is not possible to process a column with more than one mask.
Can I preview column data before and after masking?
Yes, just by selecting the column from the list in the main grid, the Preview window will display column data before and after masking.
Data generators
What is a data generator?
A data generator is a built-in functionality used for generating synthetic but real-world data in columns e.g., City names. ApexSQL Mask offers over 200 pre-defined generators, including things like first and last names, street addresses, city and country names and special lists like auto-manufacturers, movie titles, etc.
How do generators relate to masks?
Masks can use generators to replace original data with new realistic data.
How many built-in generators?
There are over 200 built-in generators.
Can I create/modify my generators/sub-generators?
No, you cannot create generators, but you can modify the certain type of generators like Regular expression, Specific value, Predefined, Use original, External source, and SQL script. The Random generator cannot be modified.
Auto-assignment of masks
How does the app. automatically apply filters to some columns?
The application is using keywords from filters and scans through all column names.
Can auto-assignment of masks behavior be modified e.g. turned on/off or otherwise customized?
Yes, this can be turned off in the Options window, under the General tab by unchecking “Automatically scan the database for sensitive data” option.
Can generators be associated with a Data classification filter to automatically apply masks to columns it positively classifies?
Processing
Does ApexSQL Mask modify an existing database and/or create a modification script that I can run later?
Yes, both options are available.
Can I automate the process of data masking?
Yes, ApexSQL Mask supports CLI both batch and PowerShell.
Can I add a mask to a column that hasn't been classified?
Yes, a user can manually set columns to be classified.
Can I see a summary of the results from processing masks?
Yes, after the masking process is completed, the result dialog will appear, and a user can able to see the summary, create reports, and export results.
Options
Does ApexSQL Mask recognize the Check constraints?
Yes, ApexSQL Mask recognizes the Check constraints and can pre-emptively disable them.
