Write back tablle to MY SQL

[ratnadeep]

Hi , I want to write back in QSE SaaS all the fields in my QVD into mysql. can someone help with the process?

[Nicolae_Alecu]

Hello,

You can store the QVD in .CSV format , and that can be imported in SQL.

Best Regards 😄 

[ratnadeep]

Thanks @Nicolae_Alecu 

Actually i was looking for a way to automatically writeback. I found a way to achieve the result through Qlik automation using MySQL connector 'Insert Bulk' block . 

However the limit to insert bulk is 100,000 cells. 

I now need help on how can i insert bulk more than 100,000 cells

[ratnadeep]

Guys i found a way to insert bulk more than 100,000 cells. I used incremental load to write back limited amount of data till today. Now the incremental data in 99% cases will be less than 100k cells. Now automation run is scheduled. the incremental data is extracted, transformed and loaded back to destination table in MYSQL