Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
vgodoy78
Contributor II
Contributor II

Is it possible to export qlikview data directly to a sql database? Or connect a SQL database to a QlikView?

We need to provide a payor with data for a form called QRIA 387. The data cannot be submitted as a flat file and the vendor cannot connect to the main data source. We are currently extracting the required data into Qlik and I am wondering how to pass the data from the data model into a SQL database where the vendor can point to and extract the data.

thanks!

Varinia

6 Replies
devarasu07
Master II
Master II

Hi,

You mean to say Write back from Qlikview to SQL database?

FYI, we can connect sql database as source for QLikview.

Tks,Deva

vishsaggi
Champion III
Champion III

In QV are you storing the QRIA 387 data as Table?

vgodoy78
Contributor II
Contributor II
Author

Yes, I need to write back to a SQL Database.

vgodoy78
Contributor II
Contributor II
Author

No, I do not have access to the form itself. I just have access to the field requirements.

vishsaggi
Champion III
Champion III

Check if this can give you some hints to do?

Can we insert data or records from qlikview to Database

devarasu07
Master II
Master II

Hi,

Yes we can do that.  how many column values your going to update into db?

(make sure u have less volume of data) and avoid doing it in transnational table system.

SQL Writeback from QlikView extension object.

How to make Qlikview a real time system Update DB and Qlikview Online