I would like to connect some of the Power Apps I'm working on with Exasol data. However, I saw that there is no Exasol connector in Power Apps. Unfortunately, there is also no generic ODBC connector in Power Apps that we could theoretically use in combination with the Office 365 Data Gateway we use to refresh our Power BI datasets.
Does anyone of you know of a workaround to access Exasol data from within Microsoft Power Apps?
I'd really love to have an Exasol connector there, if possible 🙂
@Kamal-Kishore Thanks for sharing your thoughts regarding possible Workarounds. Really valuable information.
Regarding the development of a connector: As all Power Apps Connectors are API based we would first need to develop e.g. a REST-API for executing queries.
Please vote for this IDEA:
One way I can think of is creating a table in MS Sql Server which sources from an External table via JDBC. MS Power Apps have connectors for these are data sources.
Common data service is another connector that lets you execute power query sourcing from OData service. You'll need to create an OData wrapper service on top of the tables/views that you want to source in Power Apps.