topic Re: how to export QVD data to DB in QlikView

how to export QVD data to DB

vinod2086 — Tue, 26 May 2015 07:20:56 GMT

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

Re: how to export QVD data to DB

simospa — Tue, 26 May 2015 07:24:51 GMT

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.

Re: how to export QVD data to DB

Tue, 26 May 2015 07:31:54 GMT

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

Re: how to export QVD data to DB

vinod2086 — Tue, 26 May 2015 07:34:54 GMT

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

Re: how to export QVD data to DB

Tue, 26 May 2015 07:38:43 GMT

Try this

DB2 Connection

Re: how to export QVD data to DB

Tue, 26 May 2015 07:38:58 GMT

It helped me.

Re: how to export QVD data to DB

Peter_Cammaert — Tue, 26 May 2015 07:43:09 GMT

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.

Re: how to export QVD data to DB

vinod2086 — Tue, 26 May 2015 08:03:51 GMT

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

Re: how to export QVD data to DB

Peter_Cammaert — Tue, 26 May 2015 08:13:25 GMT

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

Re: how to export QVD data to DB

adriano_fornoni — Tue, 26 May 2015 08:18:01 GMT

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