Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As part of our continued commitment to ensure access to data is as seamless as possible, we have made a bunch of improvements to the Data Movement Gateway to offer greater flexibility in deployment and supporting new sources and targets, database versions, and driver versions.
It is now possible to install the Data Movement gateway on Red Hat 9.x* or on any corresponding and compatible Linux distribution. In addition to assisting in managing deployments a new notification feature has been introduced that will notify admins when a new gateway version is available.
We have really strong strategic technical and commercial partnerships with the technology vendors and we are continually improving our support of data movement options for databases and cloud data platforms.
*Note: If you have an SAP HANA source that you want to use with a Data Movement gateway on Red Hat Linux 9.x, you must ensure you are using SAP HANA ODBC 64-bit Driver version 2.0.19 or later.
For information about how to upgrade to the latest version, see Upgrading the Data Movement gateway installation.
Monitor Views provide more granular visibility into task operations with the ability to create monitoring perspectives via various filtering options. This release introduces two new filters based on “Source Type” and “Data Movement Gateway”:
This filter creates monitor views that only show tasks for specific source technologies. With this new filter you can now focus on tasks with specific sources of interest, e.g. your tasks for SAP Landing or your SQL Server Replications.
This filter creates a monitor view that lists all tasks for a specific gateway to simplify administration and management. It is really handy when an organization operates multiple gateways. For example, use the view to stop all tasks on a specific gateway before upgrading. Then, restart all gateway tasks once the upgrade is complete to ensure everything is operational.
Qlik Cloud Data Integration landing tasks are the first step in transferring data into your cloud data warehouse. This release provides additional configuration options to control the behavior of the landing task and improve performance.
Control tables store additional operational information in the target data platform, such as landing status, suspended tables, and task history (including the number and volume of records processed during landing).
Error handling policies allow you to control what happens when data truncation or other data errors occur. Choices include ignoring errors, suspending table updates, or stopping the task.
The new data preview feature displays the live data for the currently active task without leaving the Qlik Cloud Data Integration interface. The preview helps validate and shape the data while designing pipelines.
The data preview is currently available for physical tables and SQL transformations.
This shows the actual schema and data in the physical tables that logical datasets are mapped to.
This allows previewing the result set of a SQL transformation while writing the query, even before any physical tables have been created. This is more powerful than just previewing source data.
So, in summary, this new data preview feature is a huge benefit for users to validate data and shape transformations, with granular security controls to restrict access to production data. The initial phase focuses specifically on SQL transformations, providing strong value and thereby allowing data shaping entirely within Qlik Cloud Data Integration. Additional data preview capabilities will be rolled out progressively over 2024.
All these updates are available from March 12th, 2024, check them out now in your Qlik Cloud Data Integration tenant. If you don't yet have access to Qlik Cloud, why not take a guided tour and experience the value it can bring by yourself here?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.