topic Re: Qlikview write database back to mysql in Water Cooler

Qlikview write database back to mysql

Thu, 15 Aug 2013 05:56:45 GMT

Hi,

Anyone know how qlikview can write data back to mysql or any other database?

If by using macro, may I have any sample of the vbscript?

Re: Qlikview write database back to mysql

Anonymous — Fri, 22 Nov 2013 20:03:31 GMT

Hi,

If it's still actual, found this item Writing to SQL DB from Macro

Paul

Re: Qlikview write database back to mysql

simondachstr — Wed, 04 Dec 2013 12:08:41 GMT

Extension objects are the more elegant solution.

You'll need a WebService for that to handle the SQL queries.

Re: Qlikview write database back to mysql

miikkaqlick — Wed, 04 Dec 2013 12:19:00 GMT

Hi!

You can write to any SQL straight from script.

Normally you write to script:
SQL Select * From Users;

You can write:

SQL Insert into Users

Values ('ID1','John','Smith');

Br,

Miikka

Re: Qlikview write database back to mysql

miikkaqlick — Wed, 04 Dec 2013 12:39:54 GMT

I've made that with for-loop and variables.

I don't have that example here, but it was something like this:

for i=0 to 10

Read:

Load

Dim1,

Val1

From

Example.qvd (qvd)

Where

RowNo() = $(i)

;

Write:

SQL

Insert into Example

Values(chr(39)&Dim1&Chr(39),chr(39)&Val1&Chr(39));

You have to use Chr(39), you'll see:)

Br,

Miikka

Re: Qlikview write database back to mysql

Thu, 05 Dec 2013 09:04:32 GMT

I want from front end instead of scripting. But anyway, I used dynamic update. This action can help to upload the data into table. But need to store into qvd or other table files because dynamic update action just update the data to memory, after reload, it's gone.