Data based mechanistic, DBM, environmental models able to accurately reproduce input-output behavior of large natural systems are still required in practical water quantity and quality real-time control applications, due to their low computational cost and high efficiency. DBM models are also efficient and sufficient accurate tools to be used as the basis of complex decision support systems for the integrated management of water resources at the catchment scale. In this work an efficient aggregated solute transport and water quality model of a large 800 kilometer stretch of the Magdalena tropical River was implemented, calibrated and compared with a distributed model.