Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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