topic Insert QlikView data into another DB in QlikView

Insert QlikView data into another DB

Anonymous — Wed, 14 Sep 2011 19:58:23 GMT

Hello, I am new to QV. I want to take some information from QlikView and then export it and use in another DataBase. Like paste that field outside QV.

How can I do that?

Thank you very much.

But if I don't want to create a new document, just insert the data in the other DataBase... or is always necesary to have this excel file in orther to link the variables?

Insert QlikView data into another DB

Wed, 14 Sep 2011 20:00:04 GMT

You can right click the object containing the information you want and export it to excel.

Insert QlikView data into another DB

Wed, 14 Sep 2011 20:07:17 GMT

The most straight-forward option is to export it to excel and then use that as the data source. I would suggest creating a straight table report that formats the columns in a way that would match the import.

You could also store the data in a QVD and use that as a data source. This would be a good option if it's something that you would want to do on a schedule.

Insert QlikView data into another DB

Wed, 14 Sep 2011 20:30:40 GMT

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.

Insert QlikView data into another DB

mstoler — Wed, 14 Sep 2011 21:46:20 GMT

You can develop a vbscript to write back to a database. Have you consider this approach?