Share
Report
1Can we establish an SSH tunnel from Power Apps to access a remotely hosted MySQL database.
Our data storage setup is as follows and cannot be changed.
1. Data is stored in a MySQL database on a remote server (MariaDB on Debian). This DB can only be accessed from localhost due to security reasons.
2. To work with the data we establish an SSH tunnel to the server with port forwarding.
3. E.g. locally we can now use/manipulate the data in Access via ODBC.
We would like to use Power Apps to build business processes with this data, but cannot access it. The current gateway solution does not work for us, since we cannot provide interruption free access to an on premise machine running a gateway. The data needs to be accessible in real time, meaning copy scripts are not a solution. Furthermore we cannot change the remote database setup to be accessible without the tunnel.
Thanks for any pointers.
All responses (
Answers (
