Microsoft SQL Server Component Release Notes
A new parameter named "CreateIndexesOnTargetTable" has been added in the Integration MSSQL Template.
This parameter allows to configure when indexes should be created.
Different values are available to indicate if the Template should decide automatically, if the Template should always create them or never.
This version contains some minor improvements and fixed issues, which can be found in the complete changelog.
Addition of a new option "Success If No File", on LOAD File to Mssql Template.
If this option is true, the Mapping will succeed when source file(s) do not exist, instead of throwing an error.
The table based on the expected structure will be created empty.
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 xDM Data Integration 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-1776: LOAD File to Mssql - new option 'SuccessIfNoFile' to create an empty table, if the source file does not exist
DI-1794: Support reversing indexes
DI-1912: Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)
DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet
DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking
DI-2695: Template - LOAD File to MSSQL - improve the execution of BCP command and the logged command to be clearer
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-4727: Rebranding: Templates and sample projects
DI-4731: Rebranding: Template messages
DI-4962: Improved component dependencies and requirements management