How can I access production data in real-time?

0
In my Mendix production application, I have an entity called Request I need to access the data in this entity in real time, directly from production. Currently, I can only analyze data by downloading a database backup and opening it in PostgreSQL, but this doesn't give me up-to-date/live data which makes accurate analysis difficult.   Additionally, the Request entity is not available in Mendix Data Hub (Catalog), so I cannot consume it from another app at the moment.   I'm looking for a way to access this data, ideally by using built-in Mendix capabilities. I want to access live data because I will use it to perform some data queries (e.g. analysis of duplicate requests). My goal is to analyze live data in read-only mode — no create, update, or delete actions are required.    Any help or guidance would be greatly appreciated.
asked
2 answers
1

My recommendation would be to publish the request entity in an OData service.  This approach would make the data available in the Mendix catalog and easily accessible to Power BI or Excel for real time analysis.  You can learn more about an OData service here: OData Query Options | Mendix Documentation 

 

Another approach would be to have a data grid in the application showing all requests with filters and an export to excel.

answered
2

Hello Miray,

OQL module is best way to achieve this where you can see/downlaod data directly.

image.png

answered