Microsoft Azure Component Release Notes

This page lists the main features added to the Microsoft Azure component.

Feature Highlights

Version 2.1.1

Some fixed issues

Some issues has been fixed on SQL Database and related SQL syntax generated.

Refer to the complete change log for further information.

Version 2.1.0

Snowflake External Storage Attribute

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:

Azure01

This requires to use an up to date Snowflake Component which has been updated accordingly.

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.3

Support Azure azcopy command line utility

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.

Support reversing indexes from Azure SQL

Indexes are now reversed when performing a reverse on Azure SQL Database Metadata.

Change Data Capture (CDC)

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.

Complete changelog

The complete changelog with the list of improvements and fixed issues can be found at the following location.

Version 2.0.2

JDBC Drivers classes and URLs

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.

Version 2.0.1

Sample project

The component example project can now be imported directly in the "New" menu of the Project Explorer.

Change Log

Version 2023.1.1 (Microsoft Azure Component)

New Feature

  • DI-7221: The XpathExpressionForAzureStorage option has been added to the Azure Storage Operation tool.

Bug Fix

  • DI-7171: The Azure Storage Operation tool throws the BlobServiceClient not found in namespace error.

Version 2023.1.0 (Microsoft Azure Component)

New Feature

  • 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.

  • DI-5008: The azcopy output is read and parsed to produce an error when an operation fails.

Bug Fix

  • DI-5007: When sending large files, the azcopy command does not end.

Version 2.0.2 (Microsoft Azure Component)

New Features

  • DI-2114: Microsoft Azure Component - update module definition to propose more accurate driver and urls

Version 2.0.3 (Microsoft Azure Component)

New Features

  • 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

Bug Fixes

  • DI-1819: Azure SQL Database - the syntax to drop an index was wrong

Version 2.0.4 (Microsoft Azure Component)

New Features

  • 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

Bug Fixes

  • DI-2715: Azure Product - Datetime2 should be the default TIMESTAMP datatype

  • DI-2734: Template - LOAD Rdbms to Azure SQL Database - generated temporary file names may unexpectedly contain object delimiters

Version 2.1.0 (Microsoft Azure Component)

New Features

  • DI-2854: Microsoft Azure Storage and Amazon S3 Bucket nodes available in the workspace are now proposed automatically in Snowflake Metadata in External Storage attribute

Version 2.1.1 (Microsoft Azure Component)

Bug Fixes

  • DI-4722: Azure SQL Database - SQL syntax generated to drop primary key is incorrect in some Templates

Version 3.0.0 (Component Pack)

New Features

  • 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