topic Re: Write back tablle to MY SQL in App Development

Write back tablle to MY SQL

ratnadeep — Wed, 20 Mar 2024 08:51:33 GMT

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

Re: Write back tablle to MY SQL

Nicolae_Alecu — Wed, 20 Mar 2024 10:00:33 GMT

Hello,

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

Best Regards 😄

Re: Write back tablle to MY SQL

ratnadeep — Wed, 20 Mar 2024 13:34:21 GMT

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

Re: Write back tablle to MY SQL

ratnadeep — Wed, 27 Mar 2024 12:47:57 GMT

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