SSH Tunnel to Remote Database Host (MySQL on Debian)

(0) Share

Report

Posted on by Silvan

Can 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 (1)

Answers (0)

Ben Thompson 1,400 on at

Like (1)

Report

Re: SSH Tunnel to Remote Database Host (MySQL on Debian)

I don't think PowerApps has a way of connecting to that MySQL server as you do need a gateway from Azure to your on-premise system that supports ssh.

So sadly I think you will need to find another solution

For reference https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list shows the default connections (and they all are in the cloud) and https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-management shows the list of gateways and neither mysql or ssh are listed.