1. New Marketo Connector, ODBC-based
The new Qlik Marketo connector provides seamless access to data stored in a Marketo database. This connector has all general configuration options directly in the connection definition user interface, and it supports authentication using either username/password or OAuth.
The previous JDBC-based Qlik Marketo connector will continue to be supported until end of July 2024.
2. Changes to platform navigation
Major changes have been made to navigation across the platform with the introduction of Activity Centers. These provide a common anchor point with the waffle menu in the top-left corner throughout the whole platform, and more generally make it easier to navigate, with areas focused on consuming insights and creating analytics, and get started creating new content. These changes also allow administrators to curate content and insights for consumers, and let all users interact with Insight Advisor Chat and browse content in parallel.
3. Improvements to sheet navigation, interaction and the left asset panel
Three great additions to sheets and the asset panel!
4. Context menu for visualizations
Introducing a new Context menu for visualizations toggle in Qlik Cloud, enhancing app customization and user experience by allowing flexible control over the context menu visibility within app properties.
5. On-Demand tabular reporting
Make your highly formatted tabular reports available to in-app users so they can set their preferred data selections and download the file to their desktop immediately. This is especially useful if your users need to:
Users simply need to make selections during analysis, and then download a tabular report to their desktop using the assets panel.
6. Copy cell value in Pivot
The new pivot is getting a quality of life improvement, find copy cell value in the context menu.
Pivot table (Visualization bundle)
7. Enable and disable autocomplete in script and expression editors
Users can now enable or disable autocomplete hints when writing Qlik script in the script editor, data load editor, and expression editor.
8. New release: connection sharing for automations
Create and manage automation connections in shared spaces and allow other users in your tenant to use these connections in their automations.
More information can be found on Qlik Community: Shared automation connections
9. Images in tables
Images can now be embedded in the new straight table and pivot table in the visualization bundle. The images can be sourced from the media library or from a URL.
Straight table (Visualization bundle)
Pivot table (Visualization bundle)
10. Improved usability of the Data load editor
The script editing experience has been improved in the Data load editor and now offers the same functionality as the Script editor.
The editor now includes a data preview feature, allowing Qlik Cloud users to get better insight when writing script to load data. Visual wizards have been added to easily write Store statements or include QVS files. The editor also adds usability improvements such as resizable panels and the possibility to preview the content of the included QVS files.
11. Support for accessing ServiceNow via Direct Access gateway
Using the ServiceNow (via Direct Access gateway) connector, customers can now securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
12. Links to sheets in Catalog
You can now create a link to a specific sheet as an asset in the Catalog. This allows you to promote specific sheets from apps to public collections and further on a custom home page, helping your analytic consumer to find relevant content faster.
13. New Direct Access gateway version
Direct Access gateway 1.6.6 introduces new functionality as well as enhancements to existing functionality.
New features and enhancements
Direct Access gateway 1.6.6 introduces the following features and enhancements:
Support for accessing ServiceNow via Direct Access gateway
This version introduces support for the ServiceNow (via Direct Access gateway) connector, allowing customers to securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
Support for new authentication methods when using the following Direct Access gateway connectors:
Enhanced metadata paging when working with ODBC connectors
With this enhancement, when 10,000 tables or more are retrieved, the tables will be retrieved in batches of 10,000 to prevent timeouts.
.NET 8.x requirement
From this version, customers will be required to install both .NET 6 and .NET 8.x in order to work with Direct Access gateway. During installation or upgrade, setup will install them automatically if they are not already installed.
Improved supportability
To aid troubleshooting, additional logging has been added that measures the duration of Direct Access gateway requests.
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation.
1. AI-based SQL Assistant
SQL Assistant is now available as part of Qlik Cloud Data Integration. SQL Assistant is a co-pilot feature that makes it easier to write SQL queries.
SQL Assistant, available as part of the SQL transformation capability, allows you to describe what you want to achieve in natural language. Based on this prompt, the AI SQL Assistant will generate a SQL query to use as part of your transformation.
At launch, SQL Assistant is available for the US East, Ireland, Frankfurt and Sydney regions. Not supported in Qlik Cloud Government.
Generating a SQL transformation from a text prompt
2. Changes to platform navigation
Major changes have been made to navigation across the platform with the introduction of Activity Centers. These provide a common anchor point with the waffle menu in the top-left corner throughout the whole platform, and more generally make it easier to navigate, with areas focused on consuming insights and creating analytics, and get started creating new content. These changes also allow administrators to curate content and insights for consumers, and let all users interact with Insight Advisor Chat and browse content in parallel.
3. Enhancements and resolved issues in Qlik Cloud Data Integration
The following improvements require Qlik Data Gateway – Data Movement 2023.11.23 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Snowflake metadata schema
From this version, the Snowflake metadata schema (for staged files) will be created if it does not exist.
QRI SQL error not implemented.
mssql_resolve_sqlserver_table_column_attributes(…) failed to find column
4. New targets for replication projects
When we first introduced the replication use case in Qlik Cloud Data Integration projects, we started with supporting database targets such as Microsoft SQL Server, Oracle, MySQL, and others. As part of our continued commitment to support a wide range of targets with this use case, we are pleased to announce that we have added support for cloud data warehouse targets.
When creating a data replication task it is now possible to select cloud data warehouse targets including Snowflake, Databricks, Microsoft Fabric and Google BigQuery.
5. New project level data view
The new project level data view streamlines troubleshooting for complex data pipelines as it allows users to view dataset metadata and sample data for tasks from the pipeline perspective without having to enter each task. This capability is secured by the Can View Data role to ensure only users with explicitly granted permissions can view data in the data platform.
Creating a data pipeline | Viewing data
6. Enhancements and resolved issues in Qlik Cloud Data Integration
The following improvements require Qlik Data Gateway – Data Movement 2023.11.11 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Parallel metadata retrieval
Added support for concurrently retrieving the metadata for multiple tables.
Improved monitoring performance
The monitoring information for landing and replication tasks will now be updated every 10 seconds (instead of every 60 seconds), providing a more precise indication of their current status.
Newly supported region
Japan is now supported as a Qlik Cloud tenant region.
Read next binary log event failed; mariadb_rpl_fetch error 0 Error reading binary log.
Using the ServiceNow (via Direct Access gateway) connector, customers can now securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
Better findability, smoother navigation:
Any questions please contact our consultants. Responding in one working day.