This Knowledge Base has been specifically developed as a self-service hub to problem solve issues and feedback relating to the Qlik Sense Writeback Extension developed by Pomerol.
Click through the list of commonly asked questions, or search our Knowledge Base for specific feedback. You can find out more about the Writeback Extension on our main product page too – https://pomerolpartners.com/qswe-product/
7.1 FAQs explained in under a minute
Click through the accordion and watch a short video explanation…
1. Who are Pomerol’s Clients?
Find out more about Pomerol and some of the clients that we’re working with, or click here to visit our website.
In this video, Scott talks us through what Pomerol does, and clients that we’ve worked with…
In this video, Scott talks us through what Pomerol does, and clients that we’ve worked with…
2. What is the Writeback Extension?
Watch the video below to find out how the Writeback extension can enrich your Qlik environment, or click here to visit our product page.
Learn about what the Writeback Extension is, and how it can extend your Qlik environment…
Learn about what the Writeback Extension is, and how it can extend your Qlik environment…
3. How does it improve my Qlik experience?
The Writeback Extension allows users to write back data directly into your published Qlik applications, thereby minimizing task switching and eliminating spreadsheet risk from manual reconciliation…all in real-time!
4. What are some of the real world use-cases?
The Writeback Extension has a number of different use-cases applicable across various industries including Sales, IT, Operations, Finance & Marketing. Scott talks us through some of the most widely implemented use cases that the Writeback is currently being used for…
5. How can the Writeback Extension improve Traditional Qlik Dataflow?
Find out how the Writeback Extension augments traditional data flow within the Qlik Environment, by writing data directly back into your source ERP or CRM system databases.
Scott talks us through the traditional Qlik data flow environment, and shares how the Writeback Extension can be used for real-time collaboration to improve data sets and ensure you’re making the best business decisions based on the right data!
Scott talks us through the traditional Qlik data flow environment, and shares how the Writeback Extension can be used for real-time collaboration to improve data sets and ensure you’re making the best business decisions based on the right data!
6. Understanding the Writeback Data Cycle?
Learn about how the Writeback Data Cycles works in the context of your Qlik environment, and how this can be flexibly configured to work with your existing Qlik applications to meet your business needs.
Scott explains how the Writeback Data Cycle works, and how it is configured within your existing Qlik environment.
Scott explains how the Writeback Data Cycle works, and how it is configured within your existing Qlik environment.
7. How do Profile Types and User Access Permissions work with the Writeback Extension?
The Writeback Extension has been forged and fire tested in Tier 1 Enterprise environments and is suitably configurable to ensure fine-grained User Permissioning, data-sensitive constraints, and full audit visibility.
In this video, Scott shows us how the Writeback Extension can be configured to ensure sensitive data is protected, and existing user permission hierarchies can be set up according to your needs.
In this video, Scott shows us how the Writeback Extension can be configured to ensure sensitive data is protected, and existing user permission hierarchies can be set up according to your needs.
8. Can I see the Writeback Extension in action? (Sales Discount Modelling & Approval Demo)
The Writeback Extension has a number of different use-cases that we are continually expanding upon. One of the most popular ones we’ve implemented is for Sales Teams for ‘live’ Discount Modelling & Approval workflows.
In this video, Scott explains how the Writeback has helped numerous sales teams improve the quality and speed of their data flows & approvals, and model Sales Discounts in real-time!
In this video, Scott explains how the Writeback has helped numerous sales teams improve the quality and speed of their data flows & approvals, and model Sales Discounts in real-time!
9. Does the Writeback Extension have editable Settings? (Explore v3 GUI)
The Writeback Extension has a number of features to ensure you have full control over your Writeback user access, data permissions and input data governance.
In this video, Scott shows you our latest UI release, and explains how you can set up the extension with fine grain control.
In this video, Scott shows you our latest UI release, and explains how you can set up the extension with fine grain control.
10. How is the Writeback Extension set up in Qlik Sense?
The Writeback Extension has a few different elements that need to consider as you set up the extension in your Qlik environment.
In this video, Scott explains how to set up the enviornment, the required SQL data tables and the edits required to the Qlik load scripts, from the perspective of the app builder.
In this video, Scott explains how to set up the enviornment, the required SQL data tables and the edits required to the Qlik load scripts, from the perspective of the app builder.
11. What are the different ways to set up the load scripts?
There are a few different ways to set up the Qlik Load Script depending on your use case.
In this video, Scott explains three Data Modelling Options and gives a simple example of a load script in the context of a sales negotiation process.
In this video, Scott explains three Data Modelling Options and gives a simple example of a load script in the context of a sales negotiation process.
12. How do Partial Reloads work with my Qlik Application?
Partial reloads of the Qlik app are required to minimize the time taken to pull edited data from the SLQ table back into the application.
Scott explains how partial reloads work, and the 3 Qlik statements that are used for partial reloads. He also highlights the key things to look out for when setting up your load scripts.
Scott explains how partial reloads work, and the 3 Qlik statements that are used for partial reloads. He also highlights the key things to look out for when setting up your load scripts.
13. How does the Writeback Extension manage User Monitoring and Error Handling
For user monitoring, we have all edits stored in the history table, for full auudit trail. Error handling is managed through status messages inside the extension pop-up that tell us about the status of teh API connection and alerts users to any configuration errors. Full debug logging is generated and Qlik log scripts can be used to debug partial reload errors.
In this video, Scott dives into the detail inside the writeback window, and shows examples of some of how error messages are proactively managed and displayed.
In this video, Scott dives into the detail inside the writeback window, and shows examples of some of how error messages are proactively managed and displayed.
14. What’s in the 2020 Development Pipeline for the Writeback Extension?
There are a number of exciting features that have been flagged for development in our 2020 pipeline.
In this video, Scott talks through the Writeback product roadmap, including new database options (MariaDB, Google BigQuery), enhanced customization options of teh writeback window, improved license management, data governance enhancements (incld. date picker edit type), and form view editing option.
In this video, Scott talks through the Writeback product roadmap, including new database options (MariaDB, Google BigQuery), enhanced customization options of teh writeback window, improved license management, data governance enhancements (incld. date picker edit type), and form view editing option.
15. How does the Writeback Extension add value to my Qlik investment? (ROI)
The Writeback has a proven track record when it comes to improving the speed, efficiency, accuracy and productivity of your team. It reduces spreadseet risk and manual data consolidations by using the native governance structures inhenrently built into the SQL ecosystem, and it reduces the need for external tools, saving you time and money, and leveraging your existing Qlik investment!
16. What is the Writeback Extension implementation process?
We have a simple step by step implementation process that involves preparing the environment, installing the required software and packages, setting up the SQL databases and tables, configuring the load scripts, and linking the extension to your Qlik application.
In this video, Scott also explains the value of doing a 30 day proof of concept so you can assess and evaluate the value in the context of your use cases, and organization.
In this video, Scott also explains the value of doing a 30 day proof of concept so you can assess and evaluate the value in the context of your use cases, and organization.
7.2. Enterprise-ready Governance Architecture
We often get asked how our Writeback Extension for Qlik Sense works. In this quick video, Scott Duthie, Principle Consultant at Pomerol Partners explains the workflow that goes on behind the scenes. In particular, Scott highlights the key pieces of governance and functionality that make the Pomerol Writeback Extension enterprise ready!
Updated on April 30, 2021
Need Support?Contact Support