How to export masked data to the external data source

Applies to

ApexSQL Mask


This article explains how to export masked data to the external data source using this data masking tool.


Sensitive data is data that contains critical and private information, and that information must be protected against unauthorized access. Sometimes database developers need to present

information from specified SQL databases with internal or external stakeholders. If that selected SQL database contains sensitive data, one of the options to protect that data is to mask them.

ApexSQL Mask is a data masking tool that can mask sensitive data and export it to an external data source.

Export mask data

First, on the opening of the data masking tool, it will appear the Connect to SQL Server window, where will be selected the SQL Server, type of the Authentication, and targeted Database. When all parameters are selected, click on the Connect button to connect ApexSQL Mask to the selected database:

Connect to SQL Server window

The main grid with automatically chosen columns that have sensitive data will be shown. In addition to the automatically selected columns, the Mask type and Mask sub-type, that will be used for masking data from those columns, will be shown as well:

Mask type and sub-type in the Main grid of this data masking tool

Besides automatically added columns, data for any other columns can be masked for the selected database. All other non-masked columns from the selected database will be shown when the All columns button from the Home tab in the main grid is clicked:

The main grid for All columns

When columns are selected and masked, click on the Export button from the Home tab, to export the masked data to external data sources:

The Export button in the Home tab of this data masking toll

When the Export button has been clicked, the drop-down menu will appear, where the user can choose a type of external data source in which a masked data will be exported. The masked sensitive data can be exported in CSV, Excel, JSON, XML external data source files:

The Export drop-down menu

Export to CSV file type

When clicked on the CSV (Comma Separated Values) option, it will open the CSV window, from which can be checked the following:

  • Separator – values in the CSV file would be separated with Tab, Space, Coma or Custom signs
  • Table – whether in the CSV file will include a table header or not
  • Export to – whether CSV files will be exported in the Separate files or One file

The CSV window

Export to Excel file type

If masked data is exported in the Excel file type, the Excel window will be opened, where can be selected if shipped documents will include Table header or not and whether data will be exported in One or Separate files:

The Excel window

Export to JSON file type

If the JSON external data source is chosen, from JSON window which will appear, the exported file can be exported as an array document structure or not:

The JSON window

Export to XML file type

When exporting a masked data in the XML external data source, in the XML window can be added optimal value for Namespace or not:

The XML window

When everything is set, no matter which external data source is chosen, click on the Export button, and the masked data will be exported to the chosen external data source:

Export button with this data masking tool will exported masked data in the external source

That will open the Exported mask window, where the destination of the exported file can be chosen and to save it on the desired location click the Save button:

Exported masked data window