topic Re: Can I update a SQL Server database table using a Qlikview .qvw? in QlikView

Can I update a SQL Server database table using a Qlikview .qvw?

dvilmain1234 — Sat, 16 Nov 2024 20:46:41 GMT

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?

Re: Can I update a SQL Server database table using a Qlikview .qvw?

parthesh — Tue, 28 May 2019 15:13:31 GMT

We was having same need for oracle database, we have to give some permission in ODBC Connection string and than we can call DB function from QVW script in which we can pass parameter.

so we have created Insert function in DB and we passed value in Function parameter and those value we have inserted in table.

i dont have code handy , but let check if i will get code i will post it also.

hope this will help.

Regards,
Parthesh.

Re: Can I update a SQL Server database table using a Qlikview .qvw?

dvilmain1234 — Tue, 28 May 2019 15:21:09 GMT

Thanks for the update. I'd love to see the code for this. When does the insert/update take place?

Re: Can I update a SQL Server database table using a Qlikview .qvw?

parthesh — Tue, 28 May 2019 15:25:47 GMT

Insert operation was handled at DB level only. we was inserting data into our custom table.
let me check for code ... give me 1-2 hours.

Re: Can I update a SQL Server database table using a Qlikview .qvw?

Chip_Matejowsky — Tue, 28 May 2019 16:38:19 GMT

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.

Re: Can I update a SQL Server database table using a Qlikview .qvw?

parthesh — Tue, 28 May 2019 17:59:57 GMT

Hello,

you can write

Insert_budget:

SQL

{?=call schema.fucntion_name()};

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.