Greenplum component release notes

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

Changelog

Version 2024.4.0

Bug fixes

  • DI-9337: Template LOAD S3 File to Greenplum: fixed a memory leak.

  • DI-10055: Template DESERIALIZER Greenplum String as Xml: fixed an issue that added unnecessary quotes in string fields that contain spaces.

Version 2024.3.0

Feature improvements

  • DI-9601: Updated main component libraries to the latest versions.

Bug fixes

  • DI-9257: Template LOAD S3 File to GreenPlum: fixed an issue that prevented the checkFileExistence parameter from working.

  • DI-9342: Template LOAD S3 File to Greenplum: added logic to handle large text columns by converting them to TEXT type.

  • DI-9343: Tool DESERIALIZER Greenplum String as Xml: Fixed an issue that caused queries to use a lot of memory.

Version 2024.2.0

Feature improvements

  • DI-8898: Updated GreenPlum component libraries and dependencies.

Bug fixes

  • DI-8866: Removed the Disable Cert Checking parameter.

  • DI-9528: Updated the PostgreSQL JDBC driver.

Version 2024.1.10

Bug fixes

  • DI-10055: Template DESERIALIZER Greenplum String as Xml: fixed an issue that added unnecessary quotes in string fields that contain spaces.

Version 2024.1.6

Bug fixes

  • DI-9343: Tool DESERIALIZER Greenplum String as Xml: Fixed an issue that caused queries to use a lot of memory.

Version 2024.1.4

Bug fixes

  • DI-9528: Updated the PostgreSQL JDBC driver.

Version 2024.1.0

Feature improvements

  • DI-6920: Add new deserializer template DESERIALIZER Greenplum String as Xml to create XML data from a Greenplum 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-7958: Template LOAD File to GreenPlum: various bug fixes and internal improvements.

Version 2023.4.0

Feature improvements

  • DI-7010: Template LOAD S3 File to Greenplum: add a new parameter to customize the string delimiter.

  • DI-7956: Template LOAD S3 file to Greenplum: add support for positional files.

  • DI-8116: Template LOAD S3 File to Greenplum: add the ability to check the source S3 file existence before trying to process it.

  • DI-8196: Third-party library upgrade.

Bug fixes

  • DI-7957: Template S3 File to Greenplum: the template fails when using tabulation as a field delimiter.

Version 2023.2.0

Feature improvements

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

  • DI-6740: Multiple improvements to the Load S3 File to Greenplum template, including performance and efficiency, automated encoding management based on the metadata, header skip clause, date/timestamp format management. The dataFormat parameter is re-labeled to Profile.

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.12

Bug fixes

  • DI-9528: Updated the PostgreSQL JDBC driver.

Version 2023.1.9

Bug fixes

  • DI-7958: Template LOAD File to GreenPlum: bug fixes and internal improvements.

Version 2023.1.2 (Greenplum component)

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.1 (Greenplum component)

Bug fixes

  • DI-7192: In a mapping between a file and Greenplum, the Load S3 File to Greenplum template is selected by default even when the files are not located in S3.

Version 2023.1.0 (Greenplum component)

Feature improvements

  • DI-4668: The Create indexes on Target Table parameter has been added to the INTEGRATION GreenPlum (NO_LOAD) template.

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

  • DI-6439: The LOAD File to Greenplum (with gpload) template is now available.

Bug fixes

  • DI-5420: JDBC Driver - Third-party library upgrade.

  • DI-6285: PostgreSQL - Driver upgrade.

  • DI-6451: The Transactional Mode On Work Table parameter has been added to the INTEGRATION Greenplum template. It allows managing transactions on work tables.

  • DI-6748: PostgreSQL - Driver upgrade.

Version 5.3.10 (Greenplum component)

Bug fixes

  • DI-6707: When creating a mapping between a file and Greenplum, the Load S3 File to Greenplum template is selected by default instead of the generic LOAD File to Rdbms template.

Version 5.3.9 (Greenplum component)

Feature improvements

  • DI-6429: The LOAD S3 File to GreenPlum template has been added to the Greenplum component. The template allows loading files stored in the S3 bucket to Greenplum using external tables.

Bug fixes

  • DI-6358: Cross joins generated by mappings unexpectedly use CROSS OUTER JOIN syntax instead of CROSS JOIN.

Version 2.0.1 (Greenplum 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

Version 2.0.2 (Greenplum component)

Bug fixes

  • DI-2743: Template - LOAD Rdbms to GreenPlum (with gpload) - generated temporary file names may unexpectedly contain object delimiters

Version 3.0.0 (component pack)

Feature improvements

  • 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

Version 5.3.4 (component pack)

Bug fixes

  • DI-5420 : Update the greenplum third-party JDBC Driver to version 42.3.3.