What is the best way to export data from mySQL database in to excel.

Question

Hello, 
 
 Currently, I have a datasubset in an interface that is used with the function plug-in "getdatasubsetdownloadlinkfromprocess" 
 As it works now, the users selects from a dropdown, the data he or she wants to see, the data is populated in a grid and there is a link to click "Click here to export this data to Excel"

This works fine with a small amount of data (up to 1000 rows) but when it gets to 3,000 rows of data, it fails. 
 
 I have read on some posts here that "getdatasubsetdownloadlinkfromprocess" doesnt work well with large sets of data 
 
 My question is, what is the best way to export data from a mySQL database to excel. I see a SQL to Excel smart service but I am having trouble setting that up. 
 
 Any help or advice would be greatly appreciated. 
 
 Thanks!

saurabhp0002 · Answer

Develop a WebAPI to export SCV file. this is best way and have not much limitation like: have to have from one CDT etc, row count and best part is that it is not stored in KC, it is runtime export and available for user to download.