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

[vgodoy78]

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

[devarasu07]

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]

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

[vgodoy78]

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

[vgodoy78]

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

[vishsaggi]

Check if this can give you some hints to do?

Can we insert data or records from qlikview to Database

[devarasu07]

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