topic Writing on a SQL database from QV in QlikView

Writing on a SQL database from QV

Fri, 22 Apr 2011 05:50:40 GMT

Hi,

QV reads from a SQL Server database but is it possible to write on a db? How? Is there a sample?

Thanks

Writing on a SQL database from QV

erichshiino — Fri, 22 Apr 2011 06:56:36 GMT

Hi,

This previous post has some discussion on the subject. Basically you have to write a macro, since QlikView is to designed for writing back.

http://community.qlik.com/forums/t/20047.aspx?PageIndex=1

To get more posts, search for 'Wirte back', 'write to database' , 'write to sql', 'write to excel' etc

Writing on a SQL database from QV

Fri, 22 Apr 2011 07:52:17 GMT

Bro,

Please find out the sample atatched to do the same .

Here you can do this by using macro.

YOU HAVE TO ALTER A BIT (PATH CHANGE) IN MACRO.

Dushyant

Writing on a SQL database from QV

Fri, 22 Apr 2011 07:53:53 GMT

Please have alook at this sample qvw also.

Writing on a SQL database from QV

Fri, 22 Apr 2011 22:40:01 GMT

Hi,

with ADODB connection is it possible to use the Windows authentication?

Thanks

Writing on a SQL database from QV

Thu, 15 Mar 2012 15:04:15 GMT

hi dushyant:

Can you write back the QV table data into Sql server? For example I have created a what if analysis report in qlikview. And after I selected some conditions I want save this version. Then write back to DB, then can compare the actual data & version data.

Thanks/peach