Tabular reporting in managed spaces

Tabular reporting tasks can now be developed and configured against Qlik Cloud applications published in managed spaces. The Qlik add-in for Microsoft Excel now allows for connection to apps located in managed spaces for report template authoring, if required. Published apps will carry forward any distribution list definitions in the load script and will use managed space data source configurations for distribution list update. All other task elements of the reporting task can be created in the managed space to allow for app/space specific configurations.

Tabular reporting in managed spaces

Tabular reporting in managed spaces

OAuth impersonation tokens

In Qlik Cloud, OAuth impersonation tokens enable web applications to create access tokens on behalf of users within the tenant where the OAuth client is registered.

Guiding principles for OAuth impersonation

Updated admin.apps scope

Administrators assigning the admin.apps scope to OAuth machine-to-machine tokens can use APIs to manage all the metadata in Qlik Cloud applications.

Sheet navigation buttons moved

When hiding the sheet title, the sheet navigation buttons will be available in the selection bar instead of being hidden.

Hiding the toolbar and header in sheets

Changes to queued automation retention time

Triggered & web hook automations will be stored in the queue for a maximum of 14 days. After this period, if the automation still hasn’t run, it will be removed from the queue and its status will be set to failed. Automations that contained a payload can be retried manually by clicking the retry button in the automation’s history view.

Qlik Application Automation limitations

Additional SaaS application connectors

We’re continuing to expand the connectivity of Qlik Talend Data Integration with a new group of connectors that just got released. These connectors will enable you to gather business data from more applications that focus on finance, advertising, and human resources as well as other subjects. By eliminating the need for custom connectors to access these sources, Data Engineer productivity is increased and Data Consumer’s time to insight is decreased.

• ADP

• Enverus OpenInvoice

• Google AdMob

• Google AdSense

• Google Business Profile

• Google Play

• Google Workspace

• Infor Data Lake

• PagerDuty

• SAP Employee Central Payroll

• RingCentral

• TikTok

• UKG Pro Workforce Management (formerly Dimensions)

Supported SaaS applications

Improved create connection interface

We’ve added more capabilities as well as consolidated all connectors into one common interface. This means that regardless of whether it’s a source, target or application, users will have a similar, streamlined interaction. This includes improved searching and filtering capabilities along with displaying all recently selected connectors.

DDL propagation support

In this release we have added support for DDL propagation (also referred to as schema evolution) in data Replication tasks.

When setting up Replication projects it is now possible to configure data replication tasks to automatically synch DDL operations that occur on the source system with the target. Apply DDL changes to target table can be enabled for events such as;

• adding new or altering existing columns

• adding new tables based on a wildcard pattern for table selection.

Data replication settings

Change Table Creation Improvements

In addition, we have also added two new options for using strings to customize table names and column names when storing changes in Change Tables.

• Suffix – You can specify a string to use as a suffix for all Change Table names e.g. add the default value “_ct” to the target table called “HR” (HR_ct)

• Header column prefix – You can also specify a string to use as prefix in all of the new tables columns. E.g. add the default value “header_” to the column “timestamp” (header_timestamp)