Help! I need export Data of a file QVD to a BD SqlServer or Oracle

[#1]

Hi, i have a file QVD and i need the data insert to a BD SqlServer

QlikView in there somehow

thanks for the help

Cordially,

Diego

[Oleg_Troyansky]

Using ver. 9.00, you can read the data from QVD, then store it into the text file (the same command STORE can store text files), and then import the text file into SQL Server using SQL Server tools.

[#3]

Hi,

Can you help me with an example.

Thanks.

[#4]

In qv 9 you write this commend

store table into table.text

then after make package in sql server import data from text file

and schedule package in sql server job agent .

Regards

Ashish Srivastava

[#5]

My version QlikView is 8.5

[#6]

Hi,

Ok, my problem is I have 250 tables in QV and I need to export them to Oracle, there is some marcro for it?

thanks.

Cordially,

Diego

[suniljain]

Dear Friend,

Qlikview can Insert data in oracle in following way.

Step 1 : Create CSV file each QVD and store it in intermediate place where oracle server can access that file.

Step 2 : Make Packages in oracle which will insert that CSV File in Oracle Table.

Step 3 : You can Job Schedule in Oracle to automate this process.

Regards,

Sunil Jain.