Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Insert QlikView data into another DB

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?

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

4 Replies
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

mstoler
Partner - Specialist
Partner - Specialist

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