Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We've been asked to research how we can have users of our Qlikview .qvw update our SQL Server database from within their Qlikview document. I see some mention of this, but I was hoping to see an actual example. Does anyone have an example of this working?
Thanks for the update. I'd love to see the code for this. When does the insert/update take place?
Hello @dvilmain1234,
Just wanted to provide an FYI regarding database "writebacks" from QlikView. While it may be possible to configure this type of functionality successfully, it isn't part of the core functionality of the product and isn't supported by Qlik Support. Thanks.
Hello,
you can write
Insert_budget:
SQL
{?=call schema.fucntion_name()};
or
you can directly fire insert into statement on your table
SQL insert into your_table_name values $(vInsertValue);
where vInsertValue is a variable, that will contain all columns same as we are normally do in insert into.