Unable to integrate Synapse (Managed Vnet) to an Azure Postres Flexible Server behind a Private Virtual Network

Question

I am unable to Integrate Synapse (with Managed vnet) to a Postres Flexible Server behind a Private Virtual Network.

While I am successfully able to create a linked service (the databases within Postgres Flexible Private Vnet are even in a dropdown)....

I am unable to do a Copy Tool Integration. When the integration connection is tested, it says "No such host is known".

I have a suspicion this is either because the Managed Vnet of Synapse needs to be peered with the Postgres Private Vnet, as well as linking the private DNS of the Postgres Flexible server to the Managed Vnet of Synapse.

Answer 1

You need to create Self hosted Integration runtime, according to what MS suggested on the portal.