topic Re: Write to Database in QlikView

Write to Database

Thu, 07 Aug 2014 10:25:28 GMT

Hi,

On a button click can i write data in qlikview to database table??

Is this possible in qlikview??

If so,share some example document.

Regards,

Shruthi

Re: Write to Database

ashfaq_haseeb — Thu, 07 Aug 2014 10:31:46 GMT

Hi,

Have a look at the below extension.

http://community.qlik.com/docs/DOC-5970

Regards

ASHFAQ

Re: Write to Database

Thu, 07 Aug 2014 10:31:48 GMT

I dont think it is possible to write data in database table through Qlikview.

Re: Write to Database

m_woolf — Thu, 07 Aug 2014 10:43:21 GMT

Data can also be written to a database with VBScript

Re: Write to Database

deepakqlikview_123 — Thu, 07 Aug 2014 11:17:39 GMT

Using QV it is not possible,QV is just data visualization tool write back to db is not possible.

Re: Write to Database

Thu, 07 Aug 2014 11:38:28 GMT

Hi Shruthi

It seem currently this functionality is not implemented but. Using QV it can be possible,QV is just data visualization tool write back to db is not possible at the present.

Thanks

Re: Write to Database

Thu, 07 Aug 2014 11:49:40 GMT

Hi shruthi,

i agree with Ashfaq mohammed ,

for that u have Set up WebService , u please follow the link shared by Ashfaq mohammed

it is Possible to write back the the qv data to db for that u have to follow the steps , and if ur okey with and answer please make it as correct answer and close the thread

Re: Write to Database

fkeuroglian — Thu, 07 Aug 2014 12:51:08 GMT

Hello, you can use macro to write in database, but it is not recomended.

You have to think if you will have the possibility to the user to write in the data base, is that safe? that a user could acces and write? is that you want?

Re: Write to Database

Fri, 08 Aug 2014 08:00:42 GMT

Well if you talking about modifying the data source tables, then I am afraid it is not possible.

But the data model of Qlikview can surely be modified by using macro or Dynamic Update(version 11) Action.

With dynamic update you can modify the data for the qlikview data model table and then if you want you can refresh the QVD with new set of data.

Can you let us know, your exact requirement please.

Thanks,

Angad

Re: Write to Database

Fri, 08 Aug 2014 08:08:27 GMT

Thanks for your reply.

I have three input fields and a button.

When i fill in these 3 fields and click a button,I want the data from these 3 fields to be stored in a database table.

Can I do it in qlikview??

Regards,

Shruthi

Re: Write to Database

Fri, 08 Aug 2014 08:13:07 GMT

It can not be possible, if you want to store the changes into the database.

Yes we can update the qlikview data model with the help of dynamic update.

in QV 10 - we have to execute VB MAcros

in QV 11 - we have dynamic update functionality we can execute DML operation directly with the help of query.

later on using some logic we can write changes to the QVD and other type of files.

Re: Write to Database

Fri, 08 Aug 2014 08:14:37 GMT

It means you need 3 static values to be stored in database table?

My guess, is that you need to update values of 3 fields shown in a chart, as per the input you do.

Well in any case, you can store the values in variables, access them in script and then refresh the qvd. Or please try Dynamic Update Action once.

Thanks,

Singh

Re: Write to Database

Fri, 08 Aug 2014 08:19:10 GMT

here is the example of

DYNAMIC UPDATE

right now the post is not informatic.

If u have any query u can ask.

Knowledge is Here..: QV9 Dynamic Update

Re: Write to Database

Fri, 08 Aug 2014 09:56:24 GMT

Hi Shruthi ,

It is possible when u use vb script or java script ......

still u wanna know more please go through this

created by mahlerma SQL Writeback from QlikView extension object.