Azure Data Factory ip out of range of Public Azure ips list

bird 0 Reputation points
2023-12-29T11:04:03.44+00:00

Hi

When connecting from azure data factory to an external sql db with a firewall, we've created a task that whitelists the public azure ip ranges found here: https://www.microsoft.com/en-us/download/details.aspx?id=56519

However, for about a week now, our azure data factory attempts to connect to the external sql db with an ip out of range from the ips listed. For example: If the listed range was 20.20.20.0/30, azure attempts to connect from 20.20.20.31. This results in a connection failure, because we're hitting the firewall.

I'm unsure how to proceed. Whitelisting all ips is not an option, sadly.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2024-01-10T00:01:18.6733333+00:00

    @bird Welcome to Microsoft Q&A forum and thanks for reaching out here.

    As per the Azure IP Range documentation, these IP ranges are updated weekly to the list. Which may be the reason you are noticing this behavior.

    User's image

    To overcome this issue, I would recommend going with Azure Private link for secured connection. For more information about secure connection, please refer to this documentation: Azure Private link for ADF - Secure communication between customer networks and Data Factory

    Diagram that shows Private Link for Data Factory architecture.

    Hope this info helps.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.