New Qlik Data Gateway – Data Movement version

Data Movement gateway 2022.11.42 introduces significant changes including a new driver installation utility and support for new data source versions.

Driver installation utility

This version introduces a driver installation utility that eliminates the need to manually install and configure drivers. The new utility shortens the installation process while significantly reducing the possibility of user error. When the utility is run, the required driver is downloaded automatically, if possible, and installed. If the driver cannot be downloaded (DB2 drivers require login, for example), all you need to do is download the driver, copy it to a dedicated folder on the Data Movement gateway machine, and run the utility.

For an example of using the driver installation utility to install a PostgreSQL driver, see Prerequisites

Snowflake cloud data platform

The Snowflake connector now supports 4-byte emoji characters.

Support for Azure Database for PostgreSQL – Flexible Server as a data source

The PostgreSQL connector can now move data from Azure Database for PostgreSQL – Flexible Server.

Support for Cloud SQL for PostgreSQL for as a data source

The PostgreSQL connector can now move data from Cloud SQL for PostgreSQL.

Newly supported data source versions

This version introduces support for the following new data source versions:

• PostgreSQL 14
• DB2 (for IBM DB2 for z/OS) 12.1
• IBM DB2 for z/OS 2.5

Newly supported cloud data platform versions

Databricks 11.3 LTS

Discontinued support for the following data source versions

The following data source versions are no longer supported:

• DB2 (for IBM DB2 for z/OS) 11
• PostgreSQL 9.6
• Microsoft SQL Server 2012
• MariaDB 10.2

Resolved issues

This version resolves the following issues:

• Oracle data source: When stopping and resuming a task, the task would sometimes fail with a “Failed to set stream position on context” error.
• SAP Application source: Changes would not be captured during the landing task.

Upgrading Qlik Data Gateway – Data Movement

To benefit from the new features and newly supported database versions, upgrade to Data Movement gateway 2022.11.42.

To verify your current version, go to Administration > Data gateways and check the Version column corresponding to your Data Movement gateway.

Upgrading the Data Movement gateway installation

Qlik Data Gateway – Data Movement overview

Collaborate on load scripts in shared spaces

App developers can now co-develop app load scripts with other members of a shared space. By default, only the app owner can use Data manager and Data load editor to add data to an app, build the data model, and load data into their app. The new Can edit data in apps user role allows other users in the shared space to use Data load editor and Data manager in apps they do not own.

When one user is editing the load script in Data load editor, the script is locked for other users. Changes made by all users are automatically saved as different versions in History.

Co-developing data models in shared spaces

Managing data load script history