SAP IQ Component Release Notes

This page lists the main features added to the SAP IQ Component.

Feature Highlights

Version 2.0.5

Fixed issues

This version contains fixed issues, which can be found in the complete changelog.

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.3

Change Data Capture (CDC)

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.

Version 2.0.2

JDBC Drivers classes and URLs

Semarchy xDI 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 selected Module.

This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.

Version 2.0.1

Integration Sybase IQ Template

A new option named "Ignore Conversion Error" has been added, to ignore data conversion error and write a NULL value instead of the erroneous value.

Change Log

Version 2023.1.0 (SAP IQ Component)

New features

  • DI-4677: The Create indexes on Target Table parameter has been added to the INTEGRATION Sybase IQ with Slowly Changing Dimension template.

  • DI-4678: The Create indexes on Target Table parameter has been added to the INTEGRATION Sybase IQ template.

Version 2.0.2 (SAP IQ Component)

New Features

  • DI-2121: SAP IQ Component - update module definition to propose more accurate driver and urls

Version 2.0.3 (SAP IQ 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

Version 2.0.4 (SAP IQ Component)

New Features

  • DI-911: Template - Reject SybaseIQ - new parameter "Duplicates Detection Mode" to be able to choose how the detection is performed, to adapt the generated queries depending on the requirements

  • DI-2691: Template - Load File to Sybase IQ - new parameter "Success If No File"

  • DI-2724: Template - STAGING Sybase IQ as Table - new dedicated optimized Templates to perform table stages

  • DI-2766: Template - Integration Sybase IQ - add a new parameter to disable transactional mode on target

Bug Fixes

  • DI-2692: Template - Load File to Sybase IQ - the Template should not use ROW DELIMITED BY clause when separator is \n or \r\n

  • DI-2693: Template - Load File to Sybase IQ - the Template should not use DELIMITED BY clause when separator is \t

  • DI-2748: Template - LOAD Rdbms to Sybase IQ (with LOAD TABLE) - generated temporary file names may unexpectedly contain object delimiters

Version 2.0.5 (SAP IQ Component)

Bug Fixes

  • DI-4022: Template - STAGING Sybase IQ As Table - Incorrect syntax generated in the select query

  • DI-4158: Template - Load File to Sybase IQ - "Loading of data with LOAD TABLE" action could sometimes be executed before the load table is created

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-4962: Improved component dependencies and requirements management