Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I’ve configured a replication task that reads from a Log Stream and replicates data to a Snowflake target with Apply Changes Processing enabled, meaning that changes are applied directly to the target tables in Snowflake. The source of the Log Stream is an Oracle database.
Moreover, I’ve implemented a soft-delete logic in this task by adding a technical field defined as follows:
CASE ifnull(operation_indicator('DELETE','UPDATE','INSERT'),'null')
WHEN 'null' THEN 'INSERT'
ELSE operation_indicator('DELETE','UPDATE','INSERT') ENDOccasionally, operations are performed on the source that modify primary key fields. I’d like to understand if it’s possible to transform the UPDATE into a DELETE of the record with the previous key, followed by an INSERT of the record with the new key.
As I understand it, the “DELETE and INSERT when updating a primary key column” option available in Apply Changes Processing cannot be used to achieve this because for the Snowflake target endpoint this option applies only to Change Tables, not to the actual target tables.
However, I noticed that there is also an “Apply changes using SQL MERGE” option. If I understand correctly, this option works as follows: “for a standard UPDATE, Qlik Replicate generates a MERGE INTO statement. However, if the UPDATE modifies primary key values, Qlik Replicate will not use MERGE INTO; instead, it will apply the change as a DELETE + INSERT pair for that row”.
This behavior is described in the following article:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Implementing-UPSERT-and-MERGE-modes-by-applying-a/ta-p/1780009.
If this is how SQL MERGE operates, would implementing a soft-delete logic mean that, when a primary key changes, the target table would contain the record with the old primary key marked as deleted (soft-deleted) and the record with the new primary key inserted as a new record?
Thank you in advance for your support.
Best regards
Hi, we have several automations under development, each of which were fine last week. Today, we wanted to change the name of one of them, so attempted to open the automation settings, and it raised the alert "Unauthorized: You do not have access to this automation. Contact your system administrator for more information."
We have tried opening these settings on other automations, and get exactly the same. Edits to the automation blocks are working fine, so why are they being shown as unauthorized for the settings?
Note: I am the administrator and, as far as I can see, the account attempting to open the automation settings is the owner of the automation, and no roles or permissions have been changed between last week and this.
Thanks.
Hi everyone!
If you develop in Qlik Sense, you know the scene: the load script changed, the number on the dashboard changed with it, and nobody knows who changed it, when or why. To solve this, we built Versiona CuboPlus, a free extension for Chrome and Edge that keeps the history of your load script in your company's Git repository.
Intro video:
How it works
Where it works
Security
For client-managed, there is also an optional nightly routine in PowerShell for GitLab, open source, that stores overnight whatever changed without going through the extension.
Download and more
It is free. If you try it, tell us here what you think, and leave a review on the Chrome Web Store.
Suggestions and bug reports are very welcome.
Follow CuboPlus on Instagram: @cubo.plus
I'm trying to setup a block to retrieve trust score information from datasets in my tenant. According to documentation I need to use a Qlik Cloud Services - Raw API Request and point to
api/data-governance/trust-scores/results/data-sets/actions/filter
After running the automation this is the response
{ "response": { "status": 404, "body": { "error": "Unknown Service (url: https://mytenantid.us.qlikcloud.com/api/data-governance/trust-scores/results/data-sets/actions/filter)" } }, "external error": false }
I've tried using curl to call this endpoint externally and it works fine.
Olá, pessoal!
Quem desenvolve no Qlik Sense conhece a cena: o script de carga mudou, o número do painel mudou junto, e ninguém sabe quem alterou, quando nem por quê. Para resolver isso, criamos o Versiona CuboPlus, uma extensão gratuita para Chrome e Edge que guarda o histórico do script de carga no repositório Git da sua empresa.
Vídeo de apresentação:
Como funciona
Onde funciona
Segurança
Para quem usa client-managed, há também uma rotina noturna opcional em PowerShell para GitLab, com o código aberto, que guarda de madrugada o que mudou sem passar pela extensão.
Onde baixar e sobre
É gratuito. Se testarem, contem aqui o que acharam e deixem uma avaliação na Chrome Web Store.
Sugestões e relatos de problema são muito bem-vindos.
Sigam a CuboPlus no Instagram: @cubo.plus
Hello Qlik Community,
I'm reaching out for help with some vulnerability issues identified by our Infosec team using the Qualys tool. We're currently using QlikSense May 2024 Patch 21, and the issues are related to the Node JS version used by Qlik to build its application.
Node JS Version Issues
The QlikSense version we're using relies on Node JS 1.7.8, which has numerous vulnerabilities and has reached its end of life, as stated in the article. One specific issue is related to Angular JS, but our team has also identified around 80 security/vulnerability open points for other dependencies like Koa, body-parser, Braces and many more, out of which some of them have received fixes for the issues.
Request for Information
My assumption is that these issues are all bundled together and are a problem with the NodeJs version being used and that they might be resolved if Qlik upgrades the Node JS version used in QlikSense. I'd like to know if Qlik has already addressed these issues in a recent version of QlikSense on Windows or if they plan to fix them in an upcoming patch.
Critical and High Issues
The vulnerability list shared with me contains many Critical (6), High (30), Medium (34) & Low (10) priority issues I'd appreciate any guidance on how to proceed with resolving these issues.
If anyone has information on this topic or knows what steps I can take next, please let me know.
Thank you in advance for your help!
Best regards, Charvick
Hello all,
How do you de-allocate licenses automatically for users that are removed from an AD group?
E.g. We have 7,000 users and people leave or change status all the time yet I am still finding that a Qlik Sense license has been allocated to a user that is now "Removed externally".
What is the best way to manage licenses for these users?
From https://www.aikido.dev/blog/node2shell-nodejs-brotli-rce-cve-2026-111497
Node.js shipped a security update on Wednesday for a flaw in how it decompresses Brotli data, a bug people are already calling Node2Shell (CVE-2026-111497). If an attacker can get a malicious payload in front of your app, the flaw can crash the process, leak part of its memory, or potentially let them run their own code.
Who is affected: anyone running Node.js or Bun whose app decompresses Brotli data that an attacker could control.
Ok, so Qlik Sense Enterprise on Windows runs on Node.js 24.14.1.
I have the following questions:
1. Does the specific implementation of a vulnerable Node.js version in Qlik Sense Enterprise on Windows implicate a threat to installations of Qlik Sense?
2. Are there any migitating actions that can be undertaken by administrators to continue operating safely until Qlik Sense/Node.js is patched?
3. Is there a patch coming? If so, when is this expected to be made available?
Qlik Sense: standalone Node.js update following the October 2026 security release
Following the Node.js security release of October 21, 2026, including the Brotli vulnerability CVE-2026-111497, I tested updating the Node.js binary bundled with Qlik Sense independently of a Qlik patch.
The test passed on Qlik Sense Enterprise on Windows May 2026 Patch 7, updating Node.js 24.18.1 to 24.22.1 This is a result from one environment, not a compatibility guarantee for every deployment.
This method is not validated by Qlik. Qlik's documented approach is to update bundled Node.js through a Qlik Sense upgrade. Test in development first, with a maintenance window and a recoverable full backup.
Check your current bundled Node.js version
Run in PowerShell:
& "$env:ProgramFiles\Qlik\Sense\ServiceDispatcher\Node\node.exe" --version
Using the full path checks Qlik's copy rather than another Node.js installation on the PATH.
Run the scripts
1. Extract the attached scripts into one folder.
2. Download the [official Windows x64 node.exe](https://nodejs.org/dist/v24.22.1/win-x64/node.exe).
3. Edit `NodeUpdate.config.psd1`: set the binary, backup and log paths, and the official SHA256 for "win-x64/node.exe" from SHASUMS256.txt.
4. In Windows PowerShell 5.1 as administrator, run:
.\01_Backup_Node.ps1
Continue only after BACKUP VERIFIED.
.\02_Update_Node.ps1
Leave the Service Dispatcher running before Update: the script handles stopping and restarting it. Relative paths are resolved against the configuration folder; execution is local to each machine.
Test Hub, QMC, application access, exports, reloads and your usual connectors, and check Qlik logs. These are recommended checks, not a list of checks confirmed by the test above.
For rollback, set `RestoreBackupDirectory` to the exact original backup folder and run:
.\03_Restore_Node.ps1
The scripts target the main Service Dispatcher on Node.js 24 only. They do not update EAPowerTools, Package Cache or npm dependencies. A binary backup is not a full site backup, and automatic rollback is not guaranteed. Recheck the installed version after subsequent Qlik maintenance.
References:
Hi,
Our Network Security team has recommended adding the following security headers to our Qlik Sense environment:
X-Frame-Options: Sameorigin/deny
X-XSS-Protection : 1; mode=block
X-Content-Type-Options : nosniff
Content-Security-Policy : script-src 'self'
X-Permitted-Cross-Domain-Policies
Referrer-Policy : no-referrer
Cross-Origin-Opener-Policy: same-origin
Strict-Transport-Security: max-age=31536000; includeSubDomains; preload Cache-Control:
no-store, max-age=0
Pragma: no-cache
Has anyone implemented these headers in Qlik Sense Enterprise on Windows? I’d appreciate guidance on:
Thanks in advance!
Regards,
Tushar C.
Navigation Deferring platform decisions? The Qlik Open Lakehouse Calculator puts a real cost to the status quo.
Qlik is a Leader in the IDC Events/Global Events MarketScape: Worldwide Data Intelligence Platform Software 2026 Vendor Assessment
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.