Release Notes - Version 5

5.0.0.0_b2.7

(06.08.2020)

Improvements:
  • Staging: New Source Type available: Added Amazon Athena.

  • General: Handle display zoom if custom scaling is defined.

  • Deployment: Handle broken dependencies by notifying user, e.g. if a business rule references a non existing business object.

Bugfix:
  • Data Vault: Fixed delete satellite dependency check to be less sensitive.

  • Staging: Initiating a system load while a staging load was running caused “invalid input syntax” error

  • Data Lineage: Fixed clause leading to lineage being stuck in “not up to date” unless manually refreshed

  • Dimensional Model: Do not reset manual ordering of Businessobject when using “double-click” or “+”

  • Documentation: Store initiating username instead of servername.

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b2.6

(16.07.2020)

Improvements:
  • Snowflake: Updated JDBC Driver, drastically increasing staging speed (known limitation: based on our tests, the driver does not yet allow this for all data types , e.g. time)

  • Oracle: Extended data type for BK column in hash to NVARCHAR(2000)

Bugfix:
  • Deplyoment: Fix export of columns with pattern “_dvb_”

  • Dimensional Model: Fix renaming and commenting

  • Exasol: Fixed deleting Businessobject with dependent unaltered business rule

  • Data Lineage: Fixed missing Business Vault Systems in Job Lineage

  • Dimensional Model: Fixed replacing of columns

  • Deployment: Fixed hub load dependencies selection

  • Deployment: Do not call deleteHubData for alias hubs

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: Yes / No

5.0.0.0_b2.5

(02.07.2020)

Improvements:
  • Oracle: Performance of base views

  • Connection Pool: Stability improvements (impacting also loading stability)

  • Documentation: Moved documentation storage into core for compatibility. This means, the documentation has to be regenerated after removing the core container.

  • Business Rules: Open underlying Business object directly from the business rulesets list

  • Deployment: If retry of a failed deployment is successful, overwrite failed state

Bugfix:
  • Oracle: Fixed casing issue in quote_ident function

  • Operations: Fixed editing jobs, so it directly updates the information without a need for a cache refresh

  • Operations: Fixed command line content to not be overwritten / reset when switching from module

  • General: Re-Enabled edge-chromium support

  • Documentation: Fix “Cannot read property ‘regenerate’ of undefined

  • Oracle: Filter recycle bin objects so that startup/caching is not affected

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: Yes / No

  • Oracle: Yes / No

  • Postgres: Yes / No

  • Exasol: Yes / No

  • Snowflake: Yes / No

5.0.0.0_b2.4

(26.06.2020)

Improvements:
  • General: Allow copying of result/error messages. Prevent Overflow of messages.

Bugfix:
  • Connection Pool: Prevent insufficient privileges error

  • Datavault: Return error if updating metadta fails

  • Operations: Fixed escaping of single quote ‘ in job schedule parameters

  • Business Rulesets: Fix access errormart related problems, potentially not allowing to edit a view and having outdated access errormarts

  • Datavault: Fix bookmark restoring

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b2.3

(22.06.2020) Internal Release

5.0.0.0_b2.2

(28.05.2020)

Improvements:
  • Business Rules: Handle business rules missing include_in_accesslayer in metadata

Bugfix:
  • Staging: Fix loading time type. Hint: On exasol milliseconds are not yet loaded

  • Datavault: Fixed escaping of mssql satellite and transaction link creation (datavault staging view)

  • General: Fixed potential race condition issue in connection pool

  • Exasol/Snowflake: Fixed caching issue in hub and link load deletion, causing other loads from the same staging table to fail

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b2.1

(20.05.2020)

Bugfix:
  • Exasol: Corrected type mapping for integer values in staging

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b2.0

(15.05.2020)

Improvements:
  • Deployment: Compare Environment Configurations to show if the environments behave differently

  • Jobs: Extend sql post job queries length on oracle, exasol and snowflake, also extend error messages in log tables

  • Datavault: fix Do not open search bar if object present

  • Command Line: Command line CTRL + ENTER to do the same as CTRL + S

  • Deployment: Allow direction changes before connecting

  • Command Line: Handle long error messages and let user copy it

Bugfix:
  • Staging: Handle Citext Type on postgres and default to string otherwise

  • Deployment: Handle dependencies when selecting top categories (Data Vault, Staging, …)

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: Yes / No

  • Postgres: No / No

  • Exasol: Yes / No

  • Snowflake: Yes / No

5.0.0.0_b1.27

(08.05.2020)

Improvements:

Bugfix:
  • General: Escape JSON Strings in comments

  • General: Row counts in same transaction as the load, otherwise the count may be wrong in the log

  • General: Ensure transaction are commited or rollbacked before triggering dependent loads

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.26

(30.04.2020)

Improvements:

Bugfix:
  • Exasol: Fixed exasol bug for special characters in comments (or other metadata)

  • Staging: Fixed issue when äöü (or any other unicode escape sequences) occurs in source filename or sheet name (e.g. excel)

  • Businessobjects: Handle different names for related Businessobjects

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.25

(23.04.2020)

Improvements:

Bugfix:
  • Staging: Compatability Fix for JDBC Drivers wrongly using column names instead of column labels

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.24

(20.04.2020)

Improvements:

Bugfix:
  • Staging: Let ‘-‘ sign be a valid character in source_staging_table_id (coming from the source)

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.23

(16.04.2020)

Improvements:

Bugfix:
  • Staging: Fixed issue when opening staging table properties after loading a staging table was not possible

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.22

(09.04.2020)

Improvements:

Bugfix:
  • Snowflake: Changed business key generation by adding coalesce

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: No / No

  • Postgres: No / No

  • Exasol: No / No

  • Snowflake: No / No

5.0.0.0_b1.21

(08.04.2020)

Improvements:
  • Staging: Fixed Excel Connect

  • Businessrules: Remove not existent objects from quick inserts

Bugfix:
  • Oracle/Snowflake: Deploy Columns with conversions

  • Exasol: Cached Metadata of columns (conversion, name, comment)

  • General: Prevent “no valid connection available” error during loads

  • Snowflake: Allow load of sat > 2 Billion records (variable overflow)

  • General: On startup log in core log if a failure happens (refresh config)

Hints for the Installation: Manual Update Scripts / Automatic Model Update
  • MS SQL: No / No

  • Oracle: Yes / No

  • Postgres: No / No

  • Exasol: Yes / No

  • Snowflake: Yes / No

5.0.0.0_b1.2 - 5.0.0.0_b1.20

Internal test releases

5.0.0.0_b1.1

(04.11.2019)

First Beta Release with Connection Pool and Cache.