Fixes

• Fixed bug in Select Distinct Values query when column names contain spaces.
• Fixed a bug in applying the "PostalCode" column template.

Features

• New command line option: DataMaskerCmdLine.exe column-template build-mapping-file
  • Integrates with your SQL Data Catalog Taxonomy.
  • Produces a column-template mapping file that you can pass into the build command.
  • It is now possible to fully automate masking a database, based on the hard work you have put into cataloging your SQL database estate.

Fixes

• Fixed bug in generation of South African ID Numbers dataset.

Features

• Added an option to the Data Masker build CommandLine (DataMaskerCmdLine.exe build --mapping-file) to consume a column-template-mapping file to generate default rules.

Fixes

• Recalculate ranges on a Range Splitter will prompt for password, if necessary.
• Correctly reset the form state after testing the login on the password prompt form.
• Improved the format of the log file.
• Fixed a bug where some datasets would try to use a null value in a NOT NULL column.

Fixes

• Internal improvements.

Fixes

• Fixed the `--schema` option when running the `DataMaskerCmdLine.exe build using-windows-auth...` command.

Features

• Removed the short-aliases for the command-line options.
• It is now possible to specify which schemas will be included in the masking set using the build command on the command-line using the --schema (or -s) option, e.g DataMaskerCmdLine.exe build ... -s dbo -s orders --schema sales.

Features

• Added a new command-line option to build an empty masking set. Run DataMaskerCmdLine.exe build --help for more information.

Fixes

• Fixed an issue where correlated datasets would generate data too large for the column.

Fixes

• Fix an issue retrieving the row counts from large tables.

Fixes

• Improve error message when a table being masked does not have a primary key.

Features

• Allow the user control over whether the interim reports from the command line writes to the log file.

Fixes

• Fixed an issue where Data Masker doesn't show any activity in the Run Statistics tab when running the Rules.

Fixes

• Fixed an issue where attempting to connect to Oracle in a cross-database rule throws an exception.

Fixes

• Fixed an issue where cross-database command rules would timeout after 30 seconds.

Fixes

• Fixed an issue where cloning rule controllers would clone the rule controller twice.

Fixes

• Fixed an issue where updating columns in the primary key could appear successful but no rows being masked.

Fixes

• Fixed an issue where after refreshing the list of datasets the rule forms did not see the new datasets.

Fixes

• Fixed an error when importing the masking plan from csv.

Fixes

• Login substitutions in PARFILEs are parsed with a more robust parser. This permits valid substitutions that previously failed to parse.

Fixes

• Resolves an issue causing Data Masker to not open.

Features

• Generating PARFILEs from the UI command line (-G) will now prompt for where it should be saved.
• Added a link to command line automation instructions.
• Cross database command rules targeting Oracle will more robustly split up multiple statements separated by ; or /

Fixes

• Fixed an issue using V7's performance mode when trying to use certain data sets to mask part of a row's ID.

Features

• Deprecation of UI command line
  • Using DataMasker.exe to automate masking sets runs has been removed in 7.0.0. To automate running of masking sets use DataMaskerCmdLine.exe instead.
  • To aid migration, Data Masker 7.0.0 includes an additional command line flag (-G) to DataMasker.exe to generate PARFILEs suitable for DataMaskerCmdLine.exe.
• Enhanced performance of masking rules. This replaces the V7 performance beta, and can be disabled by using legacy performance mode.
• Users can now select a default commit frequency when configuring Search and Replace, Shuffle, and Row Internal rules.

Fixes

• Fixed an issue where CLR triggers are not downloaded.