how to write to database?

[Anonymous]

Hello everyone,

I ask you something not easy, I'd like to know if it is possible to write in the database via QlikView.

I know that QlikView does not natively support this feature. So I've done several researches but I have not found anything that would be useful to me.

Has anyone ever had to deal with something like that?

Any help is appreciated, thanks

[Gysbert_Wassenaar]

You can use macro's to instantiate a writable connection with a database and write data to a database. Simply search the internet for vbscript code that writes to a database.

[robert_mika]

Does this help:

How to export data from a qvw file to another database (Firebird, Access, SQL...)

[Anonymous]

unfortunately no, this explains how to export.

What should I do is write on my db where I get my data, so every time I launch the script the data that the user entered is not lost

[ashfaq_haseeb]

Hi,

Check if this helps

SQL Writeback from QlikView extension object.

Regards

ASHFAQ

[Anonymous]

this might be useful.

I also found this "Writeback Extension Installer" on QV market, has anyone tried it?

[Anonymous]

Yes I know, but I'm not an expert and some examples I found are not easy to understand.

[Anonymous]

well guys,

I followed this guide Write back to database via XML output or web service, and I solved the problem by saving the data to XML. Now saving is working properly but I have two small problems:

1) saving only works on the elements currently viewing. Let me explain, mine is a dynamic scenario that changes in response to customer choice. the customer is chosen through a list box, and the table for entries is updated in relation to the customer chose. Each client is associated with a family of products and the table changes its number of lines in relation to the family. So there will never be a constant number of rows.

I'd like to save everything and not just data related to the customer chose.

2) how can I load the saved data in the table?