New blocks for Talend Cloud connector in Qlik Application Automation

The following new blocks are now available for Talend Cloud connector in Qlik Application Automation:

• Execute plan

• Get plan configuration

• Get plan tasks

• List available plans

• List available plans for lookup

• List datasets by tags for lookup

• List tables and views by connection

• List task execution logs

• List task executions

• Pause plan execution

• Resume plan execution

• Stop schedule for a plan

For more information about the Talend Cloud connector, see Getting started with the Talend Cloud connector in Qlik Application Automation.

Support for private connections in Qlik Cloud Data Integration

It is becoming increasing popular for organizations to isolate their data platforms from the Internet with a private connection. As these data platforms are not exposed to the Internet, they cannot be directly accessed from Qlik Cloud. There are several types of private connection, examples of which include:

• Snowflake AWS PrivateLink where public connectivity (via port 443) has been disabled
• Microsoft SQL Server (or any other RDBMS) running in a VPC that has a private IP address only

With the introduction of private connection support, organizations can safely and seamlessly execute Qlik Cloud Data Integration ELT operations (including transformations and data marts) on data platforms inside protected deployments such as a VPC.

Microsoft SQL Server target

Snowflake target

Common Data Movement gateway use cases

Support for SQL Server target in Qlik Cloud Data Integration

Customers can now land data from any supported source to either an on-premises or cloud-based (Amazon RDS, Google Cloud, Microsoft Azure) deployment of SQL Server. The landed data can then be leveraged to perform ELT operations further down the data pipeline, such as transformations and data mart creation. The new SQL Server target can be accessed either directly from Qlik Cloud or via Data Movement gateway if it is not exposed to the Internet (for example, if it is in a VPC).

Microsoft SQL Server target

New business glossary features

Qlik has added some key capabilities to the business glossary within Qlik Cloud:

• Associate term with master measures and dimensions: Users can already define which apps and datasets are related to a particular term in the business glossary. Qlik has now expanded this relationship capability to master Items.  When creating a new master measure or dimension, the user can now also define which terms relate to the master item.

• Pop-up term definition: If a chart uses a master item that has a defined associated business term, the user can see the term’s definition by simply hovering their mouse over the master item label.

• Glossary links within lineage summary view: The lineage summary is an optional view, available with most chart types, that gives users an explanation of where the data came from within that chart. A link to any glossary terms referenced by masters items used within the chart has been added to this view.

Linking terms to master items