We are happy to announce a new PostgreSQL connector for the virtual network data gateway! You can now connect to all your PostgreSQL workloads in the cloud using basic authentication. Just select PostgreSQL in the connection type dropdown menu when creating a new connection to your virtual network data gateway from the manage gateways page on the PBI service.
Why use PostgreSQL through the vnet data gateway?
Use this option instead of the on-premises data gateway to avoid creating a DSN, creating a connection string, installing a driver, setting up data source specific configurations or downloading anything.
How do I use this?
To connect to a PostgreSQL data source:
- Select the gear icon in the top menu bar and navigate to the manage gateways page.
- Select Connections and then +New.
- Select the vnet data gateway you want to connect with, give the connection a connection name, and then select PostgreSQL from the connection type dropdown menu.
Feedback and comments
Please try it out and as always let us know what you think in the comments below!