question

JohnnyHumphrey-3892 avatar image
1 Vote"
JohnnyHumphrey-3892 asked 60452869 answered

Data Factory name for Azure Synapse Analytics

We have an Azure Synapse workspace, and because some/most of our sources are behind an Azure virtual network, we are creating a self-hosted integration runtime. In the documentation (https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime), in the section on firewalls, one of the domains to enable is **{datafactory}.{region}.datafactory.azure.net. The description for that entry says to look in the key for the self-hosted integration runtime. At least in Synapse, that key isn't a FQDN. I've tried poking around in the properties of various things related to pipeline or the Synapse workspace, and I can't find any references to datafactory.azure.net, or data factory at all.

  • Is the data factory name the Synapse workspace name? That is the closest thing to a data factory name in the key?

  • Or do I use a different domain entirely, maybe something based on azuresynapse.net?






azure-synapse-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I will check to be sure, but {synapsename}.{region}.datafactory.azure.net is probably going to be correct.

0 Votes 0 ·

Is there any update on this? We also need to insert it in our central firewall. Thanks

0 Votes 0 ·
JohnnyHumphrey-3892 avatar image
0 Votes"
JohnnyHumphrey-3892 answered ThomasEvans-6419 published

I think there is a better answer, at least that worked for me. Since we have a Network Security Group associated with the Subnet that the Self-Hosted IR VM lives in, I used the Service Tags DataFactory and DataFactoryManagement (there isn't anything for Synapse), and I was able to connect with the registration service that way, and the IR is showing as Running in Synapse Studio.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm glad to hear it is working. I will update you once I hear back from the product team on what the preferred FQDN is for Synapse. I will also make sure we update the documentation to reflect what domain to use for Synapse.

1 Vote 1 ·

What was the outcome of this? I am facing the same issue.

0 Votes 0 ·
60452869 avatar image
0 Votes"
60452869 answered ThanaponArchint-4886 commented

Hi,

I am trying to execute Azure Synapse pipeline using REST API by following the documentation available in Microsoft site. When I try to test it, it is asking for Data Factory name.

What is name I should use from Azure Synapse for 'factoryName'?

https://docs.microsoft.com/en-us/rest/api/datafactory/pipelines/create-run#code-try-0

219509-image.png



image.png (76.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.