Hello Qlik Users,
To strengthen the reliability of the Qlik platform, Qlik is introducing limits for themes and extensions uploaded to Qlik Cloud. These limits will be introduced on January 24. Files which exceed these new requirements will fail to upload once the change has gone into effect.
Files uploaded before the change will continue to function as expected.
The new limits:
Archive size: 30MB (currently: no limit)This is larger than any theme currently deployed to Qlik Cloud. We recommend making themes as small as possible to ensure they do not impact the load time in Qlik Sense.
Max size of an individual file, uncompressed: 30MB (currently: 250MB) This is directly linked to the archive size.
Max total size of all files in a theme or extension, uncompressed: 100MB. This value is based on the uncompressed size of items in the archive; in most cases, users will be limited based on the maximum archive size of 30 MB.
Max number of files in archive: 500. If thetheme or extension has more files than this, consider leveraging a bundler to build similar file types together.
We expect the impactto be minimal, if not non-existent, but you are recommended to verify all the themes and extensions currently being developed.
For more information, see Guardrails will be added to archive properties for Extensions and Themes APIs.
Thank you for choosing Qlik,Qlik Support
...View More
We are excited to introduce tabular reporting from Qlik Cloud. Now customers can address common, centrally managed, tabular report distribution requirements from within a Qlik Sense Application! With tabular reporting, report developers can create custom and highly formatted XLS documents from Qlik data and Qlik visualizations; Governed Report Tasks can burst reports to any stakeholder, ensuring that the Qlik platform is the source for operational decisions, customer communications and more.
Some feature highlights:
Report template creation, using data and visualizations from a Qlik Sense App, all with the familiarity of Microsoft Office 365 using Add-in technology
Qlik Cloud governed report task control from within a Qlik Sense App
In app distribution list management to support burst report distribution to any stakeholder (internal or external)
Execution of Qlik NPrinting authored XLS report templates uploaded to Qlik Cloud
Powered by the Qlik Reporting Service, reports are delivered from a scalable cloud service that solves complex enterprise reporting jobs
Want to get started with your first Tabular Report?
Access our Getting Started section in your Qlik Cloud app (available for users with Can Edit permissions). Open your app, (a) choose your activity, and select (b) Reporting.
From here, you can begin with our introductory videos and configuration instructions:
Want to know more about Qlik’s Tabular Reporting feature?
See the Tabular Reporting introductory videos
To get started see Tabular reporting in Qlik Cloud Analytics
(new!) The future of Qlik Cloud Reporting:STT - Qlik Cloud Reporting Evolution
To access and discuss the Qlik NPrinting Technical Preview, go toQlik's Technical Previews
The Qlik Excel add-in can be deployed and installed for compatible web and desktop versions of Microsoft Excel within Microsoft 365 see Deploying and installing the Qlik add-in for Microsoft Excel and speak with your Office 365 administrator if you wish to deploy the capability
Generating tabular reports in Qlik Cloud Analytics is a value-add Qlik Reporting Service capability. Check with your service account ownerabout your Qlik Cloud subscription's included capacities. Please be aware that overage will be monitored and capped starting in 2024.
Adopting customers should familiarize themselves with guardrails and limits see Qlik Reporting Service specifications and limitation
Thank you for choosing Qlik,Qlik Support
...View More
Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.
The Techspert Talks session from December looked at Exploring Data Essentials with Qlik Cloud.
But wait, what is it exactly?Techspert Talks is a free webinar held every month, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
In this session, we cover:
Navigating the Qlik Cloud Hub
Leveraging Collaboration tools
Best practices for finding insights
Click on this link to see the presentation.
...View More
Great news!
Qlik has recently introduced conversational analytics in Microsoft Teams. With our new Teams app, you can easily chat with Insight Advisor, Qlik's intelligent AI assistant, to explore data using natural language directly within Teams.
Users can now ask questions through individual or group chat, and Qlik will respond with AI-generated data visualizations and insights using data from across your Qlik apps. And because it's Microsoft Teams, you can collaborate with others in real-time, collectively making decisions using the insights generated by Qlik. Insight Advisor within Teams provides a powerful new way to help more people find the right answers, make better decisions and collaborate together where and how they work.
Look for the Qlik app in the Teams App Store to get started.
Want to know more about Qlik's Conversational Analytics in Microsoft Teams?
We have put together resources to help you get started.
Video tutorials (SaaS in 60):
Introduction to Qlik Conversational Analytics in TeamsMicrosoft Teams Integration Setup - Part 1Microsoft Teams Integration Setup - Part 2
Qlik Documentation:
Accessing Insight Advisor Chat through external collaboration platformsExploring app content with conversational analytics in Microsoft TeamsManaging connections to external collaboration platformsAvailability of the Qlik chatbot app in Microsoft Teams
Thank you for choosing Qlik,Qlik Support
...View More
Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.
The Techspert Talks session from November looked at Using Kafka with Qlik Replicate.
But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
In this session, we will cover:
How Replicate works with Kafka
Kafka terminology
Configuration best practices
Click on this link to see the presentation
...View More
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 theQlikData Integrationtopic to be notified of future editions!
Index
WebinarResource HighlightsReminder: Qlik Replicate November 2023 and FIPSKnowledgebase ArticleEndpoint Spotlight: SAPNew Issues ReportedTips!Best PracticeRelease UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Replicate End of Life Versions
Webinar
Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and TargetsQ&A sessionscheduled forOctober 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 compliantfor 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 Target 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 Targetfor 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. SeeQlik Replicate Trigger SAP HANA conversion from Version 1 to Version 2 or Version 3for 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 SourceQlik 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-7506Type:IssueComponent/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-7477Type:IssueComponent/Process:SAP Extractor SourceDescription: 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-7456Type: IssueComponent/Process: SAP ODPDescription: When unloading failed, it would be reported as completed instead of failed.
Jira issue: RECOB-7440Type: EnhancementComponent/Process: SAP ODPDescription: Added support for CDS views that have mandatory parameters.
Jira issue: RECOB-7414Type:IssueComponent/Process:SAP Extractor SourceDescription: Import of the Transport to a SAP Application Server would fail due to vulnerability issues.
Jira issue: RECOB-7415Type: IssueComponent/Process: SAP ODPDescription: 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-6976Type:EnhancementComponent/Process:SAP HANA Source (Trigger CTS mode)Description:Added support for a configurable sleep interval after an empty Trigger Table session.
Jira issue:RECOB-7390Type:IssueComponent/Process:SAP Extractor SourceDescription: 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-7323Type:IssueComponent/Process:SAP Extractor SourceDescription: 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-7348Type:IssueComponent/Process: SAP Application (DB)Description:SAPPool table numeric values less than 0.1 would be replicated incorrectly.
Jira issue:RECOB-7334Type:IssueComponent/Process:SAP ODP SourceDescription: Scheduler log messages would show an incorrect data set name and wrongly formatted time.
Jira issue:RECOB-7262Type:IssueComponent/Process:SAP ODP SourceDescription:Data conversion problems would result in task failure or incorrect data replication.
Jira issue:RECOB-7158, RECOB-6925Type:IssueComponent/Process:SAP Extractor SourceDescription: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-7308Type:IssueComponent/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 logList 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.
...View More
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 theQlikData Integrationtopic to be notified of future editions!
Index
WebinarResource HighlightsQlik Replicate November 2023 and FIPSKnowledgebase ArticleEndpoint Spotlight: DB2New Issues ReportedTips!Best PracticeRelease UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Replicate End of Life Versions
Webinar
Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and TargetsQ&A sessionscheduled forOctober 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 compliantfor details.
Knowledgebase Article
Endpoint Spotlight: DB2
Find our latest knowledge base articles for DB2 endpoints.
New Issues Reported
Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredThe Qlik Replicate service pack 02 release for 2023.5 includes old R4Z installation files from the previous SP01 build.
To upgrade the R4Z component, additional files need to be downloaded and installed. See Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download requiredfor details.
SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.Qlik Replicate with a DB2 z/OS source endpoint (using R4Z) displays authorization and privilege errors. SeeQlik Replicate DB2 z/OS - [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 42501 NativeError: -551 Message: [IBM][CLI Driver][DB2] SQL0551Nfor more information and how to resolve the issue.
Tips!
R4Z Db2 mainframe install is completed but no Changes are coming throughCheck that the Tables you wish to be performing CDC replication upon, have been "turned on" for capturing the changes from the DB2 z/OS Logs. SeeQlik Replicate: R4Z DB2z No CDC coming throughfor details.
Qlik Replicate DB2 z/OS task may stop/fail withR4DB2: ALL CB ENTRIES ARE IN USEThis means that a task is trying to start, but the maximum number of R4Z Control Blocks (in the R4Z CDC service environment on the mainframe) is in use. Find the resolution in Qlik Replicate: DB2 z/OS R4Z [SOURCE_CAPTURE ]W: R4DB2: ALL CB ENTRIES ARE IN USE.
Best Practice
Match R4Z and Qlik Replicate versionsThe 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:
QlikReplicate_2022.5.0.499_X64.zip (the Replicate installer)
QlikReplicate_2022.5.0.290_r4z.zip (the R4Z installer).
How to avoid WLM tasks being cancelled due to Work Load Manager Policy settingsWhen 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 cancelledfor details.
Release Updates
Fixes
Qlik Replicate May 2023 Patch 3
ID:RECOB-7408Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: The capture process would not recover from a communication error in the metadata connection.
ID:RECOB-7385Type: IssueComponent/Process: IBM DB2 for z/OS SourceDescription: 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-7220Type: IssueComponent/Process: DB2 z/OS SourceDescription: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs.
Qlik Replicate May 2023 Patch 2ID: RECOB-7311Type: EnhancementComponent/Process: IBM DB2 for z/OS TargetDescription: Performance was improved when using the zload utility to load files.
ID: RECOB-7146Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription: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-7114Type: IssueComponent/Process: IBM DB2 for z/OS TargetDescription: 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 logList 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.
...View More
Edited 20th November 2023: CVE number updated.Edited December 1st 2023: Added November 2023 IR release
Hello Qlik Users,
A security issue in Qlik Sense Enterprise for Windows has been identified, and patches have been made available. Details can be found in the Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365).
Today, we have released eight service releases across the latest versions of Qlik Sense to patch the reported issues. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted:
August 2023 Patch 1
May 2023 Patch 5
February 2023 Patch 9
November 2022 Patch 11
August 2022 Patch 13
May 2022 Patch 15
February 2022 Patch 14
November 2021 Patch 16
No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. The listed fixes also address CV-2023-41266 and CVE-2023-41265 (link).
November 2023 IR
August 2023 Patch 2
May 2023 Patch 6
February 2023 Patch 10
November 2022 Patch 12
August 2022 Patch 14
May 2022 Patch 16
February 2022 Patch 15
November 2021 Patch 17
This issue only impacts Qlik Sense Enterprise for Windows. Other Qlik products including Qlik Cloud and QlikView are NOT impacted.
All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Sense.
Qlik provides patches for major releases until the next Initial or Service Release is generally available. See Release Management Policy for Qlik Software. Notwithstanding, additional patches for earlier releases may be made available at Qlik’s discretion.
The information in this post and Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365)is disclosed in accordance with our published Security and Vulnerability Policy.
Clarifications and Frequently Asked Questions:
What can be done to mitigate the issue?
No mitigation can be provided. An upgrade should be performed at the earliest. As per Qlik's best practices, the proxy should not be exposed to the public internet, which reduces theattack surface significantly.
What authentication methods are affected?
All authentication methods are affected.
Are environments with HTTP disabled impacted?
Environments will be affected regardless if HTTP or HTTPS are in use. These vulnerabilities affect the HTTP protocol overall, meaning even if HTTP is disabled, the environment remains vulnerable.
These attacks don’t rely on intercepting any communication, and therefore, are indifferent whether the HTTP communication is encrypted or not.
Kind regards, and thank you for choosing Qlik,
Qlik Global Support
...View More
Hello Qlik Users,
Beginning October 10, 2023, access to the tenant recovery URL for tenants (https://<tenant name>.<region>.qlikcloud.com/login/recover) will be restricted to the Service Account Owner of the tenant. This update is performed on all Qlik Cloud tenants to handle circumstances in which the service account owner for a tenant was changed or will be changed.
If you are using the recovery login URL to access your tenant regularly, we recommend you use the standard login URL for your tenant (https://<tenant name>.<region>.qlikcloud.com/login) instead. You cannot access the tenant through the recovery login after October 10, 2023.
Thank you for choosing Qlik,Qlik Support
...View More
Welcome to August'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 theQlikData Integrationtopic to be notified of future editions!
Index
Resource HighlightsReminder! Qlik Replicate Endpoint RetirementKnowledgebase ArticleEndpoint Spotlight: DatabricksNew Issues ReportedTips!Release UpdatesFixesUpcoming EnhancementsTroubleshooting tipsAnalyze Qlik Replicate LogsQlik Data Integration Product End of Life Versions
Resource Highlights
Reminder! Qlik Replicate Endpoint Retirement
As of July 31st, 2023, the following endpoints have been retired:
Source Endpoints:
HP Non-Stop Source
Open VMS RMS Source
Hadoop Source
Target Endpoints:
MapR Target
MapR Streams Target
MS APS PDW Target
SAP Sybase IQ Target
HP Vertica Target
Actian Vector Target
Netezza Target
Pivotal Greenplum Target
SeeRetirement for Specific Qlik Replicate Endpointsfor details.
Knowledgebase Article
Endpoint Spotlight: Databricks
Find our latest knowledge base articles for Databrick endpoints.
New Issues Reported
Error SSL_connect: wrong version number when using Databricks Lakehouse (Delta) as target
Find the resolution in Qlik Replicate with Databricks Lakehouse (Delta) as target: Error SSL_connect: wrong version number.
Performing operations in transactions apply mode is not supported with Databricks Lakehouse (Delta) as target
TheApply Changesreplication mode supports tables with a Primary Key only. For solutions seeQlik Replicate with Databricks Lakehouse (Delta) as target: Performing operations in transactions apply mode is not supported in log.
Table is failing on full load when loading into Microsoft Azure Databricks Delta Target
Find the resolution inQlik Replicate: Table is failing on full load when loading into Microsoft Azure Databricks Delta Target.
Qlik Replicate Server crashes when browsing databases in Microsoft Azure Databricks Target
ClickingBrowsein the database endpoint settings of a Microsoft Azure Databricks target crashes the Qlik Replicate server.Find the resolution inQlik Replicate Server crashes when browsing databases in Microsoft Azure Databricks Target.
Tips!
Qlik Replicate and Databrick Unity Catalog feature flag support
Qlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02. SeeQlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02for details.
Qlik Replicate: Databricks Operations per second is over the account limit
Qlik Replicate tasks may fail with Operations per second is over the account limiterrors. Find the resolution in Qlik Replicate: Databricks Operations per second is over the account limit.
Best Practice:Qlik Replicate: Databricks Delta Wstring data type truncation
Starting withDatabricks Delta Driver version to 8.x and above, Varchar data type will be used for strings. Varchar data type is no longer limited by this character size so no truncation will occur when Wstring data type is used with limits higher than 255 characters.
Release Updates
Fixes
Qlik Replicate May 2023 patches
Component/Process: Databricks (Cloud Storage)
Description: When reconnecting after recoverable error on uploading file, the last file does not get uploaded, resulting in missing data.
Component/Process: Databricks Lakehouse (Delta)
Description: When using merge, if one of the columns in a Unique Index was NULL the changes would not be applied correctly. The issue was resolved using a Feature Flag at task and server level.
Upcoming Enhancements
Qlik Replicate August 2023 IR
New Confluent Endpoint (based on Kafka)
S3 authentication support with AWS IAM Roles Anywhere on S3/Redshift endpoints
Ability to Set Isolation Level on ODBC with CDC (Ability to Set Isolation Level on ODBC with CDC)
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
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 logList of the error types in Qlik Replicate
Qlik Data Integration Product End of Life Versions
Qlik Release
Qlik Replicate / Enterprise Manager
End of Support Date
Qlik Compose
End of Support Date
February 2021
November 2020 SR1
November 2022
February 2021
February 2023
May 2021
May 2021
May 2023
May 2021
May 2023
August 2021
May 2021 SR1
May 2023
August 2021
August 2023
November 2021
November 2021
November 2023
November 2021
November 2023
For more information, see Qlik Product Lifecycles.
...View More