topic Re: Update Script in Qlik Sense. in Integration, Extension & APIs

Update Script in Qlik Sense.

Wed, 27 Apr 2016 11:22:01 GMT

Hi!

I am using Qlik Senes 2.2. The date source from a DB server. I have a table with 6 columns and 2 of them have "null" values (one of the field is a bool type and the other one is text). What I want ,after making selections, to update this two fields in the Data Warehouse from a Qlik Sense app. Is there a possibility to run back the SQL update script from the Qlik Sense.

I hope there is a way that help me out.

Thanks a lot in advance.
Ziad.

Re: Update Script in Qlik Sense.

Gysbert_Wassenaar — Wed, 27 Apr 2016 15:45:20 GMT

Not without an extension. Something like this, but then for Qlik Sense: SQL Writeback from QlikView extension object. The architecture would be very similar. You'll need a web service that can be called from the Qlik Sense extension and that will execute the update statement in your database.

Re: Update Script in Qlik Sense.

Thu, 28 Apr 2016 12:49:52 GMT

Hi Gysbert!

Thanks for your reply. So I need to develop an extension by myself and add it to qlik sense then I can use this method (because the example in the link is QlikView one)

Re: Update Script in Qlik Sense.

Gysbert_Wassenaar — Thu, 28 Apr 2016 16:22:20 GMT

Yes, that's correct.

Re: Update Script in Qlik Sense.

gainkarthi — Thu, 28 Apr 2016 19:37:48 GMT

Try this also,

http://market.qlik.com/writeback-extension-installer.html

Re: Update Script in Qlik Sense.

Fri, 29 Apr 2016 08:05:03 GMT

Thanks Karthikeyan, but I am using Qlik Sense.