Vertica Component Release Notes

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

Change Log

Version 2023.1.13

New Features

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

Version 2023.1.12

New Features

  • 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: Process tool Vertica to Parquet missing from Vertica component

Version 2023.1.0

New Features

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

New Features

  • DI-5910: Support geography datatype.

Version 5.3.5 (Component Pack)

New Features

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

New Features

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

New Features

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

New Features

  • 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