topic Re: writing back to DB in QlikView

writing back to DB

rathnam_qv — Fri, 26 Sep 2014 07:39:34 GMT

Hi All,

i have 4 input boxes in my app.

if the entered some data in 1st box.....i want to store that data in Oracle database with separate table.

i want to create a table with 4 fields for the 4 inputboxes in a single table.what ever the entered into the boxes that should store in that table.

how to achieve it.

i am using Qlikview 11.2 and Oracle 11g.

with out server i want to do it.

PFA image.

Regards,

Rathnam.

Re: writing back to DB

Fri, 26 Sep 2014 08:20:29 GMT

Follow these steps:

1. "Input Box" object to insert values

2. Create Macro to update the value

3. you need a filter to specify the updating criteria

Macro part:

ActiveDocument.GetVariable <variable name>.GetContent.String

ADODB object to be created with insert/update

you will find example on the net for sure.

Good luck

Adel

Re: writing back to DB

rathnam_qv — Fri, 26 Sep 2014 09:14:14 GMT

Hi Adel,

Thanks for your reply.

i am not that good at vbscript.if you have any link for this plz send me.

Regards,

Rathnam.

Re: writing back to DB

marcus_sommer — Fri, 26 Sep 2014 10:05:52 GMT

See here:

Write Back to Database via ETL process (using CSV or XML)

Write back to database via XML output or web service

SQL Writeback from QlikView extension object.

- Marcus

Re: writing back to DB

rathnam_qv — Fri, 26 Sep 2014 10:57:00 GMT

Hi Marcus,

Thanks for reply.

here they are using table from database.

but, my requirement is when the user enters some comments in the inputbox...first we need to create a table in database and the entered comments should store in the table.

Regards,

Rathnam.

Re: writing back to DB

marcus_sommer — Fri, 26 Sep 2014 11:20:04 GMT

Here an example Database write-back on Accesspoint which Adel Hamza mentioned.

- Marcus