Creating a basic write-back solution with Qlik™ Cloud

New features and capabilities coming to Qlik™ Cloud

Magic solutions!

Static, read-only dashboards are a thing of the past compared to what’s possible now in Qlik™ Cloud.

‘Write-back’ solutions offer the ability to input data or update dimensions in source systems, such as databases or CRMs, all while staying within a Qlik Sense™ app. The solution incorporates both Qlik™ Cloud and Application Automation to enable users to input data from a dashboard or application and run the appropriate data refresh across the source system as well as the analytics.

Example Use Cases:

  • Ticket/ Incident Creation = Create Ticket or Incident in JIRA or ServiceNow,
  • Data Changes Update Deals/Accounts in a CRM like HubSpot or Salesforce,
  • Data Annotations – Add a comment to or more records in a source system.

This new feature is possible with all of the connectors located in Application Automation, including: CRMs like HubSpot or Salesforce Databases like Snowflake, Databricks, Google Bigquery SharePoint and more! The ability to write back in Qlik™ Cloud is a game changer for customers who want to operationalize their existing Qlik Sense™ applications to enhance decision making right inside an app where the analytics live. This not only streamlines business processes across an ever-growing data landscape, but it also enables users to to act in the moment.
With Application Automation powering the write back executions, customers can unlock more value across their data and analytics environment.

Using Qlik™ Cloud Analytics and Qlik™ Application Automation you can create sophisticated solutions to solve many business problems. With Qlik‘s new properties in the action button object, you can now execute an Application Automation workflow while passing parameter / value pairs to the workflow.

Check out this simple walk-through, from the video below, to see an example of writing back data to a MS Azure SQL database.

Play Video

          Chapters Index

          00:00 – Teaser end-result
          00:28 – Setting the stage – Data Source being used – MS Azure SQL
          00:49 – Create new Qlik Sense™ App
          01:09 – Add and load data
          01:50 – Edit sheet – add table
          02:30 – Add button – (Reload)
          03:09 – Add Input parameters
          04:10 – Create and assign variables
          06:16 – Add button (Update)
          06:45 – Create App Automation
          07:24 – Assign Automation and set properties to “Update” button
          07:55 – Copy Input Block and start building automation
          09:15 – Save and test
          09:53 – Add more app auto content blocks
          12:25 – Save and test
          13:18 – Conclusion

Stay tuned where we will provide some more insights on how solutions such as this and more can be easily created with some new features and capabilities coming to Qlik™ Cloud.

For information about Qlik™, please visit this site: qlik.com.
For specific and specialized solutions from QQinfo, please visit this page: QQsolutions.
In order to be in touch with the latest news in the field, unique solutions explained, but also with our personal perspectives regarding the world of management, data and analytics, we recommend the QQblog !