Data window functions in engine load script

Customers can now perform complex calculations on their data tables in the Qlik load script to perform aggregation on different partitions without losing the granularity of their data.

This functionality is commonly used in SQL and with many ML data preparation use cases.

Window functions

• Window – script function

• WRank – script function

Additional SaaS application connectors for Qlik Cloud Data Integration

Connector Factory launches more Qlik Cloud Data Integration connectors with an emphasis on health information technology and digital advertising applications:

• Cerner Millennium

• Epic on FHIR

• Facebook Ads

• Facebook Pages

• Google Ads

• Instagram Ads

• LinkedIn

• Oracle OPERA

• Salesforce Pardot

• SAP Commerce Cloud

• UKG Pro

• Zendesk

Similar to last month’s release, these new connectors are Generally Available (GA) and covered by our standard support policies but are tagged as Preview because many initially cover a specific use case. Once these capabilities are expanded to cover multiple use cases, the Preview label will be removed.

These connectors are available to all Qlik Talend Data Integration customers upon request, to ensure that Qlik can work with you to maximize the experience using these connectors. To access application connections, contact your Qlik Customer Success Manager or Qlik Support.

Connecting to SaaS applications