Creating a basic write back solution with Qlik Cloud

[@simonheap5654]

Thanks, Mike, really nice. And really good that you emphasise that you can write back to anywhere - writing back to your main source of data (cleaning through Qlik) might not be a desired use case, but really, really great for this demo! Awesome.

[@antoinelepoutre5335]

Thanks. Really nice video. Would be great to have the same kind of content but with updating QVD files !

[@QlikOfficial]

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 to see an example of writing back data to a MS Azure SQL database. community.qlik.com/t5/Official-Support-Articles/How-to-build-a-write-back-solution-with-native-Qlik-Sense/ta-p/2059047 Bonus Video: Creating a Reload button with Qlik Application Automation for all users: kzbin.info/www/bejne/q6jXoaCgqtKYoMU

[@CotisoHanganu]

Cool & clear! Tx, Mike! What about 1. adding and deleting rows? (can it be done the same way? Requires all interface to be repeated 3 times? + PK handling for new row) 2. Working with multiple rows in the same time? (is it possible without 3rd party extensions, like inphinity forms or vizlib write back?)

[@QlikOfficial]

Hi Cotiso - It can be done using any of the components available in app automation - as long as that component, end-point, source API etc supports it. I chose the simple update row block to keep things simple, but there is also a SQL block where you can write custom SQL. Anything is possible pretty much.

[@cabby0711]

Thanks, this is great! I'm running into an issue where none of my analyzers or professional licensed users are able to reload the app using this method. Where can I find more info on that?

[@QlikOfficial]

Hello Marie - I think the reason is that - only the owner of the app - can use a RELOAD action in a button. You can work-around this by creating an App Automation that reloads the app instead. I plan on making a quick video on it shortly - so stay tuned to this playlist - kzbin.info/aero/PLW1uf5CQ_gSqF5bcmbBrk1q7Q4-h899V1 - also please be sure to join the Qlik Community as questions like this can be answered very quickly by our members: community.qlik.com/t5/New-to-Qlik-Sense/bd-p/new-to-qlik-sense Happy to help - Regards, Mike T

[@manikantapavanjairamthorat52]

Hello Mike, Thanks for the nice info,.. Same solution i am using in my case but iam getting error in SQL block it might be due to Connection ( what we have to give in Host??) could you please let me know

[@QlikOfficial]

Hi Mani - it would be best to open a thread in the qlik community - there can be a number of things - the host needs to be accessible from Qlik Cloud - so a firewall rule would be necessary to allow the cloud IP addresses in most likley: help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm - please note that RDBMS sources of data configured using Data Access and Movement data Gateways are not supported as sources in App Automation.

[@Sandeep-cv2wz]

Thanks, Mike !! I am trying to connect the Qlik cloud to Azure SQL db similarly as you presented, but when trying to use same credentials for my Automation under microsoft sql it is throwing error. Do I need to create a microsoft sql server connection using the same table for the Qlik automation ?? Or can I use the same Azure DB credentials for the automation connection. Please help in this issue.

[@QlikOfficial]

Hi Sandeep - its best you aske this question in the Qlik Community here: community.qlik.com/t5/Qlik-Application-Automation/bd-p/qlik-application-automation-discussions - the community is better suited to answer you with examples and screenshots etc. without seeing the error and without more information it is difficult to troubleshoot.

[@fcasarotto]

Super cooooooool!!!! Thanks Mike!

[@JohnnyMarinez]

Is there any way to add some error trapping / messaging within the automation to make this a bit more robust? The potential here is huge, in allowing users some control in updating back t SQL, particularly around more generals static / meta data, or adding comments. I did a quick test creating an automation to capture app id , user , timestamp and to a table , which works 75% of the time without a hitch, but 25% of the time there's just an abstract 'automation error' with no known change in any of the parameters.

[@QlikOfficial]

Hi John - this comment / question got lost in the shuffle - I apologize for the delay - I have this question out to the product manager and will update you once I hear back. You can always post questions like this in the qlik community forum as well for a speedier reply - here is the link: community.qlik.com/t5/Qlik-Application-Automation/bd-p/qlik-application-automation-discussions

[@reji24]

Great video. I don't see the action Enable Automation. How do I get this? We are on May 2023 upgrade level.

[@QlikOfficial]

Hi - it sounds like you are using the client-managed (Windows Enterprise) edition of Qlik Sense and not Qlik Cloud - this action is only available on Qlik Cloud. Please let me know if you have any more questions.

[@QuetsyaKolo-ft8hy]

That's a very useful feature! Is it possible to do the same with spreadsheet instead of SQL? I've tried with the "update range/row in sheet" blocks with no success.

[@QlikOfficial]

Hi Quetsya - I am not sure about that one - can you post your question here: community.qlik.com/t5/Qlik-Application-Automation/bd-p/qlik-application-automation-discussions - I will also make the PM aware of your scenario and see what he says. Thanks for your question. Regards, Mike T

[@QuetsyaKolo-ft8hy]

@@QlikOfficial thanks for your answer Mike I'll post it in the community.

[@pavelsimunek]

Thanks Mike, is there a way to add new line also?

[@QlikOfficial]

Hi Pavel - Yes - this is really up to the automation block used in the workflow - I just chose to use Update blocks for MS SQL - but you could use a custom SQL block and insert block etc. Pretty much whatever is available. Hope this helps - Mike T

[@dirkpetercasteleijn]

Again, nice work Mike. Really putting nice features out the last weeks! :) Would this work to update QVD files as well?

[@QlikOfficial]

Thanks Dirk - I would imagine so with the number of Qlik Cloud blocks available and the power of Qlik Script - you could call an incremental load or generate QVDs etc. So I don't see why not. I think a bigger question might be not so much if you could - but if you should ;-) - stay well man!

[@CarloMenta]

Nice video but in my tenant I can't find the "execute automation" in the list of the actions. There is something to enabled to see this?

[@QlikOfficial]

Hi Carlos - there was a glitch yesterday - the option should be back - if not let me know. - Regards, Mike T

[@CarloMenta]

@@QlikOfficial Thank you, when I create a new automation the option appear and show all automations. Thank you

[@Felipelino406]

does the reload function (Button) work for analysers?

[@QlikOfficial]

Hi Felipe - please see this video - it should answer your question kzbin.info/www/bejne/q6jXoaCgqtKYoMU

[@RajdeepAllahabadia]

@qlikofficial Can we do this writeback operations if we are connected to a onprem database via qlik direct gateway

[@QlikOfficial]

Hello Rajdeep - yes I believe so as in theory the data connection in App Automation is nothing more than just configuring a regular database connection. BUT I am not sure if the gateway itself supports those types of transactions - I will ask and reply back here if I hear differently.

[@QlikOfficial]

Hello Rajdeep - as promised - it may not be a supported configuration with the gateway as Application Automation primarily focus primarily on cloud systems BUT you can access your on prem RDBMS as well by creating firewall rules and setting up the correct allow-listings as defined here: help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm - longer term they will look at gateway options - thanks for your question.

[@marysecharbonneau1580]

I have the same scenario. Our qlik sense is SaaS but not our datawarehouse. So using the Qlik Gateway for writing back to our SQL server onprem would be great

[@thooper76]

Hey - can this work with section access also for passing back parameters, or does it have to be selected?

[@QlikOfficial]

Hi there - here is what I researched for you - in short no, not really, the parameters would still have to be selected. Allow me to explain and if you have other questions, please let us know or post in the qlik community as well Regards, Mike T In the app UI, you will see the section access will be applied. But once you trigger the automation, if the automation owner has no section access restrictions, the automation won't know about any restrictions applied to the user who clicked the button. For example, take the north region example and a flow setup that allows you to update records one by one: You're region is north, you open the app and you only see data for the north region You select a single record to do writeback (by id) & click the button This will trigger the automation, it can get the record id from the selection and apply the update. In this example I don't see any problems, even though the automation has access to all records, since the ID is supplied it won't update any records the user isn't allowed to access BUT ....take now an example where a multi update is allowed (same north region section access): User wants to update all records that relate to paper products, They apply a selection on "paper" for all records & click the button This will send a bookmark to the automation with only a selection on product and the automation will update all products where product=paper This would be a problem since no record ids are sent to the automation so it will update all records where product=paper without applying the section access of region=north I hope this explains it cleartly.

[@thooper76]

@@QlikOfficialexplains it very clearly, thank you. Will keep this in mind with how we design the automation :)

[@salmankojar]

hey i tried to replicate same process as you shown in above video but i dont get the same result as yours.If i select a particular row and then click on update button it works properly but if i type something in input box then update doesnt works at all and it also overwrite the variable assigned to that particular variable input box permanently.can you help me with this problem?

[@QlikOfficial]

Hi Salman - thanks for your question - you must press enter after typing in the input box. As for the reassign of the variable I am not sure about that one - that might be a bug - you may need to open a case in the support portal for that. Please note it will be better for you to use the qlik community forums to post questions such as this so we can continue to help you better. Thanks

[@salmanabdullakojar3277]

@Qlik i do press enter after typing and after pressing enter varaible gets reassigned. I will raise this question in community support for sure..hope i get some clue about this in community support..Thanks for your reply..

[@Slate-Mate]

Will it be available on On Prem version??

[@QlikOfficial]

App Automation is just available in Qlik Cloud, but I believe the ability for the button to execute external processes is there in on-prem - just not the ability to execute an app automation.

[@Slate-Mate]

@@QlikOfficial See being Qlik developer, I face many issues regarding GUI flexibility...so I guess whatever features are coming in SaaS version, should be available in On-Prem at the same time....Reason : Many Finance organisation using Qlik don't go for Cloud due to security concern...... QlikSense is an amazing tool I have been working on it more 6 years now...But I think GUI flexibility is still a barrier as recently they are releasing it in SaaS....like control over fonts, font size background.......these are small things but matters a lot while designing

[@chrissteele8584]

@@Slate-Mate There are Write Back extensions available for purchase for Qlik Sense on-premise that your Qlik Sales Rep can inform you about.

[@andreNZ]

Hmmm when I update the input field and hit enter, my variable value doesn't change so when it gets sent to the automation it's the old value...any insights why this may be happening?

[@andreNZ]

Further testing, it seems that the input box can't/doesn't overwrite the default variable value? (=Title in your example).

[@QlikOfficial]

Hi Andre - yes I am investigating this - it is something to do with the variable and input box - which is something different - I need to see why this happens on my side as well. Thanks for your comment.

[@ricardoveloso9163]

Really helpfull, thank you !!!!!!