PostgreSQL component release notes

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

Changelog

Version 2024.2.0

Features and improvements

  • DI-8902: Updated PostgreSQL component libraries and dependencies.

Bug fixes

  • DI-9076: Added support for XML field types in database metadata and integration flows.

  • DI-9528: Updated the PostgreSQL JDBC driver.

Version 2024.1.2

Bug fixes

  • DI-9076: Added support for XML field types in database metadata and integration flows.

Version 2024.1.0

Features

  • DI-6921: Add new deserializer template DESERIALIZER PostgreSQL String as Xml to create XML data from a PostgreSQL string data type.

  • DI-7621: Implement serializer functionality in Designer. Use the serializer in mappings to parse structured data from a source and flatten it to string data.

Bug fixes

  • DI-7370: Remove AUTONOMOUS SQL transaction type, as it has no effect.

Version 2023.4.0

Features

DI-8195: Third-party library upgrade.

Version 2023.2.0

Features

  • DI-6927: New DESERIALIZER PostgreSQL String as JSON template.

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.10

Features

  • DI-9076: Added support for XML field types in database metadata and integration flows.

Version 2023.1.2

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.0

Features

  • DI-4676: The Create indexes on Target Table parameter has been added to the INTEGRATION PostgreSQL template.

  • DI-6256: Target filters have been added to the INTEGRATION PostgreSQL template.

Bug fixes

  • DI-5505: When using the INTEGRATION Postgres template, data is unexpectedly inserted twice in the work table when it is in slowly changing dimension (SCD) mode.

  • DI-6285 & DI-6748: PostgreSQL - Driver upgrade.

Version 19.0.25 (Designer)

Bug fixes

  • DI-1947: PostgreSQL Component: fix creation mask for BIT datatype which was not taking into account the size defined and CHARCATER VARYING datatype which should ignore sizes greater than 1000

Version 2.0.2 (PostgreSQL component)

Features

  • DI-1782: Addition a new datatype "Json" in PostgreSQL Metadata

  • DI-1889: Integration PostgreSQL - When the option "Create target table" is enabled, generated table creation statement now also contains the primary key defined in Metadata

  • DI-1890: INTEGRATION PostgreSQL - Add support for xpath expressions in deleteWhereClause parameter

  • 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

Version 2.0.3 (PostgreSQL component)

Features

  • DI-2663: PostgreSQL Metadata - support jsonb datatype

Bug fixes

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

Version 2.0.4 (PostgreSQL component)

Bug fixes

  • DI-3871: Template - Load Rdbms to PostgreSQL (with COPY) - clarify "Enable File Transport" parameter description

Version 3.0.0 (component pack)

Features

  • DI-2641: Reverse-engineer foreign keys referencing tables in another schema when the other table and schema are available in the metadata

  • DI-2656: PostgreSQL technology includes the list of database-reserved keywords

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4962: Improved component dependencies and requirements management

Version 3.0.2 (component pack)

Features

  • DI-5319 : Update the PostgreSQL JDBC Driver proposed in the optional third-party pack to version 42.3.3.

Version 5.3.4 (component pack)

Bug fixes

  • DI-5505 : Template - INTEGRATION Postgres - The data is unexpectedly inserted twice in the work table when being in slowly changing dimension (SCD) mode.