Data Integration & Quality
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Explore Qlik Gallery
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
About Qlik Community
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Qlik Resources
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik Academic Program
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Recent Blog Posts
-
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 se... 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 ... 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
As the EMEA Lead of Qlik Academic Program, I’m proud to see the impact this program is making across institutions. Educators gain access to Qlik Sense... Show MoreAs the EMEA Lead of Qlik Academic Program, I’m proud to see the impact this program is making across institutions. Educators gain access to Qlik Sense software, interactive learning platforms, ready-to-use course materials, and self-paced online training. The curriculum is suitable for a wide range of disciplines—from business and economics to healthcare, sports management, sustainability, and beyond.
Students enrolled in the program not only receive hands-on experience with one of the industry’s leading analytics platforms, but also earn valuable credentials. Upon completion of the training, they can take part in our Qlik Sense Business Analyst and Qlik Sense Data Architect qualification exams—both highly regarded in the job market. Additionally, students can showcase their expertise through digital badges, which can be added to LinkedIn profiles or CVs to enhance employability.
One of the unique aspects of Qlik is its real-world application across diverse sectors. In healthcare, it supports hospitals in identifying treatment gaps. In retail, it helps companies optimize supply chains. Even in sports, teams use Qlik to evaluate player performance and strategize for success. By integrating these industry use cases into the classroom, students gain not just technical skills, but context and confidence.
The Qlik Academic Program is completely free for accredited universities and academic staff. If you’re a university educator looking to enhance your curriculum or a university student eager to build in-demand skills, I encourage you to visit our website, sign up and start your journey!
Let’s work together to build a more data-literate world—starting in the classroom.
For more info, visit our website: https://qlik.com/academicprogram
-
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 ... 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. Conten... Show MoreHello Qlik Users,
On January 13th 2025, Qlik will introduce breaking changes to the execution token functionality for triggered automations.
Contents
-
Introducing Shared Automations to Qlik Cloud Analytics
We’re excited to introduce the ability to manage automations in shared spaces, making collaboration and execution easier and more efficient. Key Bene... Show MoreWe’re excited to introduce the ability to manage automations in shared spaces, making collaboration and execution easier and more efficient.
Key Benefits
- Collaboration: Assign multiple team members to manage and execute automations.
- Control: Space roles limit access and keep automations secure.
- Continuity: Avoid disruptions and ensure automations run smoothly, even when key users are unavailable.
How It Works
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. Learn more here
Rollout Plan
This capability is being rolled out across regions over time:
- May 5: India, Japan, Middle East, Sweden
- June 4: Asia Pacific, Germany, United Kingdom, Singapore
- June 9: United States
- June 12: Europe
- TBD: Qlik Cloud Government
In Case You Missed It
Over the past year, we’ve introduced many powerful automation enhancements to help your team work smarter and faster. Shared automations is just the latest of many exciting automation updates! Here’s a quick recap:
- Qlik Answers connector: find out more
- Key-pair authentication support for Snowflake: find out more
- Custom parameter support in the button: find out more
Packaging Shift to Third-Party Runs for Automations
A change to automation packaging is rolling out: standard runs will be free, while the pricing model shifts to 3rd party runs only. Learn more here.
-
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 exp... Show MoreWe’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.
Key Features & Benefits:
- Outcome-Based Learning Paths: Follow clear, structured steps designed to help you to get to your goals—fast.
- Track Your Progress: See where you stand and what’s next on your learning journey. Stay motivated by watching your progress grow!
- Variety of Engaging Content: Videos, interactive demos, detailed guides, and full courses—choose the format that works best for you.
- Onboarding to Mastery, Personalized for You: From first steps to expert skills, find step-by-step paths that adapt to your needs at each stage of your learning journey.
- Ongoing, Up-to-Date Learning: As the Qlik evolves, so does your learning journey with new, content updated and ready for you to learn.
Now, learning is no longer a chore! Our new Learn page makes learning effortless and effective. Whether you’re onboarding, exploring new features, or mastering advanced tools, you’ll get exactly what you need, right when you need it. Progress tracking, personalized paths, and diverse learning content ensure you’re always moving forward and mastering Qlik like never before.
Start learning today and unlock the full power of Qlik!
Sneak Peak: New Data Integration Learn page is coming soon!
Your learning doesn’t stop here! Soon, Qlik Talend Cloud will be launching a new Learn page too! Packed with data integration resources including interactive guides, demo data, and videos. Whether you’re getting started or diving into advanced features, we are making it easier than ever to level up fast. Stay tuned—your learning journey is just getting started!
-
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 ... 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!
This month we would like to introduce you to Diogo Oliveira. Diogo is based out of Lisbon, Portugal and loves helping students unlock the powerful ins... Show MoreThis month we would like to introduce you to Diogo Oliveira. Diogo is based out of Lisbon, Portugal and loves helping students unlock the powerful insights in Qlik products and understand how much more they can do with the tools.
1. How long have you been with Qlik?
Since June 2016, so a little over 9 years now.
2. How did you become an instructor?
I’ve always enjoyed technology, but even more than that, I’ve always loved helping people understand how things work. Early in my career, I worked in various technical roles, from consulting to solution development and implementation, and that’s when I realized that my favorite part of every project was explaining complex ideas in a way that made sense to others. At Qlik, that passion found the perfect home, and I transitioned from consultancy role to technical training. Becoming an instructor felt like a very natural step, it combined my love of technology with my drive to help people grow their skills and confidence.
3. What do you love about teaching Qlik courses?
I love seeing that moment when someone realizes how much more they can do with Qlik than they ever thought possible. It never gets old to see those “aha!” moments happen, and to help people understand the tool better. Plus, the variety keeps it fun, every class is different, and I always learn something new too.
4. How has the new platform helped you in leading your courses?
The new platform has made everything smoother, for both the students and me. It’s easier to manage content, share resources, and keep everyone engaged. I love that it gives learners more flexibility to practice and explore on their own, too.
5. What are your favorite features on the new platform?
I really like how intuitive and clean the interface is; it just makes everything easier to find and use. Plus, with virtual machines embedded right into the content, students don’t have to juggle multiple tools. It’s a true one-stop shop for learning, making hands-on practice way more seamless and convenient.
6. What is your favorite course to teach?
I really enjoy teaching the Data Modeling Training. It’s where students build a strong foundation by mastering how data fits together, which is key to unlocking powerful insights in Qlik. This course allows students to truly understand the Qlik engine and how data associations impact the way you do your data modeling. I love seeing students connect the dots and gain confidence in shaping their data for analysis. With that said, there are some new trainings about to be released that look quite interesting and could potentially dethrone the “King”.
Check out one of Diogo’s informative Live Instructor Webinars; available for both the AMER and EMEA regions, and register. We know you'll be back for more!
Happy Learning!
-
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 update... 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 -
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 ... Show MoreExcel-Like Spreadsheets for QlikAnyChartSee 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!
Qlik is leveraging the power of AI to provide a new testing experience. This means more flexibility for you! You choose where and when you want to tak... Show MoreQlik is leveraging the power of AI to provide a new testing experience. This means more flexibility for you! You choose where and when you want to take your certification exam. Starting in May, you can take all product certifications whenever it is convenient for you directly on Qlik Learning.
What can I expect with the new Qlik certification experience?
- Purchase all exams using easy credit card checkout
- Certification exams will be delivered directly on the Qlik Learning
- All exams will be open-book, reflecting the real-world conditions in which you engage with our products.
- Once you have completed registration, there is no need to schedule exams in advance; take the exam whenever it is convenient
How to get ready:
- Exam registrations on Pearson VUE and Webassessor will be turned off on April 15.
- Take the exams on Pearson VUE or Webassessor before the end of April or on Qlik Learning starting in May.
The Exam Experience
You’ll be able to select your certification exam directly from Qlik Learning. Once you complete your exam will appear on your Qlik Learning homepage — ready when you are.
All exams are proctored and recorded using software-based proctoring. If you have any issues during your exam, a human proctor will pop in. Before launching the exam, you will need to complete a few checks, like identification verification and a workspace scan. You’ll also get a countdown timer to show your remaining time.
Open Book, Clear Boundaries
All Qlik Certification Exams are open book. This means you are permitted to use authorized test aids during your exam.
The authorized exam materials are limited to: Qlik Learning courses and use cases, Qlik Talend products, documentation, knowledge-based articles, your own study notes, and web searches. The use of AI or AI-assisted tools and web browsers is strictly prohibited.
You’ll get your exam results right away. If you have passed your exam, your certification badge will be issued to you directly!
Get Ready with Confidence
The best way to prepare for an exam is to complete the relevant training courses and practice the outlined skills. You will find everything you need on Qlik Learning, including detailed exam overviews for Qlik Talend Data Integration Certification and Qlik Data Analytics Certification. These overviews include learning plans, use cases, topics covered, and practice tests to help you assess your knowledge.
Qlik certification exams are designed to meet industry standards by combining hands-on experience with product training. They also assess the foundational methodologies required to deliver high-quality, successful projects.
Questions? Reach out to us education@qlik.com Happy Learning!
-
Happy Summer! Get Your Qlik Instructor-led Passport
What if you could learn throughout the whole year, with total flexibility and no worries about budget? Introducing the Qlik Public Instructor-led Pass... Show MoreWhat if you could learn throughout the whole year, with total flexibility and no worries about budget?
Introducing the Qlik Public Instructor-led Passport – a yearly subscription that gives you unlimited access to all public live courses led by expert instructors.
For 12 months, you can join any course, even repeat sessions whenever you want. Plus, each month we launch new and exclusive learning experiences, designed to help you grow step by step.
Some of these experiences will be unique and temporary, created for specific moments or emerging needs.
Once they’re over, they might not come back — and only Passport holders will have access!We know that mastering a tool or skill doesn’t happen in just one session. That’s why the Passport offers something different:
✅ Structured learning to build a solid mental map
✅ Live sessions with experts to answer your questions
✅ Time to practice, repeat, and go deeper
✅ Access to exclusive content — before it’s gonePerfect for small teams with multi-role leaders, who need complete, ongoing training without going over budget.
👉 Get your Passport today and make the most of every opportunity — before it’s gone!
Tip: Log in to see prices in your local currency.
-
Welcome Our Newest Qlik Community MVPs: Sean Bruton & Fabian Quezada!
We’re thrilled to welcome two outstanding contributors into the Qlik Community MVP Program, @seanbruton and @QFabian! The MVP title isn’t just a badge... Show MoreWe’re thrilled to welcome two outstanding contributors into the Qlik Community MVP Program, @seanbruton and @QFabian!
The MVP title isn’t just a badge, it’s a recognition of consistent passion, deep knowledge, and a commitment to lifting others up across the Qlik Community. Sean and Fabian embody all of that and more. Whether it’s answering questions, sparking meaningful conversations, or sharing hard-earned insights, they’ve shown an incredible dedication that hasn’t gone unnoticed.
Both Sean and Fabian were previously honored as Featured Members, and their journey has only continued upward since then. Their impact on the Community is undeniable, and we’re excited to officially recognize them as Qlik Community MVPs.
Please join us in celebrating Sean and Fabian as they join a global network of Qlik power users and changemakers. We can’t wait to see how they continue to inspire and innovate, welcome to the MVP family!
Your Qlik Community Managers,
Melissa, Sue, Jamie, Nicole, Tammy, Caleb and Brett
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @Brett_Cunningham
-
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 fea... 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...
Qlik Replicate May 2025 General Availability Release New and Enhanced Endpoints Snowflake We continue to strengthen our strategic, technical, and c... Show MoreQlik Replicate May 2025 General Availability Release
New and Enhanced Endpoints
Snowflake
We continue to strengthen our strategic, technical, and commercial partnership with Snowflake, earning the award of Snowflake’s 2025 Data Integration Partner of the Year.
- New Snowflake Source Endpoint: This latest endpoint is a significant addition as it offers the ability to read data directly from Snowflake. For Snowflake users, this means you can leverage Snowflake's powerful processing capabilities to transform and prepare data, and then use Qlik Replicate to replicate that processed data to any other Snowflake instance, as well as any supported target system. Opening new possibilities for data distribution and synchronization across your enterprise, ensuring your valuable Snowflake-processed data can fuel other applications or data stores.
- New Unified Snowflake Target Endpoint: We continue to improve our integration with the Snowflake ecosystem and the user experience by consolidating the cloud providers (AWS, Google, or Azure) into a unified single Snowflake target endpoint. This simplification streamlines configuration and management. Additional configuration enhancements for proxy servers, internal Snowflake staging and the Storage Integration Name property provide greater flexibility, security, and optimized data loading for Snowflake users, regardless of their cloud deployment.
⚠️ Note: You can still use the existing standalone endpoints for cloud-specific Snowflake targets without disruption. We recommend using the unified Snowflake Target endpoint for new tasks. In future releases, we will be providing an automated process to migrate your existing tasks, with cloud-specific endpoints, into the unified Snowflake Target endpoint. ⚠️
Databricks
- Databricks Delta Enhancements:
- Primary Key Support: Qlik Replicate now creates primary keys on target Databricks Delta tables using the ‘RELY’ keyword. While Databricks doesn't enforce these, they are vital hints for query optimizers, leading to more efficient data processing and faster analytics within your Databricks environment. This is particularly important for Databricks users leveraging Unity Catalog for data governance.
- Iceberg Reads (UniForm) Support: A new option enables tables to be created in a format readable by Iceberg consumers. This is a game-changer for organizations embracing open lakehouse architectures, allowing for greater interoperability between Databricks Delta and other Iceberg-compatible tools, including Snowflake's growing support for Iceberg. It ensures your data is accessible and usable across diverse platforms.
- Support for Liquid Clustering using Primary Key Columns: This feature introduces liquid clustering, a powerful optimization that replaces traditional table partitioning in Databricks. By leveraging primary key columns, it significantly improves query performance and data organization within Databricks Delta tables, leading to faster insights and more efficient data operations.
- Data Type Enhancement. More precise data type handling when replicating to Databricks, ensuring data integrity and compatibility.
SAP Endpoint Enhancements
Qlik has deep domain knowledge and expertise with the SAP ecosystem and remains committed in helping our customers empower their SAP data by offering flexibility and a wide breadth of endpoints and solutions to cater for different scenarios in your SAP environments.
- Support for Accessing SAP HANA via SAP Application Server: This new option allows users to access SAP HANA through the SAP Application Server, which is highly beneficial for customers with an SAP Runtime License. It enables log-based CDC from SAP HANA without requiring direct database access, simplifying security and compliance.
- Support for "Full Record" Mode in Trigger-based CDC: This new preview feature offers a "Full record" mode that retrieves and stores the entire data record in a "shadow" table for each captured table. This provides a complete history of changes, including before-images of UPDATE and DELETE operations. It offers improved latency calculation, reduces load on SAP HANA, supports soft deletes, and has fewer limitations than the "Primary Key only" mode, providing richer historical data for analytics and auditing.
- Improved auditing and data governance: The AR_H_USER header can now be used in transformation expressions. This is invaluable for auditing and data governance, as it allows you to identify the specific user who performed operations in the source SAP HANA database, providing crucial lineage and accountability.
- SAP OData Enhancement: The addition of the Client identifier setting enhances integration with SAP OData sources, providing more granular control and better traceability for data extraction from SAP applications.
IBM Mainframe
- New IBM IMS Endpoint (Preview): We are making a significant development for organizations with mainframe IMS data, by simplifying configuration and improving stability for extracting valuable data from these critical legacy systems. The first phase of enhancements eliminates the need for the ARC change-router. Don't hesitate to get in touch with your Qlik rep if you are interested in gaining access to this endpoint while it is in preview.
- IBM DB2 for iSeries Source Endpoint: Expanded support for BINARY-DECIMAL and ZONED-DECIMAL data types ensures more accurate and complete data capture from critical IBM iSeries (AS/400) systems, reducing the need for manual transformations and improving data fidelity.
Amazon
- Amazon S3 On-premises Support: This new capability allows organizations to replicate data to S3-compatible storage systems deployed on-premises, such as DELL ECS, MinIO, and Apache Ozone. This is vital for hybrid cloud strategies, data sovereignty requirements, and maintaining data within your own infrastructure while still leveraging the benefits of S3's object storage.
Kafka
- Kafka-based Target Endpoint Enhancements:
- Tombstone Support: A new option to send tombstone messages on DELETE operations is critical for maintaining data consistency in streaming architectures. It signals to Kafka consumers that a record has been logically deleted, enabling proper data synchronization in downstream systems. 7
- Proxy Support: Customers can now connect to Confluent Schema Registry via a proxy server, providing greater network flexibility and security for Kafka-based data pipelines.
MongoDB
- MongoDB Source Endpoint: Enhanced Authentication: This enhancement provides greater security for MongoDB sources by adding the option for using Client Certificate (X.509). Mutual authentication was also added in Replicate November 2024 Service Release 1 for all authentication methods, such as SCRAM-SHA-256, ensuring secure communication channels.
Newly Supported Endpoint and Driver Versions:
Qlik Replicate continuously updates its compatibility. This release adds support for the latest versions of MariaDB, MySQL, PostgreSQL, IBM DB2 for LUW, IBM DB2 for z/OS, and Teradata Database ODBC Driver. This ensures that customers can leverage the newest features and security updates of their source and target databases while maintaining seamless data replication.
Qlik Replicate Server Enhancements
- Notification Suppression: This new feature allows administrators to suppress task notifications based on specific conditions (e.g., last notification time, error message content, task recovery status) and event duration (e.g., only notify if high memory utilization lasts longer than 5 minutes). This significantly reduces ‘alert fatigue’, allowing teams to focus on truly critical issues and improve operational efficiency.
- Log Rollover and Cleanup Defaults for New Installations: For new Qlik Replicate installations, automatic log file management is now enabled by default. Logs will roll over if larger than 100 MB or older than 7 days, and files older than 45 days will be automatically deleted. This simplifies maintenance, prevents disk space issues, and ensures efficient log management from day one.
Qlik Enterprise Manager May 2025 Enhancements
- Clone Task API – we have introduced a new API to clone tasks, allowing you to programmatically clone existing tasks and optionally specify new names for various settings. This and all our APIs in Qlik Enterprise Manager are supported by REST, .NET, and Python
As always, each new release is fully supported for two years. To check the status of support for your currently installed version, please see the relevant product lifecycle pages.
- Qlik Replicate Product Lifecycle
- Qlik Compose Product Lifecycle
- Qlik Enterprise Manager Product Lifecycle
We hope you enjoy using Qlik Talend Data Integration products and would love to hear your feedback and success stories, especially in any improvements you achieve.
To get the latest versions, please visit the Downloads and Release Notes section on Qlik Community.
To learn more about what is included in these releases, be sure to check out the Release notes, which are available here
To obtain any of these releases, go to the Qlik Downloads Site in the Community and filter “Product Category” by “Qlik Data Integration”, and then select the product and the versions you would like to download.
Note: For most products, selecting “Latest release and patch” under the “Show Releases” should be enough.
If required, you can filter further by selecting the latest “Release” and/or Service Release (SR) version under “Release Number”.
-
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... 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
Artificial intelligence is making headlines everywhere. It can write essays, summarize articles, and generate images in seconds. For students, educato... Show MoreArtificial intelligence is making headlines everywhere. It can write essays, summarize articles, and generate images in seconds. For students, educators, and researchers, this opens up exciting possibilities.
However, with these new tools comes a new challenge: how do we know if what AI gives us is actually true?
AI doesn’t understand facts, it just predicts what sounds right based on patterns. This means it can sometimes produce false or misleading information. Experts call this “AI hallucination.”
It’s not just about mistakes; bias is also a major issue. AI bias happens when the data used to train a model includes unfair patterns, like stereotypes or unbalanced information. AI can accidentally repeat and even strengthen these biases because it learns from what’s already out there. That’s why it’s so important to stop and ask: Where did this data come from? Who’s included and who’s missing?
Data literacy and critical thinking matter more than ever, because recognizing these issues takes more than just trusting the tech.
In fact, a recent article from MIT reminds us that while AI can support decisions, it shouldn’t replace human judgment. We still need people to ask questions, check sources, and notice when something seems off. AI can speed up the process, but it’s people who make sense of the output. (When AI Gets It Wrong: Addressing AI Hallucinations and Bias - MIT Sloan Teaching & Learning Technologies
The good news? You don’t have to figure it all out alone. The Qlik Academic Program is here to help you to build the skills that matter most today.
Through the program, you’ll get:
- Free access to Qlik’s powerful data analytics tools
- A full Data Literacy Course to help you think critically with data
- Certifications that make students stand out in the job market
- Practical resources for professors to bring real-world data skills into the classroom
Everything in the Qlik Academic Program is built to help you explore data, ask better questions, and grow your skills, whether you're teaching or learning.
So, whether you're a student getting ready for your future, a professor bringing data into your classroom, or a university driving innovation, this program is here for you.
Because while AI is powerful, real progress happens when people know how to think with data.
Learn more and join for free: Qlik Academic Program: Creating a Data-Literate World
-
Viz for Deck: テーブルおかわりっ!
第5回データソン開催と合わせてはじめたこの Viz for Deck、ひとまず今回で最終回です。最後は前回長文にもかかわらず書ききれなかったテーブルのおかわり編で締めたいと思います。 こんなかわいいテーブルを作ってみました!じゃ~んっ! なんと、これストレートテーブルですよ! メディアライブラ... Show More第5回データソン開催と合わせてはじめたこの Viz for Deck、ひとまず今回で最終回です。最後は前回長文にもかかわらず書ききれなかったテーブルのおかわり編で締めたいと思います。
こんなかわいいテーブルを作ってみました!じゃ~んっ!
なんと、これストレートテーブルですよ!
メディアライブラリに格納した画像と、SVGを使って表現しています。こんなシンプルなデータで作ってみました。
テーブルの軸は[星座]、ソート順は[ID]です。
2つ目の項目は[ID]、ラベルは「=' '」としています。そして表記を「画像」、画像の設定を「URLを追加」とし、画像URLに、メディアライブラリのアドレスを指定しています。サイズは高さに合わせています。
メディアライブラリの各画像のアドレスの求め方ですが、Chrome 使用の場合をご紹介します。画像を追加できるところ(シート背景やサムネイルなど)からメディアライブラリを開いてください。そして該当の画像を選択した状態でファンクションキーの12を押して、ブラウザのDevToolsを開きます。そして、「Select an element」の矢印をクリックして画像のプレビューをクリックすると、Elementタブでアドレスを見ることができます。
アドレス部分で右クリックし、「Copy」>「Copy element」をクリックするとクリップボードにコピーされます。この「/api/v1」以降を画像URLの欄に貼り付けます。このままでは固定ですので、最後のファイル名を可変にします。今回はファイル名の最後をIDと一致させているので、下記のように指定して、軸のIDに伴って対応する画像が表示されるように設定します。
メディアライブラリの画像はAPIを使って求めることも可能です。QlikTips: URL による画像の設定 をご参照ください。
続いて棒グラフの列です。ここはメジャーとして下記のSVG(スケーラブルベクターグラフィックス)を使った数式を設定しています。
高さ20、幅103 の領域に、長方形 (rect) を描きます。幅は[ラッキー度]とし、高さは20です。塗りつぶしは[色]の色を使用します。
ラベルは表示されないように「=' '」としています。表記は「画像」、画像の設定は「ラベルを追加」、「サイズは縮小/拡大して合わせる」にしています。(いったん、「高さに合わせる」にして中央表示にしないと画像が表示されない場合があります。)
水瓶座の人ごめんなさい。ダミーデータです。
お楽しみいただけましたでしょうか?それではまたいつかどこかで!
Happy Dueling !
** 過去の記事 **
-
Qlik Automate: Breaking change in the response of the GitLab blocks
Hello Qlik Automate users and admins, A series of changes have been identified across various GitLab APIs due to the deprecation of specific fields.... Show MoreHello Qlik Automate users and admins,
A series of changes have been identified across various GitLab APIs due to the deprecation of specific fields. For more information, see REST API deprecations (docs.gitlab.com).
As of the release of this post, GitLab has no official release date for API v5, and development has not yet started as of version 18.0.
What will be changed?
merged_by: In the Merge Request API, the merged_by field has been deprecated and replaced with merge_user. The following block response will be affected:
- List merge request
- Get merge request
- List updated merge request incrementally
- List new merge request incrementally
merge_status: The merge_status field in the Merge Request API is deprecated and replaced with detailed_merge_status. The following block response will be affected:
- List merge request
- Get merge request
- Create merge request
- List updated merge request incrementally
- List new merge request incrementally
default_branch_protection: The default_branch_protection field will be replaced with the default_branch_protection_defaults field. For more information, see default_branch_protection API field (docs.gitlab.com). The following block response will be affected:
- List groups
Additional details on Response Changes
Below you will find examples of responses with the deprecated (red) and new (green) fields.
merged_by & merge_status fields
[
{
"id": 1,
"iid": 1,
"project_id": 3,
"title": "test1",
"description": "fixed login page css paddings",
"state": "merged",
"imported": false,
"imported_from": "none",
"merged_by": {
"id": --,
"name": "--",
"username": "--",
"state": "active",
"avatar_url": "https://gitlab.example.com/--",
"web_url": "https://gitlab.com/--"
},
"merge_user": {
"id": --,
"name": "--",
"username": "--",
"state": "active",
"avatar_url": "https://gitlab.example.com/--",
"web_url": "https://gitlab.com/--"
},
"merged_at": "2018-09-07T11:16:17.520Z",
"merge_after": "2018-09-07T11:16:00.000Z",
"merge_when_pipeline_succeeds": true,
"merge_status": "can_be_merged",
"detailed_merge_status": "not_open"
}
]default_branch_protection
{
"id": 96,
"web_url": "https://gitlab.example.com/--",
"name": "test-1",
"path": "test-1",
"description": "",
"math_rendering_limits_enabled": true,
"lock_math_rendering_limits_enabled": false,
"default_branch": null,
"default_branch_protection": 2,
"default_branch_protection_defaults": {
"allowed_to_push": [
{
"access_level": 40
}
],
"allow_force_push": false,
"allowed_to_merge": [
{
"access_level": 40
}
],
"developer_can_initial_push": false
},
"avatar_url": null
}What action do I need to take?
All the above blocks referencing these deprecated fields in the other block should be updated with the new fields.
If you have any questions, we're happy to assist. Reply to this blog post or take similar queries to the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support