Qlik Talend CloudData Integration improvements

Customers who are using Qlik Data Gateway – Data Movement need to upgrade to 2025.5.22 or later to benefit from these improvements. For upgrade instructions and a list of resolved issues, see Upgrading the Data Movement gateway installation.

Databricks primary key support

From this version, the data task will create a primary key on target Databricks Delta tables, using the RELY keyword. Although Databricks does not enforce primary key constraints, primary keys with the RELY keyword are assumed to have no duplicates and can therefore be used by Databricks for query optimization.

Requirements:

• You must select a Catalog in the connector settings

• Databricks 14.2 or later

Data type enhancements

• IBM DB2 for iSeries source: Support for the following data types has been added: BINARY-DECIMAL and ZONED-DECIMAL

• Databricks target: In previous versions, BYTES was mapped to STRING. From this version, it will be mapped to VARCHAR (Length in Bytes)

• Google Cloud BigQuery target: The JSON subtype is now supported by the Google Cloud BigQuery target

PostgreSQL-based source: Partitioned tables now supported by default

Replication (Full Load and CDC) of partitions and sub-partitions (and sub-sub partitions) from PostgreSQLbased data sources is now supported by default.

Google Cloud BigQuery target: Support for data truncation error handling

The Google Cloud BigQuery target now supports data truncation error handling. If a data truncation error occurs, you can now choose whether to log the record to the exceptions control table (default), ignore the record, suspend the table, or stop the task.

Newly supported versions

The following source and target endpoint versions are now supported:

• MariaDB (on-premises) and Amazon RDS for MariaDB: 11.4

• MySQL (on-premises), MySQL Percona, Google Cloud SQL for MySQL, Amazon RDS for MySQL, and Microsoft Azure Database for MySQL – Flexible Server: 8.4

• PostgreSQL (on-premises), Google Cloud SQL for PostgreSQL, Amazon RDS for PostgreSQL, and Microsoft Azure Database for PostgreSQL – Flexible Server: 17.x

Newly supported driver versions

IBM Data Server Client 11.5.9 is now supported for the following DB2 sources:

• IBM DB2 for LUW

• IBM DB2 for z/OS

End-of-life source and driver versions

• End-of-life sources and targets: Support for Microsoft Azure Database for MySQL and Microsoft Azure Database for PostgreSQL, which have been officially retired by Microsoft, has been discontinued.

• End-of-life source versions: Support for IBM DB2 for iSeries 7.2 which is EOL, has been discontinued.

• End-of-life driver versions: Support for IBM Data Server Client 11.5.6 has been discontinued.