I have large table in Qlik data model. I want insert it into MySQL DB every day. I know about possibility to create in load script variables for each column, and insert all data by one string per time thru cycle.
I think this far no optimal way for big amount of records.
Also, we made extension button, that can send information from hypercube to MySQL by pressing on it. But i want that insertion works fully automated.
So, how i can do this trick - make scheduled insertions from hypercube to MySQL?