How can we identify static IP address for azure Synapse Integration Runtime pipeline for allowing connecting in SFTP Linked server?

Question

Dear Team, We are trying to configure a linked server connection from azure synapse to SFTP server. We would like to restrict the IP address of Azure Synapse Integration Runtime in SFTP server . We are unable to get the IP Address of Synapse. Could you please help me Regards, Harish

Answer 1

Hello Harish Dharmavaram,

Welcome to the Microsoft Q&A forum.

For SHIR: You can get the IP address of the Azure Synapse SHIR Integration Runtime by using the REST API. Please send a POST request to the following URL

or directly from the Azure synapse studio. From synapse studio, click on Edit integration run time and, you can see the IP address.

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/integrationRuntimes/{integrationRuntimeName}/nodes/{nodeName}/ipAddress?api-version=2021-06-01-preview

This is documented on the below URL. https://learn.microsoft.com/en-us/rest/api/synapse/resourcemanager/integration-runtime-node-ip-address/get?view=rest-synapse-resourcemanager-2021-06-01-preview&tabs=HTTP

For Azure Integration Runtime

If you are using the Azure Integration run time, then please follow the below document to get an IP addresses for specific regions.

https://learn.microsoft.com/en-us/azure/virtual-network/service-tags-overview#discover-service-tags-by-using-downloadable-json-files

https://learn.microsoft.com/en-us/azure/data-factory/azure-integration-runtime-ip-addresses#azure-integration-runtime-ip-addresses-specific-regions I hope this answers your question.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.