Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview write database back to mysql

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?

5 Replies
Anonymous
Not applicable
Author

Hi,

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

Paul

simondachstr
Luminary Alumni
Luminary Alumni

Extension objects are the more elegant solution.

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

miikkaqlick
Partner - Creator II
Partner - Creator II

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

miikkaqlick
Partner - Creator II
Partner - Creator II

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));

Next

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

Br,

Miikka

Not applicable
Author

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.