Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

6 Replies

Help! I need Data insert a file QVD from to a BD SqlServer

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.

Not applicable

Help! I need Data insert a file QVD from to a BD SqlServer

Hi,

Can you help me with an example.

Thanks.

Not applicable

Help! I need Data insert a file QVD from to a BD SqlServer

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

Not applicable

Help! I need Data insert a file QVD from to a BD SqlServer

My version QlikView is 8.5

Not applicable

Help! I need Data insert a file QVD from to a BD SqlServer

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
Honored Contributor

Help! I need Data insert a file QVD from to a BD SqlServer

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.

Community Browser