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

Frank Lloyd Teh 1 Reputation point
2022-03-13T08:09:42.773+00:00

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.

182576-image.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,500 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Wang, Sandy 21 Reputation points
    2023-04-13T07:02:11.93+00:00

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

    User's image

    0 comments No comments