Externel SQL als Data Source

Hi community, I'm confused again. I have an external SQL that I want to reference as my Data source. So I built a Mircoflow and returned a List. But I also need a search bar. So I added a Data Grid to my page. But the Data Grid can only join the Search bar in the case of Database. So I added a Data View outside the Data Grid, but the Data View requires the return value to be Object. So should I add a create Object on top of my Mircoflow that references SQL?
1 answers

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/