Build & Display Charts from Mysql Database

Hello, I’m new to Mendix. I’m trying to build charts & data grid based on data directly fetched from Mysql database. The data displayed in the app is pre calculated & stored inside Mysql tables & there won’t be much of data generated from the app.  What would be the efficient way to work on the data directly querying from Mysql to build charts. I’m looking forward to your suggestions on how to bring data into my charts directly from the database. So far, I have created the entities in domain model matching the columns fetched from mysql table. Also Built microflows to query mysql database & used it as a datasource to populate data in the data grid.   Thanks for the help in advance.  
1 answers

Hello Sanjeev,

Use this module to fetch the data: