Hello and welcome to the ApexSQL Mask general overview video. ApexSQL Mask is a standalone application capable of masking sensitive SQL server data. Besides masking sensitive data, the application offers the following features. Automate sensitive data classification, mask data at column or row level, view Full database masking job summary, view before and after mass data, create and edit sensitive data masks, import and export mask and filters, and much more. Let's get started.
By starting the application, the Connect to SQL Server window will be shown, where first will be set the SQL server from the server dropdown list. After that, select the authentication type. And for this video, the Windows authentication will be selected. Choosing the database from the database dropdown list is the next step. When all is set in the Connect to SQL Server window, click on the Connect button.
ApexSQL Mask will be connected to the selected database. And the view will migrate to the main window of the application. By default, on the left side of the main window in the grid panel, the automatically classified columns that contain sensitive data with intended masks will be shown. By clicking on one of the table of columns in the grid panel on the right side of the main window from the preview panel can be seen how data looks before and after masking.
Besides automatically listed table columns, ApexSQL Mask can mask the data of any column in the selected database. By clicking on the All columns button in the Home tab, all columns in the database will be listed in the Grid panel. Let's show on one table column how the data will be masked. First, we will check the listed table column in the main grid. To add any of the predefined masks to the selected column, right-click on it and choose the Add mask command, then Substitution, where all predefined masks will be listed.
ApexSQL Mask, besides already predefined masks, provides the ability to create a new mask or to edit and delete the existing masks. To do any of this, click on the Manage button from the Home tab. The Manage masks window will be opened, where we'll be presented all masks that are applied to the selected database. To create a new mask in the Manage mask window, first step is to choose the type of mask.
Two mask types are available-- Substitution mask type, that with using generators replace data entirely, and Redaction mask type, that uses specific value or part of it and replaces it with custom value. In this video, we will explain how to create the Substitution mask type. When the type of mask is selected, the next step is to click on the New button. The Create substitution mask window will be opened.
From the level section of the Create substitution mask window, can be chosen the column or row level of masking. We will choose the column level masking. In the Name field, a name for the new mask will be written. The description field is optional. But we will add a description for our mask. The next step is to choose the generator that defines which data will replace the original data in the column.
In the Type dropdown list, can be found next types of the generators-- predefined, use original, random, specific value, regular expression, SQL script, external source. We will use the specific value generator type for masking original data. Choose the value option type in any character. In our case, it will be x. And all data will be hidden with the character. When all is set, click the Apply button.
The Apply to columns window will be opened. Here, the columns from the loaded database tables that data masking will be done must be chosen. From the available section, select the column for masking and click the right blue arrow to move wanted column to the applied section on which the newly created mask will be applied. Click the OK button will close the window and confirm the change.
The view will go back to the Create substitution mask window. Click the OK button, and the newly created mask will be shown in the Manage masks window. The Manage masks window will be closed by clicking on the OK button. And the primary grid of ApexSQL Mask will appear. When the newly masked column is clicked in the grid panel, in the preview window can be seen the comparison of the original data and the mask data.
When everything is set to proceed further, click the Process button from the Home tab. The Process mask window will be shown with the job summary data, where all the summary details and warnings can be seen. The Process masks window offers two options. By choosing the update database option, mask data will be updated directly into the SQL database. But if the Create script option is selected, ApexSQL mask will create the script. And the script can be run whenever is needed.
Let's click the Update database option for this video. When the update process is finished, the View results window will be shown with the complete summary of how many masks are implemented and the number of the affected columns. Also, the View result window offers the possibility to create report and to export results. Let's review how to create a report. To create a report, click the Create report button.
In the Browse for folder window, choose the location where the report will be saved and click the OK button. The report will be saved in the HTML extension. And it will look like this, with all filters and substitution mask rules and a number of mask columns. Thanks for watching. For more information, please visit apexsql.com.