PostgreSQL security

[sguenther]

Hey,

in order to ensure data security all applications outside of our local network are blockd from accessing our PostgreSQL database. Therefore the data refresh of the dashboards does not work for the PowerBi servers, but only if we do it manually via our PC's or the personal gateway.

In order to enable refresh we need to know some information about the servers so we can add some firewall exceptions. Where can I get these from?

Or is the enterprise data gateway service for SQL Server capable of working with PostgreSQL?

Thanks,

Seb