Setting up an on-premise gateway in AWS

[aosaigh]

I want to connect a Postgres database that is running on RDS within AWS. This database is behind the firewall and powering a web app and we dont' want to expose the database publicly. We also can't really use the web app API as the data endpoint.

I understand that PowerBI doesn't support SSH tunnels, but we can use a on-premise gateway. I believe this would have to be installed within our AWS virtual network? Are there any guides for this? Would it be a case of setting up a new AWS server running Windows/Windows server and installing the on-premise gatway there? I imagine we would then expose that Windows machine and connect directly to that from PowerBI?

[Greg_Deckler]

Yes, with AWS IaaS, it's essentially the same thing you would do on-premises, just doing that same thing in AWS instead. Might be even easier in Azure... 🙂

[avk]

I'm having the same scenario as well, we are using SQL Server RDS instead and it's not publicly accessible. So, ist he best solution to have a enterpise gateway installed on a server (probably EC2 or VM) and then have power bi point to it to read from a database on that machine.

When enterpise gateway is installed on a server (EC2 or VM),  can the gateway be configured to connect to a RDS instance or will the connection be possible only to a database on that machine?

[aosaigh]

We want to connect data from a Postgres database that is powering a web application on AWS. The database is hidden behind the firewall and we want to keep it that way for security reasons.

I understand that PowerBI doesn't support SSH tunnelling so I believe the next best solution is to use an on-premises gateway. From what I have read, the on-premise gateway has to run on a Windows machine (doesn't work on Linux), so I'm wondering what the best way to set this up on AWS is? Are there any guides for this?