Azure Synapse Analytics Pipeline - Which IP range?

Question

I'm trying to set up an ELT pipeline to pull source data from a mySQL database into Synapse using the "Copy Data tool". The source mySQL database is operated by a 3rd party that requires me to provide an address (range) for their IP-whitelist.

I've searched around but cannot find the IP address range for "Azure Synapse Analytics" -- but must admit that I'm new to Azure Synapse Analytics and very confused by the nomenclature. E.g., I found this Azure IP Range list, which contains ranges for various services but none named "Synapse Analytics".

Where do I find the proper IP range? Or do I need to set up my Synapse Analytics with a fixed IP address, and if so, where do I find more information on that?

Is it feasible for you to install a self-hosted integration runtime either on-prem or in an Azure VM? Then set the mySQL linked service to use that IR. That’s the most straightforward way to get a consistent IP address for this pipeline. — GregGalloway

SamaraSoucy SamaraSoucy · Accepted Answer · 2021-02-02T00:53:42

You can find the current list of IP addresses for Azure SQL/Synapse Analytics here: https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture#gateway-ip-addresses

Similarly, Synapse pipelines share many attributes with Data Factory pipelines, and the IP addresses should match. You can find those in the document you linked.

Keep in mind that this list doesn't change often, but it can change. Generally there will be an announcement ahead of time so you can update your firewalls.

Azure Synapse Analytics Pipeline - Which IP range?

1 Answers