Cloud release notes November 2022
Release number: K63
Modeling enhancements
New SQL Expression Category
A new sql expression category Utility Functions was added for improved grouping and organization of functions.
Union Step enhancement
Previously the only way to refresh the table list on a union step, was to use the refresh schema button on the Initial step.
A new Refresh Union button has been added to the union step to refresh the schema of only the unioned tables.
Existing connector enhancements
Business Central Cloud
In order to improve security, the option to authenticate to webservices using a Webservice API key has now been deprecated in sandbox environments. Only Azure Active Directory should be used.
SAP SQL source
For incremental source loading to work accurately we need a column that is always:
Populated
Updated for each change
When either or neither of these requirements are met, it causes inaccuracies.
An improvement was made in the Incremental Load date column logic to ensure the requirements are always met.
When UpdateDate is null, but CreatedDate exists, we use CreatedDate.
When UpdateDate is null, and CreatedDate DOES NOT exist, we use getdate().
Performance Enhancements
Some releases do not have major new features, as some features take several releases to complete. Every release contains performance enhancements and bug fixes to improve Data Hub.
Date of publication 28 October 2022