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

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.

ServiceNow connector

Direct Access gateway

Enhancements and resolved issues in Qlik Talend 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

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

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.

ServiceNow connector

Direct Access gateway