Database Views creation in Mendix

Hi All, I have a requirement to have permanent view to get created in Mendix App DB. So that it can be used for our reporting purpose outside of Mendix app. I know we normally don’t do any changes to DB manually. Is there an option with Mendix to create DB Views?   Thanks in advance.
1 answers

Create an OData connector and use that connector to get real time data out of your Mendix app. Do make sure that the other app only retrieves recent data or use pagination. If wrongly configured you can lay a heavy burden on your database when another app tries to download all the data every 5 minutes for instance instead of retrieving only the latest data.