Did you use the database connector from the marketplace? ( https://marketplace.mendix.com/link/component/2888 ). With this module you could retrieve the data from your external database. See the documentation here: https://docs.mendix.com/appstore/connectors/database-connector/
Regards,
Ronald