Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Product Innovation
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
Support Updates
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
Qlik Academic Program
This blog was created for professors and students using Qlik within academia.
Community News
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
Qlik Digest
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
Qlik Education
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Recent Blog Posts
-
Stitch: Google Ads Major Version Release and sunsetting of Google Ads API versio...
Hello Stitch Admins, Stitch has released a new version of its Google Ads integration. With this release comes an update to Google Ads V2, which utilizes the latest Google Ads API (version 20). The previously used Google Ads API version 18 will be sunset by Google on August 20th, 2025. Once the API is sunset, integrations that interact with it will stop working. What do I need to do? Create a new integration to stay ahead of Google sunsetting ver... Show MoreHello Stitch Admins,
Stitch has released a new version of its Google Ads integration. With this release comes an update to Google Ads V2, which utilizes the latest Google Ads API (version 20).
The previously used Google Ads API version 18 will be sunset by Google on August 20th, 2025. Once the API is sunset, integrations that interact with it will stop working.
What do I need to do?
Create a new integration to stay ahead of Google sunsetting version 18. We've put together a general guide to assist you.
Using a new schema name
If you are creating a new integration and don't plan on reusing the previous schema name, you can go ahead and make a new Google Ads integration. Selecting Google Ads from the integration options will default to the latest version, in this case, V2. The new integration will also benefit from the 7-day free historic sync.
Re-using the schema name
If you need to use the same schema name for the new integration, you must do the following:
- Pause the existing integration(s) in your Stitch account.
- Wait for any records that are being prepared to finish loading (such as waiting for Preparing to reflect 0 rows in the integration summary page).
- Take note of the tables and fields tracked for replication, as well as the replication methods defined for these tables.
- Delete the existing integration from your Stitch account.
- Drop or rename the existing schema from your destination data warehouse. We recommend renaming the schema to preserve the data and maintain flexibility to adjust downstream workflows.
- Contact Qlik Support to coordinate a manual row-usage exemption for this integration.
- Configure a new integration with the same name, and Stitch will create this schema in your destination during the loading process.
Frequently Asked Questions
Q: Can I copy over my bookmarks to the new integration?
A: Bookmarks cannot be covered over. When you create a new integration, every table will perform a full table replication from the start date set in the settings. Once the historic sync is complete, it will move to the selected replication method. There is no mechanism to manually set bookmarks, and individual integrations have no interaction with each other, even in upgrades.Q: What if I need more than 7 days to complete the historic sync?
A: Reach out to Qlik Support for a manual exemption. Please explain why you need more time, and we will accommodate accordingly.Q: Will the data structure be the same in the new integration?
A: We cannot guarantee the data structure is the same as it is determined by Google Ads API. If you are looking for field or table changes, please reference the Google Ads API comparison guides (Upgrade from v18 to v19 and Upgrade from v19 to v20). If you are missing data, reference Google's documentation to confirm it hasn't moved or been removed. In the event Google says data should exist, but it is not replicated, raise a ticket to Qlik Support to review and investigate.If you have any questions, we're happy to assist. Contact Support, reply to this blog post, or take similar queries to the Stitch forum. And if you want to stay up to date for Stitch-specific Support Updates, don't forget to subscribe!
Thank you for choosing Qlik,
Qlik Support -
Legacy Qlik Analytics Connectors for Amazon S3 to be deprecated in 2025
In an effort to give customers the necessary time to carry out the migration, Qlik has delayed the removal of our legacy S3 connectors. See the updated dates below.Please proceed with the migration as soon as possible as no further extension will be possible. The following connectors will be removed and are not recommended for further use: Amazon S3 Metadata Amazon S3: this is a “File location” connector Instead, use the following connectors:... Show MoreIn an effort to give customers the necessary time to carry out the migration, Qlik has delayed the removal of our legacy S3 connectors. See the updated dates below.
Please proceed with the migration as soon as possible as no further extension will be possible.The following connectors will be removed and are not recommended for further use:
- Amazon S3 Metadata
- Amazon S3: this is a “File location” connector
Instead, use the following connectors:
- Amazon S3 Metadata V2
- Amazon S3 V2: this is a “File location” connector
The connectors labeled with the suffix “V2” were introduced in 2022 and have since then been the recommended connectors for access to Amazon S3 buckets.
The V2 connectors access Amazon S3 buckets based on the AWS SDK for .NET Core, whereas the legacy S3 connectors were based on the REST API.
The plans to remove the legacy S3 connectors are as follows:
- Qlik Sense Cloud: by the end of August 2025
- Qlik Sense Enterprise on Windows: release November 2025
- Qlik Web Connector (standalone): release June 2025
The legacy S3 connectors and the S3 connectors “V2” have the exact same capabilities, and a migration will in most cases only require a new connection definition and an update in the connection name within the Qlik Script.
Additional Reading
If you have any questions, do not hesitate to contact us through the Qlik Customer Portal.
Thank you for choosing Qlik,
Qlik Support -
Using Layout Containers to Lock a Section of a Sheet
An explanation of a problem faced while updating an app, and the solution. -
Qlik Sense Enterprise for Windows - New Security Patches Available Now
Edited 20th of May 2024: Added recently assigned CVE number.Edited 22nd of May 2024: Added to the Frequently Asked Questions. 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 Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-36077). Today, we have released eight service releases across the latest... Show MoreEdited 20th of May 2024: Added recently assigned CVE number.
Edited 22nd of May 2024: Added to the Frequently Asked Questions.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 Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-36077).
Today, we have released eight service releases across the latest versions of Qlik Sense to patch the reported issue. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted:
- February 2024 Patch 3
- November 2023 Patch 8
- August 2023 Patch 13
- May 2023 Patch 15
- February 2023 Patch 13
- November 2022 Patch 13
- August 2022 Patch 16
- May 2022 Patch 17
No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. May 2024 IR, released on the 14th of May, contains the fix as well.
- May 2024 Initial Release
- February 2024 Patch 4
- November 2023 Patch 9
- August 2023 Patch 14
- May 2023 Patch 16
- February 2023 Patch 14
- November 2022 Patch 14
- August 2022 Patch 17
- May 2022 Patch 18
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.
The information in this post and Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-36077) are disclosed in accordance with our published Security and Vulnerability Policy.
Frequently Asked Questions
Q: What steps can be used to reproduce the vulnerability?
A: Qlik will not be providing steps on how to reproduce this test case.Q: What authentication method is affected?
A: Qlik strongly recommends moving to a patched version as per the bulletin, regardless of the authentication method used.Q: Will Qlik Sense February 2022 or earlier be patched?
A: See the Qlik Sense Enterprise on Windows Product Lifecycle (link) for information on what versions of Qlik Sense have reached End of Service (EOS). Versions which have reached EOS will not receive patches and Qlik strongly recommends moving to an up to date release.The Security Notice label is used to notify customers about security patches and upgrades that require a customer’s action. Please subscribe to the ‘Security Notice’ label to be notified of future updates.
Thank you for choosing Qlik,
Qlik Global Support
-
Clarification regarding new and old tables in Qlik Analytics
Hello Qlik Users, The new Straight Table was moved into the new native section of charts from the visualization bundle. The new Straight Table offers many improvements from the old table, and we encourage everyone to start using the new table instead of the old one. We've put together an article that aims to answer any frequently asked questions around this switch, beginning with: The old table will not be removed anytime soon. It will continue ... Show MoreHello Qlik Users,
The new Straight Table was moved into the new native section of charts from the visualization bundle. The new Straight Table offers many improvements from the old table, and we encourage everyone to start using the new table instead of the old one.
We've put together an article that aims to answer any frequently asked questions around this switch, beginning with:
- The old table will not be removed anytime soon. It will continue to work until further notice. We encourage you to subscribe to the Qlik Support Blog and What's New in Qlik Cloud to stay ahead of updates.
- The old table will not be updated further. Use the new table to benefit from future improvements.
- We monitor your feedback and will improve the functionality of the new table.
To read up on new features, as well as how to replace the old table, head over to The new Straight Table and old Table (retired) in Qlik Analytics.
Questions? We're only a comment or a chat away.
Thank you for choosing Qlik,
Qlik Support -
From Data to Insights: A Journey with the Qlik Academic Program
In an era where data drives innovation, decision-making, and efficiency across every industry, the need for data-literate professionals has never been more pressing. That’s where the Qlik Academic Program comes in—a free initiative designed to equip university educators and students with the skills and tools necessary to thrive in the data analytics field. -
Qlik Dropbox connectors: Deprecation of long-lived access tokens
Hello Qlik admins and developers, Previously, the Dropbox API used only long-lived access tokens. These long-lived access tokens have been deprecated since the fall of 2022, and only short-lived access tokens are created. Long-lived tokens remain usable for existing authentications. The Qlik Dropbox connectors have maintained the use of long-lived access tokens, and it is now time to deprecate these tokens and remove them. We aim to end support f... Show MoreHello Qlik admins and developers,
Previously, the Dropbox API used only long-lived access tokens. These long-lived access tokens have been deprecated since the fall of 2022, and only short-lived access tokens are created. Long-lived tokens remain usable for existing authentications.
The Qlik Dropbox connectors have maintained the use of long-lived access tokens, and it is now time to deprecate these tokens and remove them. We aim to end support for long-lived tokens by October 31, 2025.
What action do I need to take?
Re-authenticate to avoid interruption.
You will not have to take action for connection definitions created in Qlik products released from 2023 and onwards, and which were created or re-authenticated after 2022.
This is applicable to the following scenarios:
- Qlik Sense: Client Managed and Qlik Cloud
- Dropbox file location connector
- Dropbox Metadata connector
- Qlik Web Connector Standalone
- Qlik Dropbox Connector
If you are using a long-lived access token in a Dropbox connection definition, you must follow the steps below to re-authenticate. This can be done proactively at any time, which will avoid the connections from breaking.
What if I do not re-authenticate in time?
Your connections will stop working once the long-lived access token expires. You can still re-authenticate in the same way at a later time; your connection will be repaired, and your reloads will work again.
Is there some way for me to identify the connections?
Unfortunately, there is no indication showing which type of token is used. However, if you are not sure when the connection was created or last re-authenticated, there is no harm in re-authenticating, regardless of whether it is necessary or not.
How to re-authenticate in Qlik Sense: Client Managed and Qlik Cloud
To re-authenticate the Dropbox connectors in Qlik Sense, update the connection within the Data load editor, then select Authenticate and follow the on-screen process to retrieve a new Authentication Code. Verify and Save the connection when done.
How to re-authenticate the Qlik Web Connector: Standalone
Re-authenticate via the CanAuthenticate table by selecting to Clear the current Authentication Token, and then Authenticate to get a new Authentication Token. Save and Run when done.
Additional recommendations
While performing this review of your Dropbox connection definitions, it may also be an opportunity to remove any redundant connection definitions not in use.
If you have any questions, we're happy to assist. Reply to this blog post or start a chat with us.
Thank you for choosing Qlik,
Qlik Support - Qlik Sense: Client Managed and Qlik Cloud
-
Qlik Application Automation execution token changes
Hello Qlik Users, On January 13th 2025, Qlik will introduce breaking changes to the execution token functionality for triggered automations. Contents What does this mean for my triggered automation?How do I configure the Run Mode?Additional change: Execution tokens become header parameters (Q2 2025)Related improvement: custom parameter support for button-triggered automations What does this mean for my triggered automation? Triggered automa... Show MoreHello Qlik Users,
On January 13th 2025, Qlik will introduce breaking changes to the execution token functionality for triggered automations.
Contents
- What does this mean for my triggered automation?
- How do I configure the Run Mode?
- Additional change: Execution tokens become header parameters (Q2 2025)
- Related improvement: custom parameter support for button-triggered automations
What does this mean for my triggered automation?
Triggered automations will require their Run Mode to be set to triggered to continue to work as expected. Past January 13th, it will no longer be possible to use the below endpoint to trigger an automation not explicitly configured with a triggered run mode:
api/v1/automations/{id}/actions/executeHow do I configure the Run Mode?
The run mode can be configured in the Start block of an automation:
- Open the Automation
- Select the Start Block
- Open the Inputs tab
- Select Triggered as the Run Mode
Additional change: Execution tokens become header parameters (Q2 2025)
An additional change to how execution tokens are used will be introduced at a later date. The change is planned for Q2 2025.
When triggering a triggered automation through the trigger URL (see the below endpoint) the execution token must be sent as a header parameter. Currently, it is possible to send the execution token as a query parameter. With Q2 2025, sending execution tokens as header parameters will eventually be enforced.
api/v1/automations/{id}/actions/executeRelated improvement: custom parameter support for button-triggered automations
When triggering an automation from a button in an app it is now possible to provide additional input parameters that are defined in the button configuration. More information can be found here: custom input parameters for the native button.
Don't hesitate to reach out if you have any questions or address our experts directly in the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support -
Introducing Shared Automations to Qlik Cloud Analytics
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space. Teams can create, organize, and manage automations in shared spaces. This setup makes it easy to control who can run, duplicate, and view, offering flexibility and security. -
New Learn page in Qlik Cloud Analytics
We’re excited to announce our new Learn page—designed to help you get the most out of Qlik. Whether you're just starting or looking to deepen your expertise, our platform offers outcome-based learning paths that guide you every step of the way. And it is integrated right into your Qlik Cloud Analytics experience, so learning is seamless and always at your fingertips. -
Calling All Educators: Let Qlik Help You Get Ahead This Fall
The fall semester is just around the corner—sooner than many of us would like! As you begin planning for another academic year, we know how much time and effort goes into designing course content, creating assignments, and building assessments. What if some of that work was already done for you? With the Qlik Academic Program, you’ll have access to ready-made curriculum materials, including lesson plans, assignments, quizzes, and even exams—all d... Show MoreThe fall semester is just around the corner—sooner than many of us would like! As you begin planning for another academic year, we know how much time and effort goes into designing course content, creating assignments, and building assessments.
What if some of that work was already done for you?
With the Qlik Academic Program, you’ll have access to ready-made curriculum materials, including lesson plans, assignments, quizzes, and even exams—all designed to help students build real-world data skills. You can use our resources as-is or tailor them to fit the unique needs of your class.
And you don’t have to go it alone. We’re here to help you integrate Qlik into your course, introduce your students to the platform, and get everyone up and running before the semester begins. Whether you want a quick onboarding session or a full student workshop, we’ll support you every step of the way.
By incorporating Qlik into your classroom, you’re not just preparing your syllabus—you’re helping students gain valuable skills that translate directly to the job market.
Let us help take one thing off your plate this fall. Reach out now to get started, and let’s make this semester a little less stressful—and a lot more impactful.
Please reach to me directly to get on the schedule! https://www.linkedin.com/in/brittany-fournier-27694176/
To sign up for our Academic Program, please go to: https://www.qlik.com/us/company/academic-program
-
Get to Know our Expert Instructors!
Traveling back across the ocean finds us in the southern European country of Portugal. Here you will find magnificent mountains, sun-filled white sand beaches, grandiose castles and palaces that seem to have come out of a fairy tale, and Fado, or Music of the World, that comes from within the Portuguese soul. -
Excel-Like Spreadsheets for Qlik
Excel-Like Spreadsheets for Qlik AnyChart See how Excel-style spreadsheets come alive in Qlik dashboards! Explore all major features of the new Spreadsheets extension for Qlik Sense introduced at Qlik Connect 2025. Discoveries Enable working with data just like in Excel with no learning curve. From editable tables and advanced formulas to formatting, validation, pivoting, and charting — everything happens right inside your Qlik Sense ... Show MoreExcel-Like Spreadsheets for QlikAnyChart
See how Excel-style spreadsheets come alive in Qlik dashboards! Explore all major features of the new Spreadsheets extension for Qlik Sense introduced at Qlik Connect 2025.
Discoveries
Enable working with data just like in Excel with no learning curve. From editable tables and advanced formulas to formatting, validation, pivoting, and charting — everything happens right inside your Qlik Sense apps.
Impact
Integrating Excel-like spreadsheets lets users interact with data without switching tools or context. This drives faster decisions, smoother collaboration, and higher dashboard adoption.
Audience
Anyone looking to bring familiar spreadsheet workflows into their Qlik Sense apps.
Data and advanced analytics
Powered by the Spreadsheets extension for Qlik Sense, this app uses fictional data to illustrate its key capabilities in action. From natively importing Excel templates and adding sparklines to running AI-driven transformations and predictive models.
-
Get Ready. An Improved Certification Experience is Coming!
We are excited to continue to improve your Qlik Learning experience! The next round of improvements will change how you take certification exams.
-
Happy Summer! Get Your Qlik Instructor-led Passport
It is summer time! Get your Passport... and take off with your learning Purchase your Passport
-
Welcome Our Newest Qlik Community MVPs: Sean Bruton & Fabian Quezada!
Congratulations to our new MVPs -
Line Chart Shapes
Enhancements have been made to the line chart plugin feature that allows point and lines to be added to the line chart. These enhancements include features such as labels for points and lines, placement options for labels, and point symbol, size and color styling options. In the chart below, there is a line chart showing the daily page views for a site over time. Notice the point annotations for the highest and lowest daily page views days. Let’... Show MoreEnhancements have been made to the line chart plugin feature that allows point and lines to be added to the line chart. These enhancements include features such as labels for points and lines, placement options for labels, and point symbol, size and color styling options. In the chart below, there is a line chart showing the daily page views for a site over time. Notice the point annotations for the highest and lowest daily page views days.
Let’s look at how these were created and the new features that are now available. Points and lines can be added to a line chart from the properties panel under Add-ons > Shapes.
The shape options that can be added are point and line. To add a point for the highest daily page views, a dimension value needs to be entered. It can be hard-coded, or it can be an expression. In this example, I used an expression to show the highest day in the current year. Measure input is set to measure index and the index is set to 0 to use the first measure in the line chart. Shown below are the styling options now available to use. Star was the symbol selected from the list of 7 options (circle, cross, diamond, saltire, square, star and triangle). The point color and outline are a color that stands out in the chart.
The same procedure was followed to add the symbol for the lowest daily page views. The expression was modified as well as the symbol and symbol color. The Colored background was checked to give a dark background to the label to make it easier to read.
Notice how these annotations highlight aspects about the line chart that may be significant or that the developer wants to point out. Let’s add a line to this chart to see what it looks like. To add a line to this chart that connects these points, a new line shape needs to be added with the value or expression for the line endpoints. Like the points, the line can be colored, and the line thickness, type and curve can also be styled.
These shapes do not replace the reference lines or dimension reference lines that can be added to a line chart. They can still be added to a line chart. The shapes feature should be used to add context to a line chart to enable better understanding. Check out Qlik Help to learn more.
Thanks,
Jennell
-
Qlik Talend Data Integration Client Managed May 2025 General Availability Releas...
The latest releases of Qlik Replicate and Qlik Enterprise Manager are now generally available. The May 2025 releases introduce a suite of powerful new features and enhancements designed to streamline your data integration further, improve performance, and expand connectivity across your enterprise data landscape. Here's a closer look at the key innovations and why they matter for your data strategy. -
Qlik Sense Migration: Migrating your Entire Qlik Sense Environment
Hi everyone, For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else. In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment. So, how do we do that? Introduction and preparationBackup your old environmentDeploy and rest... Show MoreHi everyone,
For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else.
In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment.
So, how do we do that?
- Introduction and preparation
- Backup your old environment
- Deploy and restore the new central environment
- What about my rim nodes?
- Finalizing your migration
- Data Connection
- Licensing
- Best practices
If direct assistance is needed and you require hands-on help with a migration, engage Qlik Consulting. Qlik Support cannot provide walk-through assistance with server migrations outside of a post-installation and migration completion break/fix scenario.
Introduction and preparation
Let’s start with a little bit of context: Say that we are running a 3 nodes Qlik Sense environment (Central node / Proxy-Engine node / Scheduler node).
On the central node, I also have the Qlik shared folder and the bundled Qlik Sense Repository Database installed.
This environment has been running well for years but I now need to move it to a brand new hardware ensuring better performance. It’s not possible to reinstall everything from scratch because the system has been heavily used and customized already. Redoing all of that to replicate the environment is too difficult and time-consuming.
I start off with going through a checklist to verify if the new system I’m migrating to is up to it:
- Do I meet the system requirements? Qlik Sense System Requirements
- Am I following virtualization best practices? Virtualization Best Practices In QlikView And Qlik Sense
And then I move right over to…
Backup your old environment
The first step to migrate your environment in this scenario is to back it up.
To do that, I would recommend following the steps documented on help.qlik.com (make sure to select your Qlik Sense version top left of the screen).
Once the backup is done you should have:
- A backup of the database in .tar format
- A backup of the content of the file share which includes your applications, application content, archived logs, extensions,…
- Backups of any data source files that need to be migrated and are not stored in the shared folder like QVDs
Then we can go ahead and…
Deploy and restore the new central environment
The next steps are to deploy and restore your central node. In this scenario, we will also assume that the new central node will have a different name than the original one (just to make things a bit more complicated 😊).
Let’s start by installing Qlik Sense on the central node. That’s as straightforward as any other fresh install.
You can follow our documentation. Before clicking on Install simply uncheck the box “Start the Qlik Sense services when the setup is complete.”
The version of Qlik Sense you are going to install MUST be the same as the one the backup is taken on.
Now that Qlik Sense is deployed you can restore the backup you have taken earlier into your new Qlik Sense central node following Restoring a Qlik Sense site.
Since the central node server name has also changed, you need to run a Bootstrap command to update Qlik Sense with the new server name. Instruction are provided in Restoring a Qlik Sense site to a machine with a different hostname.
The central node is now almost ready to start.
If you have changed the Qlik Share location, then the UNC path has also changed and needs to be updated.
To do that:
- Go to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil
- Run QlikSenseUtil.exe as Administrator
- Click on Connect to the database and enter the credential to connect to the new PostgreSQL database
- Click on Service Cluster and press OK. This should display the previously configured UNC Path
- You simply need to update each path, save and start/restart all the Qlik sense services.
At this point make sure you can access the Qlik Sense QMC and Hub on the central node. Eventually, check that you can load applications (using the central node engine of course). You can also check in the QMC > Service Cluster that the changes you previously made have been correctly applied.
Troubleshooting tips: If after starting the Qlik Sense services, you cannot access the QMC and/or Hub please check the following knowledge article How to troubleshoot issue to access QMC and HUB
What about my rim nodes?
You’ve made it here?! Then congratulations you have passed the most difficult part.
If you had already run and configured rim nodes in your environment that you now need to migrate as well, you might not want to remove them from Qlik Sense to add the new ones since you will lose pretty much all the configuration you have done so far on these rim nodes.
By applying the following few steps I will show you how to connect to your “new” rim node(s) and keep the configuration of the “old” one(s).
Let’s start by installing Qlik Sense on each rim node like it was a new one.
The process is pretty much the same as installing a central node except that instead of choosing “Create Cluster”, you need to select “Join Cluster”
Detailed instructions can be found on help.qlik.com: Installing Qlik Sense in a multi-node site
Once Qlik Sense is installed on your future rim node(s) and the services are started, we will need to connect to the “new” Qlik Sense Repository Database and change the hostname of the “old” rim node(s) to the “new” one so that the central node can communicate with it.
To do that install PGAdmin4 and connect to the Qlik Sense Repository Database. Detailed instruction in Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting knowledge article.
Once connected navigate to Databases > QSR > Schemas > public > Tables
You need to edit the LocalConfigs and ServerNodeConfigurations table and change the Hostname of your rim node(s) from the old one to the new corresponding one (Don’t forget to Save the change)
LocalConfigs table
ServerNodeConfigurations table
Once this is done, you will need to restart all the services on the central node.
When you have access back, login to the QMC and go to Nodes. Your rim node(s) should display the following status, “The certificate has not been installed”
From this point, you can simply select the node, click on Redistribute and follow the instruction to deploy the certificates on your rim node. After a moment the status should change and you should see the services being up and running.
Do the same thing on the remaining rim node(s).
Troubleshooting tips: If the rim node status is not showing “The certificate has not been installed” it means that either the central node cannot reach the rim node or the rim node is not ready to receive new certificates.
Check that the port 4444 is opened between the central and rim node and make sure the rim node is listening on port 4444 (netstat -aon in command prompt).
Still no luck? You can completely uninstall Qlik Sense on the rim node and reinstall it.Finalizing your migration
At this point, your environment is completely migrated and most of the stuff should work.
Data Connection
There is one thing to consider in this scenario. Since the Qlik Sense certificates between the old environment and the new one are not the same, it is likely that data connections with passwords will fail. This is because passwords are saved in the repository database with encryption. That encryption is based on a hash from the certs. When the Qlik Sense self-signed cert is rebuilt, this hash is no longer valid, and so the saved data connection passwords will fail. You will need to re-enter the passwords in each data connection and save. This can be done in the QMC -> Data Connections.
See knowledge article: Repository System Log Shows Error "Not possible to decrypt encrypted string in database"
Licensing
Do not forget to turn off your old Qlik Sense Environment once you are finished. While Qlik's Signed License key can be used across multiple environments, you will want to prevent accidental user assignments from the old environment.
Note: If you are still using a legacy key (tokens), the old environment must be shut down immediately, as you can only use a legacy license on one active Qlik Sense environment. Reach out to your account manager for more details.
Best practices
Finally, don’t forget to apply best practices in your new environment:
- Qlik Sense Folder And Files To Exclude From AntiVirus Scanning
- Recommended practice on configuration for Qlik Sense
-
AI makes the news, but DATA LITERACY makes it true
AI can generate answers fast, but are they accurate? Learn how data literacy helps students and educators validate AI and make smarter decisions.
