Extract of App Data

Hi,  For work I often get asked to created reports for different things, which in turn requires a build that needs testing before putting LIVE.  This long process feels unneccessary and there must be a better way...so...is there a way I can download all tables of data for an app so that I can view it in say Excel for example?  I’ve been on the ‘Backups’ section on the Mendix portal for a given app, but from what I can see it only allows me to download a ‘.BACKUP’ file that can only be downloaded and uploaded via the Cloud to update the app data itself online?   
1 answers

OData might be a good solution for you here. Excel is even capable of reading OData services, as are BI tools like Tableau.