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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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

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