Contact us

Let‘s talk about data analytics for your company

Contact us

Qlik Cloud June 2024: what’s new

DATA ANALYTICS

 

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.

Marketo

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!

  1. The sheet navigation has moved to the left asset panel for easier navigation, alongside Bookmarks and Notes.
  2. Grouping of sheets makes sheets easier to organize and find.
  3. Pinning and resizing of the left asset panel makes the panel more readable and flexible. Sheet view

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.

Styling an app

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:

  • Generate standardized documents for printing.
  • Produce complex, dimensionally driven worksheets of tabular data for downstream analysis.

Users simply need to make selections during analysis, and then download a tabular report to their desktop using the assets panel.

Not supported in Qlik Cloud Government.

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.

Using Data load editor

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.

Requires Direct Access gateway 1.6.6 or later.

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.

Sharing links to sheets

13. New Direct Access gateway version

Direct Access gateway 1.6.6 introduces new functionality as well as enhancements to existing functionality.

Direct Access gateway 1.6.6 introduces the following features and enhancements:

  • 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.

    • Azure Synapse Analytics: Azure OAuth and Azure Active Directory
    • Azure SQL Database: Azure OAuth and Azure Active Directory
    • Snowflake: OAuth
    • Databricks: Azure OAuth
    • MongoDB: SCRAM-SHA-256 and LDAP
  • With this enhancement, when 10,000 tables or more are retrieved, the tables will be retrieved in batches of 10,000 to prevent timeouts.

  • 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.

  • 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.

DATA INTEGRATION

 

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.

Enhancements

  • From this version, the Snowflake metadata schema (for staged files) will be created if it does not exist.

Resolved issues

  • After a change was made to a Rename dataset rule (that concatenated the table name with the schema name) and a View was added to the landing task, the Prepare operation would fail with the following error:

    QRI SQL error not implemented.

  • Updated the java_file_factory component to a version without any known vulnerabilities.
  • Updated org.postgresql:postgresql to a version without any known vulnerabilities.
  • When moving data to SQL Server, the Prepare operation would fail when index names exceeded 128 characters. The issue was resolved by altering the logic to create shorter index names.
  • When moving data from SQL Server, a missing column name in the table definitions would cause an infinite notification loop in the repsrv.log file, with the following message:

    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.

Connecting to data warehouses

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.

Enhancements

  • Added support for concurrently retrieving the metadata for multiple tables.

  • 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.

  • Japan is now supported as a Qlik Cloud tenant region.

Resolved issues

  • The retry interval between the data gateway and Qlik Cloud would continually increase, but never be reset (unless the service was restarted).
  • When moving data from a SaaS application source, tables would sometimes enter an error state during reload.
  • Tasks with a MySQL source would sometimes fail with the following error during CDC:

    Read next binary log event failed; mariadb_rpl_fetch error 0 Error reading binary log.

  • Previously, CDC audit events would only be logged for landing tasks. Now, they will be logged for replication tasks ask well.
  • When moving data from SQL Server (MS-CDC), tasks with numerous tables would sometimes take several hours to start.
  • When the source table contained CLOB columns and the “Limit LOB size” value exceeded 10240, replication to Snowflake would fail with the following error:Invalid character length: 0

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.

Requires Direct Access gateway 2023.11.11 or later.

Better findability, smoother navigation:

Any questions please contact our consultants. Responding in one working day.


What's new in Qlik Cloud

Ask our consultants

Contact us

Get data analytics news into your inbox

Infotrust team once a month shares BI news, products updates, technology trends and invitations to events and trainings. Mark your interests: