Release information

Description

Features:

• Added support for Microsoft Entra ID authentication for SQL Server / Azure SQL 

• Changed from using ODBC to JDBC drivers for SQL Server connections

• Added option to enter JDBC / ADO.NET properties for SQL Server connections

• Updated the SaveDDL powershell script to support Entra ID authentication

Bugfixes:

• Fixed an issue that prevents opening a .dpv file directly from the explorer

When generating Runtime applications Runtime 4.10 or higher is recommended. 

Date

08 Jul 2024

Description

Features:

• Added option to make scripts executable per scenario (masking vs generation)

• Added option to generate runtime package using command line 

• Updated SQL Server powershell module dependency (SQL Server)

• Improve error handling in SaveDDL powershell script (SQL Server)

• Using JDBC driver now for import and synchonization of meta data (DB2 LUW)

Bugfixes:

• Fixed an issue while using a combination of split limit & custom dpv_rid (Oracle)

• Fixed an issue with skipped scripts shown as success in the audit logging

• Fixed an issue when adding a preconfigured generator

• Fixed an issue with DPF_SCRIPTS not dropped after a run

• Fixed an issue while filling the DPF_SCRIPTS table (SQL Server)

• Fixed an issue with missing runtime-agent.log

• Fixed an issue with not disabling auto-retry by leaving the field blank

• Fixed an double schema import issue on DB2 z/OS 

• Fixed formatting issue for logged SQL statements

When generating Runtime applications Runtime 4.9 or higher is recommended. 

Date

08 Jul 2024

Description

Bugfixes:

Fixed an issue with duplicated rows due to collation edge-cases (SQL Server)

Date

25 Jun 2024

Description

Bugfixes:

• Fixed issue that Privacy is stuck in running state while agent is already done

• Fixed connection issue with IBM DB2 z/OS when using direct connection

• Fixed issue when using '{ }' inside a function condition

Date

22 May 2024

Description

Bugfixes:

• Preconfigured generators are now also enabled for Masking.

• Fixed issue with deterministic flag on preconfigured generators not being saved correctly.

Date

19 Apr 2024

Description

New features:

• Added option to add preconfigured generators to centralize configuration 

• Added option to quickly enable and disable functions on table and schema level

For more information on these features, please refer to the General Functionality chapter of this documentation.

Bugfixes and other changes:

• Removed XX and XXX from country seed file

• Fixed a DB2-i issue with restoring foreign keys with combined columns

• Fixed a DB2-i data generation issue with journaling

• Fixed a copy and paste issue for Generation

• Fixed an issue for Oracle on which insert fail on DPF_COLUMNS table

• Fixed an issue with deterministic data masking on SQL Server on columns containing different casing. 

Date

05 Apr 2024

Description

This release contains a hotfix

• Fixed issue when dropping constraints and disabling triggers [SQL Server]

• Fixed issue with creating index on LongText datatypes [MySQL] 

• Fixed issue with unsigned columns [MySQL] 

Date

27 Feb 2024

Description

This release contains bugfixes

• Fixed issue in conditional shuffle for Oracle introduced in 4.14.2

• Fixed "org.apache.velocity.runtime" error when 4.14.2 was installed over previous installation

• Improved installer to prevent old files from previous installation interfering with current installation

Date

08 Dec 2023

Description

This release contains bugfixes

• Fixed issue while changing generator type overwriting custom function names

• Fixed issue on DB2 LUW with restoring foreign keys with combinded columns

• Fixed issue for DB2 iSeries issue when saving a connection without a port defined

• Fixed issue for generator functions where setting are not saved correctly

• Fixed issue with generation for SQL Server with tables having identity columns

• Fixed issue for DB2 iSeries sending out two start messages to the Runtime agent

Date

08 Dec 2023

Description

Privacy 4.14.1 is an internal release which was not published.

Date

Unreleased

Description

This release contains new database support, features and bugfixes

IBM DB2 z/OS (Mainframe) support
We are excited to bring full masking and generation support for IBM DB2 on z/OS (Mainframe). This new update gives large enterprises the option to modernize their test environments with representive and safe test data. 

• License Note: Using IBM DB2 z/OS requires an additional license. Please contact your sales representative to check if you have the right licence to use this feature. 

Other features and bugfixes

• We have upgraded our solution to .NET 6. All dependencies are now embeded and does not require extra installation of .NET dependencies

• Added an option to enter and save a name/description for a connection. 

• Added a deprecation warning message when deploying in legacy mode

• Fixed an issue in which the IBAN account generator was not deterministic

• Fixed issues with the Random Date/Time generator when configured on a varchar field

• Fixed an issue when upgrading an generated template in Runtime having duplicate schema mappings

• Fixed a crash when opening the help documetation

• Fixed an issue when using a disabled function and a translation table (DB2 LUW)

• Fixed the 'open audit log' button

Important: When generating Runtime applications with DATPROF Privacy 4.14, Runtime 4.7 or higher is recommended. 

Date

09 Oct 2023

Description

This release contains bugfixes

• Resolved an issue for DB2 LUW involving gather statistics, a shuffle function and exclude nulls condition.

• Resolved an issue for DB2 LUW involving gather statistics, a random lookup function.

Date

29 Sep 2023

Description

This release contains bugfixes

• Resolved an issue for DB2 LUW in which gather statistics modules gives an error

• Resolved an issue for MySQL where rows with null values were not restored correctly. 

Date

26 Sep 2023

Description

This release contains bugfixes

• Replaced seed list of Random word generator (US)

• Resolved an execution issue when a function is disabled 

Date

10 May 2023

Description

This release contains a fix for a single bug

• Resolved an duplicate key issue with multi column seed file generator 

Date

18 Apr 2023

Description

This release contains improvements and bugfixes

• Resolved an IComparable error during generation (introduced in 4.13.2)

• Resolved an issue with resizing the treegrid in generation 

• Resolved an issue with the ValueLookup for DB2 on LUW

Date

08 Mar 2023

Description

This release contains improvements and bugfixes

• Addressed an issue on Azure SQL where the database collation was set to Latin1_General_100_CI_AS_SC.

• Resolved an issue where Post-SQL was not reset correctly when switching generator types.

• Fixed an issue where XMLTYPE columns were truncated (metadata synchronization is required).

• Improved performance by adding indexes to temporary tables in SQL Server.

• Fixed a crash that occurred when synchronization caused issues in the Multi-Column Seed File Generator.

• Resolved an issue where a project became corrupt after creating a Value from the Multi-Column Seed File Generator.

• Fixed a crash that occurred when the project name contained trailing spaces.

• Widened the default width of the Connection Editor to provide more space for connections.

• Updated the Visualize Process Model to list function names instead of function types in the drop-down menu.

Date

02 Mar 2023

Description

This release contains improvements and bugfixes

• Added extra statistics on temporary tables when TempStatisticsPercentage is set (Oracle)

• Fixed issue with meta data not being synced directly inside generation sets

• Fixed issue when duplicate function names exist

• Fixed issues with tables that are in other schema's than dbo (SQL Server)

• Fixed issue with incorrect cast assignement (SQL Server)

Date

16 Dec 2022

Version

4.13.0

Description

This release contains bugfixes and improvements

• Added generation to process visualization

• Added generation audit log

• Added option to disable specific generation sets

• Fixed issue in generation on columns that are NOT NULL

• Fixed issue with bypassing spatial indexes  on SQL Server

• Fixed issue with restoring secondary XML indexes on SQL Server

• Fixed UI issue that prevents selecting a table when a translation table is selected

Date

06 Oct 2022

Version

4.12.4

Description

This release contains bugfixes

• Fixed issues on Oracle databases that use characters sets requiring orai18n.jar

Date

02 Sep 2022

Version

4.12.3

Description

This release contains bugfixes and improvements

• Fixed characterset issues with custom seedfiles

• Adding functions to not supported datatypes is disabled

• Adding warning icons to columns with unsupported datatypes 

• Improved error message when custom seedfile could not be found

• Fixed crash when first schema does not contain any table

• Fixed padding option in Sequential Number generator

• Fixed error when testing connections on DB2 iSeries when password is empty

• Fixed generation issue on SQL Server when temp schema is not DBO

• Prevent error when table inside generation set has no generators configured

• Fixed error when generation set name contains special characters. 

• Fixed issue with foreign key generator when foreign key is removed

Date

19 Jul 2022

Version

4.12.2

Description

This release contains only bugfixes

• Fixed error with Multi Column Seed file generator

• Fixed SSL handshake failure on PostgreSQL / AWS Aurora databases

Date

13 Jun 2022

Version

4.12.1

Description

This release contains only bugfixes

• Fixed missing seedfile error with specific generators. 

Date

12 May 2022

Version

4.12

Description

This release contains new improvements and bugfixes

• Database version is shown when testing a connection

• Increased performance for MySQL 5

• Added ascending and descending options in table list

• Added missing data types for Postgresql

• Fixed sorting issue in table list

• Fixed duplicating seedfiles in generated package 

• Fixed SQL Server issue with tables that are not stored in schema dbo

• Fixed issue where Post SQL (Generation) was not saved

• Fixed issue where the wrong schema was used for dropping the translation table

Important: When generating Runtime applications with DATPROF Privacy 4.12, Runtime 4.2 or higher is recommended. 

Date

11 May 2022