Microsoft Azure Component Release Notes
Some issues has been fixed on SQL Database and related SQL syntax generated.
Refer to the complete change log for further information.
Snowflake Component allows to use Microsoft Azure Storage as storage location.
Microsoft Azure Component has been updated to automatically provide the availables storage nodes of the workspace in the Snowflake Metadata.
Below is an example of the Snowflake Metadata with the list of available nodes:
|This requires to use an up to date Snowflake Component which has been updated accordingly.|
Azure command line utility provided better performances than the Azure Java SDK
We therefore improved the Azure tools which supports now using the "azcopy" command line utility for file operations.
Note that it will be used automatically when available on the server where the Runtime is running.
WARNING: Prerequistes: Azure azcopy command line utility must be installed on the machine where the Runtime is located, to be able to use it. Refer to Microsoft Azure documentation to learn how to install it.
Indexes are now reversed when performing a reverse on Azure SQL Database Metadata.
Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.
Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.
Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.
Semarchy xDI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.
This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.
DI-7221: The XpathExpressionForAzureStorage option has been added to the Azure Storage Operation tool.
DI-4899: The LOAD Azure File to Azure SQL Database template is now available for loading a delimited file that is on Azure Storage into Azure SQL Database.
azcopyoutput is read and parsed to produce an error when an operation fails.
DI-1793: Azure SQL Database - support reversing indexes
DI-1813: Azure Storage - support azcopy for file operations
DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking
DI-2544: Template - Load Rdbms to Azure SQL Database - support split mode and Openrowset
DI-2701: Azure Storage - new parameter "AzCopy Timeout" available in Metadata and Tool allowing to define a timeout for the azcopy operation
DI-2702: Azure Storage - new parameter "AzCopy Cap Mbps" parameter available in Metadata and Tool allowing to limit the transfer rate for the azcopy operation
DI-3633: Template - LOAD Rdbms to Azure SQL Database and LOAD File to Azure SQL Database - cleanup the datasource created in cleanup step
DI-2641: Reverse-engineer foreign keys referencing tables in another schema when the other table and schema are available in the metadata
DI-4508: Update Components and Designer to take into account dedicated license permissions
DI-4731: Rebranding: Template messages
DI-4962: Improved component dependencies and requirements management