New features and capabilities coming to Qlik™ Cloud
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.
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
For more details, please check this link: https://community.qlik.com/t5/Official-Support-Articles/How-to-build-a-write-back-solution-with-native-Qlik-Sense/ta-p/2059047.
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 !