Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to October'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!
Index
- Webinar
- Resource Highlights
- Reminder: Qlik Replicate November 2023 and FIPS
- Knowledgebase Article
- Endpoint Spotlight: SAP
- New Issues Reported
- Tips!
- Best Practice
- Release Updates
- Fixes
- Upcoming Enhancements
- Troubleshooting tips
- Analyze Qlik Replicate Logs
- Qlik Replicate End of Life Versions
Webinar
Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and Targets Q&A session scheduled for October 24th (tomorrow!) 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
Reminder: 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: SAP
Find our latest knowledge base articles for SAP endpoints.
New Issues Reported
- Qlik Replicate: Replicating from SAP DB Source changing the precision on Currency Data Type to the Target
Currency data from SAP appears to replicate incorrectly when source values are compared to the target system. See Qlik Replicate: Replicating from SAP DB Source changing the precision on Currency Data Type to the T... for details.
- Qlik Replicate SAP Application (DB) Cluster Tables missing data in the Target
SAP Cluster Tables has missing data in the Target during CDC process. See Qlik Replicate SAP Application (DB) Cluster Tables missing data in the Target for details.
Tips!
- Qlik Replicate Trigger SAP HANA conversion from Version 1 to Version 2 or Version 3
The Qlik Replicate SAP HANA source endpoint allows you to convert to using the log table with CDC changes. This article documents how to convert the existing triggers into Version 2 or CTS Mode Version 3. See Qlik Replicate Trigger SAP HANA conversion from Version 1 to Version 2 or Version 3 for details.
Contact Qlik Support if you plan to convert your triggers, as additional migration steps may be needed to avoid data loss.
Best Practice
- Qlik Replicate SAP HANA Trigger Base using SAP Application (DB) as the Source
Qlik Replicate can now use SAP HANA as the Backend Database, which you can define on the SAP Application (DB) Source Endpoint setting with Triggers in SAP HANA.
Release Updates
Fixes
Qlik Replicate May 2023 Patch 3
(Build 2023.5.413)
Jira issue: RECOB-7506
Type: Issue
Component/Process: SAP Application (DB)
Description: When the last batch contained operations on clustered tables, some changes would sometimes not be captured after detach/attach or stop/resume.
Jira issue: RECOB-7477
Type: Issue
Component/Process: SAP Extractor Source
Description: An ABORT of a delta extractor job during change capture would result in a table being suspended, instead of a recoverable error.
Jira issue: RECOB-7456
Type: Issue
Component/Process: SAP ODP
Description: When unloading failed, it would be reported as completed instead of failed.
Jira issue: RECOB-7440
Type: Enhancement
Component/Process: SAP ODP
Description: Added support for CDS views that have mandatory parameters.
Jira issue: RECOB-7414
Type: Issue
Component/Process: SAP Extractor Source
Description: Import of the Transport to a SAP Application Server would fail due to vulnerability issues.
Jira issue: RECOB-7415
Type: Issue
Component/Process: SAP ODP
Description: When Current Data mode was enabled, Full Load would not replicate any records and the following error would occur during CDC: java.lang.String incompatible with java.math.BigDecimal
Qlik Replicate May 2023 Patch 2
(Build 2023.5.322)
Jira issue: RECOB-6976
Type: Enhancement
Component/Process: SAP HANA Source (Trigger CTS mode)
Description: Added support for a configurable sleep interval after an empty Trigger Table session.
Jira issue: RECOB-7390
Type: Issue
Component/Process: SAP Extractor Source
Description: When Extractor unload job failed or was canceled on the SAP side, the extractor status would be changed to Completed instead of Suspended.
Jira issue: RECOB-7323
Type: Issue
Component/Process: SAP Extractor Source
Description: When a specific Extractor Full Load was aborted, the next Full Load would replicate the data retrieved by the aborted Extractor Full Load.
Jira issue: RECOB-7348
Type: Issue
Component/Process: SAP Application (DB)
Description: SAP Pool table numeric values less than 0.1 would be replicated incorrectly.
Jira issue: RECOB-7334
Type: Issue
Component/Process: SAP ODP Source
Description: Scheduler log messages would show an incorrect data set name and wrongly formatted time.
Jira issue: RECOB-7262
Type: Issue
Component/Process: SAP ODP Source
Description: Data conversion problems would result in task failure or incorrect data replication.
Jira issue: RECOB-7158, RECOB-6925
Type: Issue
Component/Process: SAP Extractor Source
Description: This resolves the following issues:
- DELTA per table would only start after all Full Loads completed
- Reloading a table would prevent all DELTAs
- An error in a table during Full Load would prevent DELTAs from scheduling
Jira issue: RECOB-7308
Type: Issue
Component/Process: SAP HANA Source (Trigger mode)
Description: After applying a transport for maintenance to ACDOCA all CDC INSERT and UPDATE activity would be replicated as DELETEs.
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
- SingleStore 8.X Target 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.