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 Learning
The Qlik Learning blog offers information about the latest updates to our courses and programs, as well as insights from the Qlik Learning team.
Recent Blog Posts
-
Qlik Add-in now Available for Microsoft Word and PowerPoint
The same great Add-in previously only for Excel can now be used in Microsoft Word and Powerpoint. -
Connector Factory: October - December 2025 releases
For October, November & December 2025, Connector Factory has released more connectors and enhancements for data integration, data analytics and application automation. -
Revenue_Reports
Revenue_ReportsClay_Tech_SystemThis Qlik app is designed to provide a comprehensive overview of sales performance across multiple dimensions, including region, city, product category, and time. It consolidates key metrics such as total sales, total customers, number of sub-categories, and average unit price, while allowing users to dynamically filter the data by category and region. The visualizations include region-wise sales, quantity and sales... Show MoreRevenue_ReportsClay_Tech_System
This Qlik app is designed to provide a comprehensive overview of sales performance across multiple dimensions, including region, city, product category, and time. It consolidates key metrics such as total sales, total customers, number of sub-categories, and average unit price, while allowing users to dynamically filter the data by category and region. The visualizations include region-wise sales, quantity and sales by sub-category, city-wise total sales, product-wise units sold, quarterly sales trends, and state-wise sales contributions, offering a clear and interactive view of the business performance. It is primarily used by sales managers, marketing teams, and business analysts to monitor trends, identify top-performing products, and assess regional and city-level performance. By providing actionable insights through an interactive and easily navigable interface, the app enables stakeholders to make informed, data-driven decisions that improve sales strategies, optimize inventory, and enhance overall business performance.
Discoveries
The Qlik app reveals clear differences in sales performance across regions, cities, and product categories, with certain regions and states contributing a significantly higher share of total sales. Major cities emerge as key revenue drivers, while other locations show potential for growth. Product-level analysis indicates that a limited number of high-demand items account for a large portion of total units sold, particularly within electronics and fashion categories. Sales trends show steady growth over recent years, with minor fluctuations in the most recent period that may be influenced by seasonality or market conditions. Overall, the app highlights stable pricing, strong regional concentration, and identifiable top-performing products, enabling stakeholders to focus on high-impact areas while addressing underperforming segments to improve overall business performance.
Impact
This report enables stakeholders to quickly understand sales performance across regions, products, and time through an interactive and unified view. It supports data-driven decisions by identifying high-performing areas, trends, and improvement opportunities. As a result, it helps optimize sales strategies, inventory planning, and overall business efficiency.
Audience
This app is used by sales managers, marketing teams, business analysts, and senior leadership to track and evaluate sales performance across regions, cities, and product categories. It is primarily accessed through Qlik Sense dashboards during daily and weekly performance reviews and is a critical tool for monitoring business health, identifying trends, and supporting strategic decision-making.
Data and advanced analytics
The app has improved the business’s ability to analyze sales data by providing interactive, real-time insights across multiple dimensions. It enables faster identification of high-performing areas and underperforming segments, leading to more effective sales strategies and improved operational efficiency.
-
Watch! Q&A with Qlik: AI in Qlik Talend Data Integration
Don't miss our previous Q&A with Qlik! Pull up a chair and chat with our panel of experts to help you get the most out of your Qlik experience. WATCH HERE
-
-
Write Table now available in Qlik Cloud Analytics
Introducing Write Table a simple, interactive way for users to work directly with their data inside their analytics apps -
Qlik Sense November 2025 (Client-Managed) now available!
What’s New & What It Means for YouWe’re excited to announce the November 2025 release of Qlik Sense Enterprise on Windows. This update brings enhancements across app settings, visualizations, dashboards, and connectors making your analytics smoother, more powerful and easier to maintain. Below is a breakdown of the key features, how your teams – analytics creators, business users, data integrators and administrators – can benefit, and some practi... Show MoreWhat’s New & What It Means for You
We’re excited to announce the November 2025 release of Qlik Sense Enterprise on Windows. This update brings enhancements across app settings, visualizations, dashboards, and connectors making your analytics smoother, more powerful and easier to maintain. Below is a breakdown of the key features, how your teams – analytics creators, business users, data integrators and administrators – can benefit, and some practical next-steps to get ready. -
Qlik Replicate and an update on Salesforce “Use Any API Client” Permission Depre...
Dear Qlik Replicate customers, Salesforce announced (October 31st, 2025) that it is postponing the deprecation of the Use Any API Client user permission. See Deprecating "Use Any API Client" User Permission for details. Qlik will keep the OAUT plans on the roadmap to deliver them in time with Salesforce's updated plans. Salesforce has announced the deprecation of the Use Any API Client user permission. For details, see Deprecating "Use Any API ... Show MoreDear Qlik Replicate customers,
Salesforce announced (October 31st, 2025) that it is postponing the deprecation of the Use Any API Client user permission. See Deprecating "Use Any API Client" User Permission for details.
Qlik will keep the OAUT plans on the roadmap to deliver them in time with Salesforce's updated plans.
Salesforce has announced the deprecation of the Use Any API Client user permission. For details, see Deprecating "Use Any API Client" User Permission | help.salesforce.com.
We understand that this is a security-related change, and Qlik is actively addressing it by developing Qlik Replicate support for OAuth Authentication. This work is a top priority for our team at present.
If you are affected by this change and have activated access policies relying on this permission, we recommend reaching out to Salesforce to request an extension. We are aware that some customers have successfully obtained an additional month of access.
By the end of this extension period, we expect to have an alternative solution in place using OAuth.
Customers using the Qlik Replicate tool to read data from the Salesforce source should be aware of this change.Thank you for your understanding and cooperation as we work to ensure a smooth transition.
If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.Thank you for choosing Qlik,
Qlik Support -
Announcing the 2026 class of Qlik Academic Program Educator Ambassadors!
The Qlik Academic Program is proud to announce our 2026 class of Educator Ambassadors. Academic Program Ambassadors are educators who champion the Qlik Academic Program at their universities and beyond, with a passion for preparing students for the data driven workplace. These individuals are some of our most active participants of the Qlik Academic Program who fully utilize the free software, training resources and qualifications that we provide... Show MoreThe Qlik Academic Program is proud to announce our 2026 class of Educator Ambassadors.
Academic Program Ambassadors are educators who champion the Qlik Academic Program at their universities and beyond, with a passion for preparing students for the data driven workplace. These individuals are some of our most active participants of the Qlik Academic Program who fully utilize the free software, training resources and qualifications that we provide to university students and educators. The members of our 2026 class are:
Marcin Stawarz
Blerim Emruli
Dr. Javier Leon
Dr. K. Kalaiselvi
Katherine Taylor Pearson
Angelika Klidas
Dr. Terrence Perera
Chee-wai Ho
Dr Ravi Aavula
Alexander Flaig
Gabriel Navassi
Daniel O'Leary
Angel Monjarás
Marisa Sánchez
Priscila de Jesus Papazissis Paolinelli
Manikant Roy
Meet the Qlik Academic Program Professor Ambassadors for 2026
We are thrilled to be recognizing the efforts of these individuals to help the Qlik Academic Program to achieve its mission - to create a data literate world, one student at a time. Each ambassador has been selected through a self-nominated application process, where they were required to answer various questions covering their motivations for becoming an ambassador, and to evidence their passion for upskilling their students in analytics over the past 12 months. This year, we are excited to select another 16 ambassadors, 3 new ones and 13 returning ambassadors whose efforts continued to impress us. By way of thanks for their efforts our ambassadors will receive exclusive benefits such as webinars and discussion groups with Qlik leaders, opportunities to showcase their experience with the Qlik Academic Program and the chance to grow their network with other educators across various fields and geographies.
Throughout 2026 our ambassadors will continue their advocacy for the Qlik Academic Program and help us to reach even more students and educators with our free resources. Stay tuned over the coming months for more in-depth profiles on each of our ambassadors, and get to know who they are, what they teach and why they are so passionate about bridging the data literacy skills gap!
Learn more about the program and how to apply for future classes.
-
Decommissioning the legacy support portal (support.qlik.com) January 23rd, 2026
The legacy Qlik Support portal (previously known as support.qlik.com) has been decommissioned on the 23rd of January, 2026. How will this affect me? You will be largely unaffected. Access to our existing and up-to-date portal is not impacted by this change, meaning chat, knowledge, and your support cases remain exactly where you expect them to. Did you know? We're launching additional My Account features for customerportal.qlik.com. Read more her... Show MoreThe legacy Qlik Support portal (previously known as support.qlik.com) has been decommissioned on the 23rd of January, 2026.
How will this affect me?
You will be largely unaffected. Access to our existing and up-to-date portal is not impacted by this change, meaning chat, knowledge, and your support cases remain exactly where you expect them to.
Did you know? We're launching additional My Account features for customerportal.qlik.com. Read more here in Your Qlik Customer Portal My Account features.
I used to access my licenses on the old portal. Where do I go now?
If you previously accessed your legacy (perpetual) Qlik licenses and control numbers on support.qlik.com, your next stop is our Support Chat. A live agent will share the license, control number, and LEF with you on request.
Thank you for choosing Qlik,
Qlik Support -
How Qlik Academic Program is shaping careers in Analytics
In today’s job market, data literacy and analytics skills are among the most sought-after capabilities employers look for. To help prepare students for meaningful careers in analytics, business intelligence, and data science, Qlik’s Academic Program is making waves in universities across India and the Asia Pacific — providing students with hands-on experience, real tools, and industry-recognized qualifications that boost employability and spark i... Show MoreIn today’s job market, data literacy and analytics skills are among the most sought-after capabilities employers look for. To help prepare students for meaningful careers in analytics, business intelligence, and data science, Qlik’s Academic Program is making waves in universities across India and the Asia Pacific — providing students with hands-on experience, real tools, and industry-recognized qualifications that boost employability and spark innovation.
-
Qlik Cloud Analytics: Scheduled subscription reports creation issue January 14th...
An update deployed to Qlik Cloud Analytics on January 14th, 2026, impacted the creation and scheduling of end user subscriptions (see Scheduling reports with subscriptions). Any selections made (to reduce the distributed data set) before creating the subscription were not properly saved. As a result, the subscriptions are executed without any filters applied. The upgrade has since then been reverted (January 19th). This does not impact in-app re... Show MoreAn update deployed to Qlik Cloud Analytics on January 14th, 2026, impacted the creation and scheduling of end user subscriptions (see Scheduling reports with subscriptions). Any selections made (to reduce the distributed data set) before creating the subscription were not properly saved. As a result, the subscriptions are executed without any filters applied.
The upgrade has since then been reverted (January 19th).
This does not impact in-app reporting for traditional burst tasks as documented in In-app reporting with Qlik Cloud Analytics.
What action do I need to take?
Users who created subscriptions during this period (January 14th to 19th) should review their subscriptions and the selections that are stored for the subscription. If the desired data selections are not in place, then the user should remove the current subscription and add a new subscription with the desired selections in place.
To verify if a subscription has selections:
- Click the navigation menu (waffle menu)
- Go to Analytics
- Go to Subscriptions
- Select the subscription
-
In the Details tab, locate the Data field and review the subscription’s Selections
For more information on this feature, see Scheduling reports with subscriptions.
What time frame is affected?
Subscriptions created between:
- 14th of January 2026 15:47 UTC
- to 19th of January 2026 12:10 UTC
If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.
Thank you for choosing Qlik,
Qlik Support -
Techspert Talks - Setting up Knowledge Marts for AI
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 January looking at Setting up Knowledge Marts for AI. 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 Part... Show MoreHi 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 January looking at Setting up Knowledge Marts for AI.
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:
- Synchronizing data in real time
- Connecting to Structured and Unstructured data
- Demonstration of chatbot application
- How to get started
-
clay tech_Myfairhotel
clay tech_Myfairhotelclay techThis dashboard provides a month & year–wise comparison of hotel revenue, highlighting key KPIs, room type performance, folio revenue contribution, and business source distribution to quickly track revenue trends and drivers.DiscoveriesSome of the key discoveries from using this app include clear visibility into month-on-month and year-on-year revenue trends, identification of top-performing room types, and understand... Show Moreclay tech_Myfairhotelclay techThis dashboard provides a month & year–wise comparison of hotel revenue, highlighting key KPIs, room type performance, folio revenue contribution, and business source distribution to quickly track revenue trends and drivers.Discoveries
Some of the key discoveries from using this app include clear visibility into month-on-month and year-on-year revenue trends, identification of top-performing room types, and understanding which business sources contribute the most to overall folio revenue.
Impact
This app has helped the business make faster, data-driven decisions by highlighting revenue drivers and gaps, enabling better pricing, channel optimization, and room mix planning to improve overall performance.
Audience
This app is primarily used by hotel management, revenue managers, sales & marketing teams, and finance stakeholders. It is displayed on management review dashboards and is accessed daily/weekly for performance tracking, making it a critical tool for monitoring revenue health and supporting strategic decisions.
Data and advanced analytics
The app leverages consolidated transactional data with time-based comparisons and KPI-driven analytics to uncover trends and patterns. It enables proactive analysis of revenue, room type performance, and business sources, helping the business optimize forecasting, pricing strategies, and overall revenue management.
-
ClayTech_PortfolioSummary
ClayTech_PortfolioSummaryClayTech SystemThis provides an overall comparison of how different stakeholders are performing across the Indian region. It is intended for those who prefer data and numbers over visual or fancy charts. The analysis highlights spend, onboarding, and activation ratios, helping management clearly identify key performance metrics and critical business gaps. DiscoveriesSome of the discoveries from using this app include: How... Show MoreClayTech_PortfolioSummaryClayTech SystemThis provides an overall comparison of how different stakeholders are performing across the Indian region. It is intended for those who prefer data and numbers over visual or fancy charts. The analysis highlights spend, onboarding, and activation ratios, helping management clearly identify key performance metrics and critical business gaps.Discoveries
Some of the discoveries from using this app include: How the overall spend work and how their distribution over other channel Understand the onboarding and activation ration over the state and different dim.
Impact
That helps us to know the customer and product behavior and give them the visual number on which they can bat and set some action.
Audience
Include # of users (if you can share) This is mostly used by our business user who are at the post of AM, M of the product and Marketing.
Data and advanced analytics
here we applied the extension and advanced scripting of qlik in the load script.
-
Streamlining user types in Qlik Cloud capacity-based subscriptions
Hello Qlik Cloud Admins! As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User. Why are we doing this? User capabilities on capacity-based tenants are governed by access control. Thus, a difference in user type designation is no longer required to determine what a user can do in the t... Show MoreHello Qlik Cloud Admins!
As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User.
Why are we doing this?
User capabilities on capacity-based tenants are governed by access control. Thus, a difference in user type designation is no longer required to determine what a user can do in the tenant.
What changes are being made?
- Any user authenticating to a capacity-based tenant will be considered a Full User. The concept of a Basic User is removed from the product. Any users purchased under capacity entitlement will be available as Full Users. Full User consumption is deducted from the total number of user capacity purchased.
- The auto-assignment toggles in the Qlik Cloud Administration Center > Settings > Entitlements will be removed from the product.
To grant these roles to everyone in the tenant, use the Auto assign option in Manage users > Permissions.
How does this impact you?
Current access control configuration for existing users remains unchanged. You may have to modify the User Default role, assign users to built-in roles, or create new custom roles to support access to tenant features and capabilities. See Roles and permissions for users and administrators for information on your tenant’s access control system.
When will this change take effect?
This is targeted for February 2nd, 2026.
If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.
Thank you for choosing Qlik,
Qlik Support -
Qlik’s Response to Apache Tika vulnerability CVE-2025-66516
In December 2025, the Apache Project announced a vulnerability in Apache Tika (CVE-2025-66516) and provided patches to resolve the issue. Qlik has been reviewing our usage of the Apache Tika product suite and has identified a limited impact as follows. Affected Software Apache Tika is used in several Qlik products. However, the vulnerability is only relevant to the case of a Talend Studio route that uses Apache Tika to parse PDFs. No other use... Show MoreIn December 2025, the Apache Project announced a vulnerability in Apache Tika (CVE-2025-66516) and provided patches to resolve the issue. Qlik has been reviewing our usage of the Apache Tika product suite and has identified a limited impact as follows.
Affected Software
Apache Tika is used in several Qlik products. However, the vulnerability is only relevant to the case of a Talend Studio route that uses Apache Tika to parse PDFs.
No other use case or product is impacted by the vulnerability. Qlik Cloud and Talend Cloud are not impacted by this vulnerability.
Nevertheless, we are patching all our products that contain Apache Tika out of an abundance of caution. Be on the lookout for a series of product patches for supported and affected versions.
Recommendation
The releases listed in the table below contain the updated version of Apache Tika, which addresses CVE-2025-66516.
Always update to the latest version. Before you upgrade, check if a more recent release is available.
Product Patch Release Date Talend Studio R2025-11v2 December 16, 2025 Talend Administration Center QTAC-1472 December 19, 2025 Talend ESB Runtime R2025-12-RT December 19, 2025 Talend Remote Engine Gen 2. Connectors 1.58.8 December 23, 2025 Talend Data Stewardship TPS-6013 December 23, 2025 Talend Data Preparation TPS-6016 January 16, 2026 Thank you for choosing Qlik,
Qlik Support -
Developing Word and PowerPoint reports with the expanded Microsoft O365 Add-in f...
Qlik's O365 Add-in offering for report developers has expanded with two new add-ins to enable Word document and PowerPoint presentation analytic reports. Report developers can now: Compose document or portrait style reports with data from a Qlik Sense app with an output format of .docx or .PDF (using the new Microsoft O365 Add-in for Word). Create PowerPoint presentation analytic reports from a Qlik Sense app with an output of .pptx or .PDF (usi... Show MoreQlik's O365 Add-in offering for report developers has expanded with two new add-ins to enable Word document and PowerPoint presentation analytic reports.
Report developers can now:
- Compose document or portrait style reports with data from a Qlik Sense app with an output format of .docx or .PDF (using the new Microsoft O365 Add-in for Word).
- Create PowerPoint presentation analytic reports from a Qlik Sense app with an output of .pptx or .PDF (using the new Microsoft O365 Add-in for PowerPoint).
How do I get started?
Qlik add-ins for Microsoft Office are installed using a manifest file. If you are using an existing manifest, you will need to download and deploy an updated file to access the new add-ins. See the deployment guide Deploying and installing Qlik add-ins for Microsoft Office.
The manifest covers all three productivity tool Add-ins. They cannot be deployed individually.
Notes on the PowerPoint add-in use
Qlik’s integration testing of Microsoft PowerPoint APIs shows that the O365 Add-in for PowerPoint can be unstable or slow at times. Our investigation with Microsoft reveals this to be a known challenge; some APIs on web vs desktop can result in different behaviors.
If your report developers have difficulty with the online PowerPoint Add-in, contact Qlik Support to open a case with us.
While we investigate the integration with Microsoft to determine if a solution is possible, consider developing your reports with the desktop version of PowerPoint.
For Qlik NPrinting Customers
- Watch for an upcoming Qlik NPrinting release in 2026 that will support Word and PowerPoint template export of compatible templates to Qlik Cloud Analytics.
- Please note that due to Microsoft API limitations, it is not possible to embed data into an Excel table within the PowerPoint template to then produce native PowerPoint visualizations in the report. Refer to the help documentation for any other Word and PowerPoint report authoring limitations. See Qlik Reporting Service specifications and limitations for details.
If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.
Thank you for choosing Qlik,
Qlik Support -
Starting 2026 Strong: Empowering Data Analytics Education Across EMEA
As we step into 2026, I want to take a moment to reflect on the year behind us and look ahead to what’s coming for the Qlik Academic Program across EMEA. 2025 was a strong and rewarding year marked by meaningful collaboration with educators, growing student engagement, and a shared commitment to bringing real-world data analytics into the classroom. Our goal for 2026 is simple: to build on that momentum and continue supporting academic institutio... Show MoreAs we step into 2026, I want to take a moment to reflect on the year behind us and look ahead to what’s coming for the Qlik Academic Program across EMEA. 2025 was a strong and rewarding year marked by meaningful collaboration with educators, growing student engagement, and a shared commitment to bringing real-world data analytics into the classroom. Our goal for 2026 is simple: to build on that momentum and continue supporting academic institutions across the region in even more impactful ways.
-
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.
If you have previously unbundled your PostgreSQL install, see How To migrate a Qlik Sense Enterprise on Windows environment to a different host after unbundling PostgreSQL for instructions on how to migrate.
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
