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 !
@Sandeep-cv2wz
4 ай бұрын
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
4 ай бұрын
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.
@reji24
7 ай бұрын
Great video. I don't see the action Enable Automation. How do I get this? We are on May 2023 upgrade level.
@QlikOfficial
7 ай бұрын
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.
@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.
@JohnnyMarinez
7 ай бұрын
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
6 ай бұрын
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
@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: kzitem.info/news/bejne/1q2q1qGgrp-WnZg
@fcasarotto
Жыл бұрын
Super cooooooool!!!! Thanks Mike!
@manikantapavanjairamthorat52
9 ай бұрын
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
9 ай бұрын
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.
@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 - kzitem.info/door/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
@user-zv5yz9nh6w
Жыл бұрын
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
@user-zv5yz9nh6w
Жыл бұрын
@@QlikOfficial Thank you, when I create a new automation the option appear and show all automations. Thank you
@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!
@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
@Felipelino406
Жыл бұрын
does the reload function (Button) work for analysers?
@QlikOfficial
Жыл бұрын
Hi Felipe - please see this video - it should answer your question kzitem.info/news/bejne/1q2q1qGgrp-WnZg
@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..
@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
@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.
@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.
@thooper76
11 ай бұрын
Hey - can this work with section access also for passing back parameters, or does it have to be selected?
@QlikOfficial
11 ай бұрын
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
11 ай бұрын
@@QlikOfficialexplains it very clearly, thank you. Will keep this in mind with how we design the automation :)
Пікірлер: 46