question

SaransundarN-4048 avatar image
0 Votes"
SaransundarN-4048 asked SaransundarN-4048 commented

Private endpoint is enabled for Azure data factory. How does it connect with Azure sql public endpoint?

Private endpoint is enabled for Azure data factory. How does it connect with Azure sql public endpoint? Does Azure IR supports in this scenario? how it works? Any other solution?

MS docs says that "Disabling public network access is applicable only to the self-hosted integration runtime, not to Azure Integration Runtime and SQL Server Integration Services (SSIS) Integration Runtime."

azure-data-factory
· 6
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.

Hello @SaransundarN-4048 and welcome to Microsoft Q&A.

I find your question implies a confusing goal.

Private Endpoint is when you want to keep everything inside Vnets. Public endpoint is when you want to expose to outside Vnet. These two are opposites.

Combining opposites doesn't make much sense to me. Could you please clarify your end goal?

0 Votes 0 ·


Thanks Martin for your response. Let me explain the scenario. Source is present in onpremise private network and requirement is data channel to be secure. Destination is Azure Sql. ADF will connect to onprem SHIR using S2S VPN through private endpoint. The question I had is currently Azure SQL is in public endpoint. By using what mechanism, ADF will connect with Azure SQL?

0 Votes 0 ·

Ahh you had me confusing the public nature of Azure SQL (not-managed) with the Azure Managed SQL Public Endpoint feature.

If I understand correctly, the choice is up to you. You can engage Private Link for SQL if it is in a Vnet.


0 Votes 0 ·
Show more comments

@saransundarn-4048 Following up as if you have any other questions.

0 Votes 0 ·

I am good Saurabh at this point. Thanks. My understanding is ADF will use SHIR to connect with onpremise source through private endpoint. At the same time it uses azure IR to connect with Azure Sql as target since it is in public endpoint. Hope i am correct.

1 Vote 1 ·

0 Answers