Of course, but not directly reading from JSON file, you have to map it to Mendix by;
1 – map the
2 – feed the charts with data from the objects of 1
With the database conector you retrieve a list of object from the database. You have to itterate over that list and create the objects/data you need for the charts.