You can define the database configuration in the Modeler/Studio pro and/or the on premise deployment mendix service console.
See mendix service console documentation
Microflows don't concern themselves with database settings. You can retrieve data with a retrieve action but the connection with the database is handled by Mendix.
For your specific question about viewing data in a grid: using a standard data grid is preferable, unless there is a specific reason to use a datasource microflow.
The learning paths in the Academy will help you with understanding the different methods for retrieving data.
Hi, Thanks for the response.
I changed “database settings” to point to oracle database but how can I use existing Oracle view to fetch data in mendix app. I understand that I need to create an entity in Mendix->domain model but I don't want mendix to create the entity table in Oracle. Can I alter mendix runtime to use a database view behind the scenes.
The requirement is to display data from Oracle view. The academy Tutorials, create a domain model and when app is deployed it creates table in the database but in my case I don't want to create the table. I want the app to fetch data from oracle view and display in the app.
Thanks.