topic Re: QlikView data into SQL in QlikView

QlikView data into SQL

Mon, 22 Jul 2013 14:30:12 GMT

Hi QV Community,

I am trying to load QV data into SQL as a test without using VB and dont seem to have any luck. I am using the below script, and it is erroring out, can someone help?

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Clinicom_Temp;Data Source=LPTLoad01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=QVLPT01;Use Encryption for Data=False;Tag with column collation when possible=False];

T1:
LOAD * INLINE [
F1, F2
F, 6
G, 7
H, 8
I, 9
J, 10
];

For i= 0 to NoOfRows('QVtoSQL') -1
LET V_F1 = peek('F1',$(i),' QVtoSQL ');
LET V_F2 = peek('F2',$(i),' QVtoSQL ');
SQL INSERT INTO QVtoSQL (F1,F2) VALUES('$(V_F1)','$(V_F2)');
NEXT

Re: QlikView data into SQL

Gysbert_Wassenaar — Mon, 22 Jul 2013 14:35:33 GMT

Make sure to enable the option Open Database in Read and Write Mode on the Settings tab of the script editor. Otherwise the connection will be read-only. And of course the user you connect as needs insert priviliges in the target database.

Re: QlikView data into SQL

kaushiknsolanki — Mon, 22 Jul 2013 14:37:20 GMT

Hi,

Its not possible to directly push the data from QlikView to Database.

Have a look at the link for the way to do this.

http://community.qlik.com/docs/DOC-3054

http://community.qlik.com/docs/DOC-2784

Regards,

Kaushik Solanki

Re: QlikView data into SQL

Mon, 22 Jul 2013 14:40:43 GMT

where do i find this? sorry i am a novice

Re: QlikView data into SQL

Mon, 22 Jul 2013 14:41:43 GMT

interesing, a lot of macros can cater for this though

Re: QlikView data into SQL

kaushiknsolanki — Mon, 22 Jul 2013 14:43:49 GMT

Hi,

It depends on which way is convenient for your scenario.

Regards,

Kaushik Solanki

Re: QlikView data into SQL

Mon, 22 Jul 2013 14:46:04 GMT

i just wanted to try a test as above and build on it...