Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Digital Support
Digital Support

Welcome to September's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars.

Subscribe to the Qlik Data Integration topic to be notified of future editions!  



Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and Targets Q&A session scheduled for October 24th at 10:00 AM EDT. It is a live Q&A session with a panel of Qlik experts. Bring your questions, and we do our best to answer them. 


Resource Highlights

Qlik Replicate November 2023 and FIPS

The November 2023 release of Qlik Replicate is not yet FIPS compliant. If you require a compliant environment, remain on the already FIPS compatible versions. See Qlik Replicate November 2023 and FIPS: Release not yet FIPS compliant for details.


Knowledgebase Article

Endpoint Spotlight: DB2

Find our latest knowledge base articles for DB2 endpoints. 

New Issues Reported


Best Practice

  • Match R4Z and Qlik Replicate versions

    The Qlik Replicate and R4Z versions you install must be part of the same release, which can either be an initial release or a patch/service release. This means that if you upgrade Qlik Replicate, you must also upgrade your R4Z installation (to the version that correlates with the Qlik Replicate release you are installing), unless it has the same build number as your currently installed R4Z. Note that despite being part of the same release, the Qlik Replicate and R4Z build numbers (reflected in their file names) might not be the same.

    For example, Qlik Replicate May 2022 SR2 includes the following files:

    • (the Replicate installer) 
    • (the R4Z installer).

  • How to avoid WLM tasks being cancelled due to Work Load Manager Policy settings

    When installing and using the DB2 z/OS endpoint in Qlik Replicate, WLM tasks on the mainframe may get cancelled. There are multiple root causes for this, but a common one can be addressed by reviewing the execution priority (WLM settings).

    See Qlik Replicate and R4Z: Best practice to ensure DB2 z/OS Workload Manager (WLM) tasks are not cancel... for details.


Release Updates


Qlik Replicate May 2023 Patch 3

ID: RECOB-7408
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The capture process would not recover from a communication error in the metadata connection.

ID: RECOB-7385
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The following ambiguous warning message would sometimes be issued when resuming a task:
Transaction <> was committed after the Full Load started and the BEGIN TRANSACTION statement was not captured.

ID: RECOB-7220
Type: Issue
Component/Process: DB2 z/OS Source
Description: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs.

Qlik Replicate May 2023 Patch 2

ID: RECOB-7311
Type: Enhancement
Component/Process: IBM DB2 for z/OS Target
Description: Performance was improved when using the zload utility to load files.

ID: RECOB-7146
Type: Issue
Component/Process: IBM DB2 for z/OS Target
Description: The task log would display the following incorrect warning when replicating from IBM DB2 on z/OS 13.1 (which is certified): Replicate has not been certified to work with DB2 z/OS version '13.01.0005', and therefore any issues you may encounter with this version are not covered by your license agreement.

ID: RECOB-7114
Type: Issue
Component/Process: IBM DB2 for z/OS Target
Description: The R4Z DO4GRANT JCL was updated to grant the R4Z user permissions on the SYSIBM.SYSTABLEPART and SYSIBM.SYSPARMS tables.


Upcoming Enhancements 

Qlik Replicate November 2023 IR

  • Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings )
  • Confluent Schema Register using BOTH authentication methods (Public Key + Username & password)
  • Snowflake - Support Transactions in Upsert Mode
  • Boolean Data Type support for PG sources and Bit support for SQL Server targets
  • Google BigQuery - Secure current authentication (no longer have credential files on customer file system)
  • Aurora PostgreSQL source - without the "superuser" role certification
  • Azure Database for MySQL Flexible Server - Source & Target Certification
  • MariaDB 10.6 to 10.11 versions on MySQL - certification
  • MariaDB 10.6 version on Amazon RDS - certification
  • Google Cloud SQL for MSSQL Source endpoint
  • Databricks 12.2 LTS Certification
  • Databricks Serverless SQL warehouse certification


Troubleshooting tips

Analyze Qlik Replicate Logs 

An evergreen pair of articles helps you read and analyze Qlik Replicate log files:

How to analyze a Qlik Replicate log
List of the error types in Qlik Replicate


Qlik Replicate End of Life Versions 

Version Release Date End of Support Date
Qlik Replicate May 2023 May 9, 2023 May 9, 2025
Qlik Replicate November 2022 November 8, 2022 November 8, 2024
Qlik Replicate May 2022 May 10, 2022 May 10, 2024
Qlik Replicate November 2021 November 8, 2021 November 8, 2023
Qlik Replicate May 2021 May 11, 2021 May 11, 2023
Qlik Replicate November 2020 November 10, 2020 November 30, 2022
Qlik Replicate April 2020 (6.6) April 16, 2020 April 30, 2022
Qlik Replicate 6.5 November 14, 2019 November 30, 2021
Qlik Replicate 6.4 April 1, 2019 April 14, 2021
Qlik Replicate 5.5 August 1, 2017 November 30, 2020


For more information, see Qlik Product Lifecycles.