Discussion Board for collaboration on QlikView Scripting.
Hi, i have a file QVD and i need the data insert to a BD SqlServer
QlikView in there somehow
thanks for the help
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.
Can you help me with an example.
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 .
My version QlikView is 8.5
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,
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.