topic Updating SQL Table through QlikView in QlikView

Updating SQL Table through QlikView

niegel — Tue, 19 May 2009 01:47:28 GMT

is this possible?

I use QlikView to identfy record owner conflict and would like to update the SQL DB based on the query result.

Updating SQL Table through QlikView

Tue, 19 May 2009 02:09:17 GMT

Hi Niegel,

No this is not possible since QlikView per definition accesses databases in read-only mode.

regards Mark

Updating SQL Table through QlikView

Anonymous — Tue, 19 May 2009 20:47:17 GMT

Mark,
It is possible to use read/write mode. I used it to cerate and to drop index, but it could be used for any SQL statement.
(Or maybe it was changed recently? I did it long ago, probably in QV 5...)

Updating SQL Table through QlikView

Tue, 19 May 2009 21:06:33 GMT

It can be done using a Macro

Here is an example.

Hope that helps

Philippe

---------------------------------------------------------------------------------------------------------------------

sub Connection

set conn=CreateObject("ADODB.Connection")
conn.Open "CONQ"
set rs=CreateObject("ADODB.recordset")
risque = getVariable("Change")

set inventory = ActiveDocument.Fields("codeinv").GetPossibleValues

for i = 0 to inventory.Count-1

' Database Update

sql="UPDATE invd3 SET "
sql=sql & "risqueqte='" & risque & "'"
sql=sql & " WHERE codeinv='" & inventory.item(i).Text & "'"

on error resume next
conn.Execute sql
if err <> 0 then
msgbox("No update permissions! " & err )
end if
'End of the Update
Next
conn.close
end sub

function getVariable(varName)
set v = ActiveDocument.Variables(varName)
getVariable = v.GetContent.String
end function

-----------------------------------------------------------------------------------------

Updating SQL Table through QlikView

niegel — Wed, 20 May 2009 02:16:54 GMT

Philippe,

This is interesting. I'll try it out and give my feedback about this process.

Niegel

Updating SQL Table through QlikView

Wed, 20 May 2009 18:14:16 GMT

Very interesting. Can somebody confirm that you can update data sources from a reload script in the current QlikView version (8.5 or 9)?

Updating SQL Table through QlikView

Wed, 06 Apr 2011 15:17:17 GMT

it's in 9

Updating SQL Table through QlikView

Wed, 06 Apr 2011 15:27:21 GMT

Hi,

It is possible to write back to database through macros irrespective of script privilages in the edit script section.

Using vb script I am writing back to the database(MYSQL) and selecting the data from database(MYSQL) with reloading of QVW file. Macros are triggered while opening the sheet.

Updating SQL Table through QlikView

Wed, 06 Apr 2011 15:46:39 GMT

Using a restful api it makes it simple too.