topic Re: Pasting output data directly to database in QlikView https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604571#M1115884 <HTML><HEAD></HEAD><BODY><P>database would be oracle</P></BODY></HTML> Wed, 19 Feb 2014 09:26:30 GMT rsdhavle 2014-02-19T09:26:30Z Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604567#M1115880 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P></BODY></HTML> Wed, 19 Feb 2014 08:55:25 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604567#M1115880 rsdhavle 2014-02-19T08:55:25Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604568#M1115881 <HTML><HEAD></HEAD><BODY><P>Hi Rohan,</P><P></P><P>yes and no - the essential question would be, what kind of database do you have?</P></BODY></HTML> Wed, 19 Feb 2014 09:01:03 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604568#M1115881 datanibbler 2014-02-19T09:01:03Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604569#M1115882 <HTML><HEAD></HEAD><BODY><P>My thinking on how to achieve this would be to have a batch file that runs based on an event or object trigger.</P><P></P><P>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</P><P></P><P></P><P>Cheers,</P><P>Byron Van Wyk</P><P>qlikviewramblings.blogspot</P></BODY></HTML> Wed, 19 Feb 2014 09:01:51 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604569#M1115882 2014-02-19T09:01:51Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604570#M1115883 <HTML><HEAD></HEAD><BODY><P><BR />Rohan,</P><P></P><P>I'm not sure about inserting the image from qlikview to DB. But you can do writeback of records from qlikview to DB.</P><P>check out the discussion here <A _jive_internal="true" href="https://community.qlik.com/message/135858#135858">http://community.qlik.com/message/135858#135858</A></P><P></P><P>Regards.</P><P>Siva</P></BODY></HTML> Wed, 19 Feb 2014 09:04:23 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604570#M1115883 Siva_Sankar 2014-02-19T09:04:23Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604571#M1115884 <HTML><HEAD></HEAD><BODY><P>database would be oracle</P></BODY></HTML> Wed, 19 Feb 2014 09:26:30 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604571#M1115884 rsdhavle 2014-02-19T09:26:30Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604572#M1115885 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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.</P><P></P><P>Regards.</P><P>Siva</P></BODY></HTML> Wed, 19 Feb 2014 09:33:56 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604572#M1115885 Siva_Sankar 2014-02-19T09:33:56Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604573#M1115886 <HTML><HEAD></HEAD><BODY><P>Refer Posting Data from QlikView to Other Systems using the Ajax Client in the following blog.</P><P><A href="http://www.qlikblog.at/1798/posting-data-from-qlikview-to-other-systems-using-the-ajax-client-and-extensions/" title="http://www.qlikblog.at/1798/posting-data-from-qlikview-to-other-systems-using-the-ajax-client-and-extensions/">Posting Data from QlikView to Other Systems using the Ajax Client</A></P><P></P><P>Regards.</P><P>Siva</P></BODY></HTML> Wed, 19 Feb 2014 09:35:48 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604573#M1115886 Siva_Sankar 2014-02-19T09:35:48Z Re: Pasting output data directly to database https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604574#M1115887 <HTML><HEAD></HEAD><BODY><P>Thanks!!</P></BODY></HTML> Wed, 19 Feb 2014 12:14:39 GMT https://community.qlik.com/t5/QlikView/Pasting-output-data-directly-to-database/m-p/604574#M1115887 rsdhavle 2014-02-19T12:14:39Z