Extract of App Data

0
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?   
asked
1 answers
0

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

https://docs.mendix.com/refguide/published-odata-services

https://docs.mendix.com/howto/integration/exposing-data-to-bi-tools-using-odata

answered