Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Imports qvd into SQL Server

Hello;

I need to import a qvd file into a SQL Server database.

It's possible?

I know there are programs that do it, but I ask for the way to do it without an external program.

Thanks,

Fernando

Labels (1)
10 Replies
roledens
Contributor
Contributor

Hi,

I tried this solution to insert data to MySQL database but I am getting below error. data is inserting to MySQL database but each insertion it throws this error.

 

My code as follows

 

LET V_ROWS = NoOfRows('table');

FOR V_ROW = 0 TO V_ROWS - 1

LET V_FIELD4 = Peek('Impact',V_ROW,'table');

LET V_FIELD5 = Peek('Urgency',V_ROW,'table');

LET V_FIELD6 = Peek('Priority',V_ROW,'table');

SQL INSERT INTO kedb.incidents(Impact,Urgency,Priority) VALUES('$(V_FIELD4)','$(V_FIELD5)','$(V_FIELD6)');

NEXT;

 

incident.PNG