I have several nightly exports running which exports selected table data to excel files every night so that others can use this data to report on via PowerBI....
All works great .. the issue is that they now want certain data from the very bottom child level table exported and there are currently over 5m records & growing... to export it all every night would simply take too long and drive the server crazy..
Im looking to see what my best options are here ?
I could export all the data over a weekend and then set the subsequent nightly schedules so that it only exports changed or new records .. but how do I get the new/changed data to append to the original excel export (I need it all in 1 excel file)
Should I be using ODBC or whats the best way to do all this ?
BTW - We're using FMServer14 at present but should be moving to FMServer16 within a few months or so ...
All & any suggestions will be much appreciated folks