DataVeil 4.10 Released
DataVeil version 4.10 has been released and is available for download at https://www.dataveil.com/my-downloads/
NEW: Partitioning for DataSets
A new option has been implemented that enables partitioning on DataSets.
This means that a user can easily define which database column values must match with CSV column values in order for the CSV rows to be candidates for selection.
For example, suppose you have a CSV file with validated custom street addresses across thousands of different postal (ZIP) codes. Furthermore, suppose that there are 100 different addresses for each postal code. This means that only those 100 rows from the hundreds of thousands of other rows in the CSV file, with a matching postal/ZIP code, can be considered as a valid masked value for a given database row.
This is now very easily achieved.
First, select the CSV column in the DataSet definition that is to be partitioned.
Next, in the DataSet mask, simply select which database column is to match with the CSV partition column. You can even define a default partition in case a database partition value is not found in the CSV file.
That's all there is to it!
You can define multiple partitions just as easily.
For example, suppose you have street addresses and postal codes from different countries, then you could define 2 partition columns: Country and PostalCode.
You can even have the database partition columns in different tables to the table being masked - just create the relevant Joins in the DataSet mask's Join option tab.
For further details and detailed examples, please refer to DataSet Mask - Partitioned.
Other Changes
There are several other minor updates and fixes:
- Oracle XML mask now supports XML docs saved in the BLOB data type
- DataSet relative paths can now be above its home directory
- Project files are now saved more deterministically.
For details, please refer to the release notes using the Version History link from the Downloads page.