how to export QVD data to DB

[vinod2086]

Hi all,

i have one doubt every time we are connecting to Database and importing data after that we are store table into QVD.

my Question is, is there any possible way to send QVD data to any other Data Bases.

in this case any credentials required.

Dear experts Please let me know

[simospa]

Hi,

when you estabilish a connection with your db, usually you use SELECT statement, but you can use other SQL instruction, as UPDATE, INSERT and DELETE.

For example, you could load a qvd in a QlikView table, then read every row and execute an INSERT to your DB.

S.

[#3]

I'm interested in this also, I have never managed to get it to work but it seems like it should be easy.

[vinod2086]

Hi Spanio,

Thanks for yr reply

i dont know how to estabish connection between DB2 and Qlikview

here i want to use Qlikview is Source and DB2 is Target

[#5]

Try this

DB2 Connection

[#6]

It helped me.

[Peter_Cammaert]

Do not forget to enable the checkbox called "Open Databases in Read and Write mode" in Script Editor->Settings (tab at the bottom). And make sure that the DBMS account account has R/W privileges to all tables you want to modify. That may not be the case right now, but you won't notice if you're using QlikView for ETL only.

[vinod2086]

dear Peter i think you are not getting my point

by using ODBE/OLEDB we can import data from other DB's.

but my question how to export Qlikview(QVD) data to DB2.

if this is possible how to establish connection b/w DB2 to Qlikview.

and what are the credentials required.

if any one are good in DB pls let me know

[Peter_Cammaert]

I think Peter is getting your point very well.

The thing is that ODBC/OLEDB connections are - by default - two way channels. You can both send to and receive data from your database. It's only that QlikView - again by default - sets the channel to one-way data transfer only. That's normal for a BI-tool that should not be messing with the original data.

In Peter's link, look for a post by Noman Khan that contains a connection string with a Mode= parameter. That should do it.

Peter-2

[adriano_fornoni]

Hi Vinod,

you could try to save data in a txt file and then import the file in the DB.

May it be useful?

Bye

Adriano