Pasting output data directly to database

[rsdhavle]

Hi,

Is it possible to paste output of any chart or table directly to database from qlikview file? If yes how to do that and if not feasible wht is the work around?

[datanibbler]

Hi Rohan,

yes and no - the essential question would be, what kind of database do you have?

[#3]

My thinking on how to achieve this would be to have a batch file that runs based on an event or object trigger.

So the steps would almost be, open QVW, copy data from objectID, paste into .csv/.txt file, import through an SSIS package into the table with all the necessary cleaning up et cetera

Cheers,

Byron Van Wyk

qlikviewramblings.blogspot

[Siva_Sankar]

Rohan,

I'm not sure about inserting the image from qlikview to DB. But you can do writeback of records from qlikview to DB.

check out the discussion here http://community.qlik.com/message/135858#135858

Regards.

Siva

[rsdhavle]

database would be oracle

[Siva_Sankar]

Unfortunately there is no way to write directly to a database with QV. If you want to get data out of QV and into a database then you will have to export to a file and import it using a different tool.

For example, I often want my data in SQL Server so I build a formatted straight table and export it to excel. Then I use SSIS or the SQL Importer to pull the data into a SQL table.

Regards.

Siva

[Siva_Sankar · Accepted solution]

Refer Posting Data from QlikView to Other Systems using the Ajax Client in the following blog.

Posting Data from QlikView to Other Systems using the Ajax Client

Regards.

Siva

[rsdhavle]

Thanks!!