Release information

DATPROF Subset 4.12

Version

4.12.2

Description

Bugfixes:

  • Upgraded Runtime agent with new Oracle JDBC drivers

When generating Runtime applications Runtime 4.15 or later is recommended.

Date

Version

4.12.1

Description

This release contains features & a hotfix

  • Fixed bypass control not taking effect in Runtime

  • Resolved auto-retry malfunction

When generating Runtime applications Runtime 4.12 or later is recommended.

Date

Version

4.12

Description

Features:

Bugfixes:

  • Improved labeling system with colors

  • Fixed issue with Adhoc queries still being validated while direct access is set to 1

  • Fixed issue with DB2-I with missing identity template

When generating Runtime applications Runtime 4.12 or later is recommended.

Date

DATPROF Subset 4.11

DATPROF Subset 4.11 starts from bugfix version 1 due to some minor adjustments necessary. Version 4.11.0 is not published for public usage.

Version

4.11.1

Description

Bugfixes:

  • Fixed synchronization issue introduced in 4.11.0, which caused synchronizing metadata on DB2 templates to sometimes throw an error.

When generating Runtime applications Runtime 4.10 or later is recommended.

Date

​Nov 6, 2024

Version

4.11

Description

Features:

  • Added option to subset from a remote DB2 z/OS system using a linkname

Bugfixes:

  • Fixed validate issue with custom database link and connect descriptor (Oracle)

When generating Runtime applications Runtime 4.10 or later is recommended.

DATPROF Subset 4.10

DATPROF Subset 4.10 starts from bugfix version 1 due to some minor adjustments necessary. Version 4.10.0 is not published for public usage.

Version

4.10.2

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 / ​ properties for SQL Server connections

  • Updated the SaveDDL powershell script to support Entra ID authentication

Bugfixes:

  • Fixed an issue that prevent opening a .dsb file directly from the explorer

When generating Runtime applications Runtime 4.10 or later is recommended.

Version

4.10.1

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 / ​ properties for SQL Server connections

  • Updated the SaveDDL powershell script to support Entra ID authentication

Bugfixes:

  • Fixed an issue that prevent opening a .dsb file directly from the explorer

When generating Runtime applications Runtime 4.9 or later is recommended.

DATPROF Subset 4.9

Version

4.9.0

Description

Bugfixes:

  • Using JDBC drivers to import and synchronize meta data (DB2 LUW)

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

  • Updated included powershell SQL Server module

  • Changed the use of global temporary tables to normal tables (DB2 z/OS)

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

  • Fixed an issue with row counts on Oracle

  • Fixed an issue when subset is stuck while the run is already done

  • Fixed an issue creating a source and target connection to different database types

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

When generating Runtime applications Runtime 4.9 or later is recommended.

DATPROF Subset 4.8


Version

4.8.4

Description

Bugfixes:

  • Fixed issue on SQL Server with tables containing lots of columns not fitting in openrowset query

  • Fixed MySQL issue with tables having ENUM columns

  • Fixed count rows issue on Oracle

Version

4.8.3

Description

Release 4.8.3 is an unpublished release.

Bugfixes:

  • Fixed an issue that caused the “Count Start Rows“ functionality to break for MSSQL environments.

  • Fixed some general license issues.

Version

4.8.2

Description

This release contains bugfixes

  • 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


Version

4.8.1

Description

This release contains bugfixes

  • Fixed issue while selecting a schema in the schema mapping

  • Fixed saving DB2 iSeries connection without a port

  • Fixed DB2 iSeries TechnicalAppenQuery.template

  • Fixed DB2 iSeries Journaling issues

  • Fixed crash when cancelling the Suggest function

  • Fixed missing target connection in project settings

  • Fixed port value being mandatory for SQL Server


Version

4.8.0.

Description

This release contains new database support, features and bugfixes

IBM DB2 z/OS (Mainframe) support
We are excited to bring full subset support for IBM DB2 on z/OS (Mainframe). This new update gives large enterprises the option to modernize their test environments with representative and compact 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 license to use this feature.

Other features and bugfixes

  • We have upgraded our solution to .NET 6. All dependencies are now embedded 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 behaviour in connection editor when saving existing and adding new connections

  • Fixed crash when pressing auto schema mapping

  • Fixed Functional Append query for SQL Server when not using dbo as schema

Important: When generating Runtime applications with DATPROF Subset 4.8, Runtime 4.7.0 or later is recommended


DATPROF Subset 4.7


Version

4.7.7

Description

This release contains a bugfix

  • Fixed issue with duplicate table names existing in different imported schema's


Version

4.7.6

Description

This release contains bugfixes

  • Fixed data conversion issue with multi column foreign keys on IBM DB2 on iSeries

  • Fixed an issue with the JA16SJIS character set on Oracle Databases


Version

4.7.5

Description

This release contains bugfixes

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


Version

4.7.4

Description

This release contains fixes and improvements

  • Improved performance for Append Queries on DB2 iSeries

  • Fixed issue to reset error status and red progress-bar when auto retry fixes the issue.

  • Fixes issue when creating a new project when another project is already opened

  • Fixed issue opening a existing project when there is no project opened.

  • Fixed import issue on PostgreSQL 9.6

  • The target schema (schema mapping) is no longer resetted when the password is entered or cleared

  • Fixed DB2 iSeries issue when table contains a CLOB/BLOB column.


Version

4.7.3

Description

This release contains fixes

  • Fixes issue where RAW datatypes for oracle, throw an exception in certain cases.

  • Upgrade NPGSQL (Postgres AWS support)


Version

4.7.2

Description

This release contains fixes

  • Fixes issue while retrieving check constraints on MySQL

  • Fixes issue while dropping constraints on MySQL

  • Fixed issue with Technical Append Action with double keys joins


Version

4.7.1

Description

This release contains a fix for the installer

  • Fixes issue with downloading dependencies. Internet is not required.


Version

4.7.0

Description

DATPROF Subset 4.7 is now 64bit. An extra dependency is the requirement of .NET Framework 4.8.

This release contains new features and fixes

  • Added new reference visualization inside table properties

  • Added extra information in technical iterations to see how many parent records are missing

  • Gather statistics will not longer cause errors but warning instead

  • Fixed custom JAVA memory causing an error error instead of warning


Important: When generating Runtime applications with DATPROF Subset 4.7, Runtime 4.0.2 or later is recommended

An offline installer of .NET 4.8 framework can be downloaded here:

Date

​Nov 26, 2021 

DATPROF Subset 4.12

Version

4.12.1

Description

This release contains features & a hotfix

  • Fixed bypass control not taking effect in Runtime

  • Resolved auto-retry malfunction

When generating Runtime applications Runtime 4.12 or later is recommended.

Date

Version

4.12

Description

Features:

Bugfixes:

  • Improved labeling system with colors

  • Fixed issue with Adhoc queries still being validated while direct access is set to 1

  • Fixed issue with DB2-I with missing identity template

When generating Runtime applications Runtime 4.12 or later is recommended.

Date

DATPROF Subset 4.11

DATPROF Subset 4.11 starts from bugfix version 1 due to some minor adjustments necessary. Version 4.11.0 is not published for public usage.

Version

4.11.1

Description

Bugfixes:

  • Fixed synchronization issue introduced in 4.11.0, which caused synchronizing metadata on DB2 templates to sometimes throw an error.

When generating Runtime applications Runtime 4.10 or later is recommended.

Date

​Nov 6, 2024

Version

4.11

Description

Features:

  • Added option to subset from a remote DB2 z/OS system using a linkname

Bugfixes:

  • Fixed validate issue with custom database link and connect descriptor (Oracle)

When generating Runtime applications Runtime 4.10 or later is recommended.

DATPROF Subset 4.10

DATPROF Subset 4.10 starts from bugfix version 1 due to some minor adjustments necessary. Version 4.10.0 is not published for public usage.

Version

4.10.2

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 / ​ properties for SQL Server connections

  • Updated the SaveDDL powershell script to support Entra ID authentication

Bugfixes:

  • Fixed an issue that prevent opening a .dsb file directly from the explorer

When generating Runtime applications Runtime 4.10 or later is recommended.

Version

4.10.1

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 / ​ properties for SQL Server connections

  • Updated the SaveDDL powershell script to support Entra ID authentication

Bugfixes:

  • Fixed an issue that prevent opening a .dsb file directly from the explorer

When generating Runtime applications Runtime 4.9 or later is recommended.

DATPROF Subset 4.9

Version

4.9.0

Description

Bugfixes:

  • Using JDBC drivers to import and synchronize meta data (DB2 LUW)

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

  • Updated included powershell SQL Server module

  • Changed the use of global temporary tables to normal tables (DB2 z/OS)

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

  • Fixed an issue with row counts on Oracle

  • Fixed an issue when subset is stuck while the run is already done

  • Fixed an issue creating a source and target connection to different database types

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

When generating Runtime applications Runtime 4.9 or later is recommended.

DATPROF Subset 4.8


Version

4.8.4

Description

Bugfixes:

  • Fixed issue on SQL Server with tables containing lots of columns not fitting in openrowset query

  • Fixed MySQL issue with tables having ENUM columns

  • Fixed count rows issue on Oracle

Version

4.8.3

Description

Release 4.8.3 is an unpublished release.

Bugfixes:

  • Fixed an issue that caused the “Count Start Rows“ functionality to break for MSSQL environments.

  • Fixed some general license issues.

Version

4.8.2

Description

This release contains bugfixes

  • 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


Version

4.8.1

Description

This release contains bugfixes

  • Fixed issue while selecting a schema in the schema mapping

  • Fixed saving DB2 iSeries connection without a port

  • Fixed DB2 iSeries TechnicalAppenQuery.template

  • Fixed DB2 iSeries Journaling issues

  • Fixed crash when cancelling the Suggest function

  • Fixed missing target connection in project settings

  • Fixed port value being mandatory for SQL Server


Version

4.8.0.

Description

This release contains new database support, features and bugfixes

IBM DB2 z/OS (Mainframe) support
We are excited to bring full subset support for IBM DB2 on z/OS (Mainframe). This new update gives large enterprises the option to modernize their test environments with representative and compact 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 license to use this feature.

Other features and bugfixes

  • We have upgraded our solution to .NET 6. All dependencies are now embedded 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 behaviour in connection editor when saving existing and adding new connections

  • Fixed crash when pressing auto schema mapping

  • Fixed Functional Append query for SQL Server when not using dbo as schema

Important: When generating Runtime applications with DATPROF Subset 4.8, Runtime 4.7.0 or later is recommended


DATPROF Subset 4.7


Version

4.7.7

Description

This release contains a bugfix

  • Fixed issue with duplicate table names existing in different imported schema's


Version

4.7.6

Description

This release contains bugfixes

  • Fixed data conversion issue with multi column foreign keys on IBM DB2 on iSeries

  • Fixed an issue with the JA16SJIS character set on Oracle Databases


Version

4.7.5

Description

This release contains bugfixes

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


Version

4.7.4

Description

This release contains fixes and improvements

  • Improved performance for Append Queries on DB2 iSeries

  • Fixed issue to reset error status and red progress-bar when auto retry fixes the issue.

  • Fixes issue when creating a new project when another project is already opened

  • Fixed issue opening a existing project when there is no project opened.

  • Fixed import issue on PostgreSQL 9.6

  • The target schema (schema mapping) is no longer resetted when the password is entered or cleared

  • Fixed DB2 iSeries issue when table contains a CLOB/BLOB column.


Version

4.7.3

Description

This release contains fixes

  • Fixes issue where RAW datatypes for oracle, throw an exception in certain cases.

  • Upgrade NPGSQL (Postgres AWS support)


Version

4.7.2

Description

This release contains fixes

  • Fixes issue while retrieving check constraints on MySQL

  • Fixes issue while dropping constraints on MySQL

  • Fixed issue with Technical Append Action with double keys joins


Version

4.7.1

Description

This release contains a fix for the installer

  • Fixes issue with downloading dependencies. Internet is not required.


Version

4.7.0

Description

DATPROF Subset 4.7 is now 64bit. An extra dependency is the requirement of .NET Framework 4.8.

This release contains new features and fixes

  • Added new reference visualization inside table properties

  • Added extra information in technical iterations to see how many parent records are missing

  • Gather statistics will not longer cause errors but warning instead

  • Fixed custom JAVA memory causing an error error instead of warning


Important: When generating Runtime applications with DATPROF Subset 4.7, Runtime 4.0.2 or later is recommended

An offline installer of .NET 4.8 framework can be downloaded here:

Date

​Nov 26, 2021