Vertica component release notes

This page lists the main features added to the Vertica Component.

Changelog

Version 2024.4.0

This version of the connector requires Semarchy xDI Designer version 2024.4.0 or later.

Bug fixes

  • DI-10092: Fixed an issue that created incomplete metadata definitions when reverse-engineering Vertica tables.

  • DI-10827: Added object delimiters and Vertica reserved words for more correct reverse-engineering.

Version 2024.3.0

Feature improvements

  • DI-6842: Added constraint enforcement option on primary keys.

Bug fixes

  • DI-9749: Fixed an issue which prevented the Vertica Export Object Parser from parsing primary keys.

Version 2024.1.6

Bug fixes

  • DI-9749: Fixed an issue which prevented the Vertica Export Object Parser from parsing primary keys.

Version 2024.1.5

Feature improvements

  • DI-6842: Added constraint enforcement option on primary keys.

Version 2024.1.0

Feature improvements

  • DI-8088: Add missing process tool TOOL Vertica to Parquet to Vertica component.

Version 2023.4.0

Feature improvements

  • DI-6620: Support writing hierarchical data in ARRAY and ROW data types.

Version 2023.3.0

Feature improvements

  • DI-6619: Support designing and reading hierarchical data contained in ARRAY and ROW data types.

Version 2023.1.14

Bug fixes

  • DI-9749: Fixed an issue which prevented the Vertica Export Object Parser from parsing primary keys.

Version 2023.1.13

Feature improvements

  • DI-6842: Added constraint enforcement option on primary keys.

Version 2023.1.12

Feature improvements

  • DI-6619: Added support for designing and reading hierarchical data inside ARRAY and ROW datatypes.

  • DI-6620: Added support for writing hierarchical data in ARRAY and ROW datatypes.

Version 2023.1.7

Bug fixes

  • DI-8088: Added missing process tool TOOL Vertica to Parquet to Vertica component.

Version 2023.1.0

Feature improvements

  • DI-4522: A dedicated parser to parse Vertica’s EXPORT_OBJECTS command has been added to the Vertica component and is used in its templates.

  • DI-5735: The GEOMETRY datatype is now supported.

  • DI-5910: The GEOGRAPHY datatype is now supported.

Bug fixes

  • DI-5715: In the INTEGRATION Vertica template, the Slowly Changing Dimension mode is not efficient and causes memory overconsumption.

  • DI-5716: The INTEGRATION Vertica template generates duplicate rows on the target table when the Integration Strategy parameter is set to Slowly Changing Dimension mode and the Useless Update Detection Method parameter is set to disable.

  • DI-5797: In the INTEGRATION Vertica template, the NULL and NOT NULL clauses are unexpectedly hardcoded for the work table columns instead of being automatically computed.

Version 5.3.7 (Component pack)

Feature improvements

  • DI-5910: Support geography datatype.

Version 5.3.5 (component pack)

Feature improvements

  • DI-5735 : Support geometry datatype.

Bug fixes

  • DI-5797 : Template - INTEGRATION Vertica - the NULL and NOT NULL clauses are unexpectedly hardcoded for the work table columns, instead of being automatically computed.

  • DI-5716 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode creates duplicated rows on target when the "Useless Update Detection Method" parameter is set to disable.

  • DI-5715 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode is not efficient and causes memory overconsumption.

Version 3.0.0 (component pack)

Feature improvements

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

Version 2.0.4 (Vertica component)

Feature improvements

  • DI-2768: TOOL Vertica Move partitions - new parameter "Force Split".

Bug fixes

  • DI-2752: Template - LOAD Rdbms to Vertica (with COPY) - generated temporary file names may unexpectedly contain object delimiters.

Version 2.0.3 (Vertica component)

Feature improvements

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

Bug fixes

  • DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps.

  • DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data.