question

LeonPeeters-8694 avatar image
2 Votes"
LeonPeeters-8694 asked RafiTrad-7776 answered

Azure Synapse Analytics Pipeline - Which IP range?

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?

(x-post from SO)


azure-synapse-analytics
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.

SaurabhSharma-msft avatar image
1 Vote"
SaurabhSharma-msft answered BrentLeslie-2638 edited

@LeonPeeters-8694 Welcome to Microsoft Q&A !!

You need to allow communication from the client to Azure SQL Database Gateway IP Addresses on port 1433 as mentioned in the document - Azure SQL Database and Azure Synapse Analytics connectivity architecture. Gateway IP addresses are listed over here and to connect to Azure Synapse you need to allow network traffic to All gateways for the region. Please let me know if this helps.


Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

· 3
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.

@LeonPeeters-8694 Please let me know if you are able to proceed further or if you have any other questions.


Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

0 Votes 0 ·

@LeonPeeters-8694 I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·

@SaurabhSharma-msft

This doesn't work, when going from Synapse Studio. I added all the gateway rules into the SQL Server. However when trying to access the connected DW I get this:

114874-image.png

Microsoft need to publish the IP Address ranges of Synapse Studio so that we can add them to the SQL Server firewall. Adding the Synapse Gateway IP Addresses isn't enough. I suspect this is because Synapse Studio opens under some hosted environment that doesn't go through the Synapse Gateways.



I can confirm that when I add that IP address to the SQL Server, I am able to access the objects. However, next time I open Synapse Studio, I will likely get a different IP address. Hence we need a listing of all the IP addresses Synapse Studio is set to use.

0 Votes 0 ·
image.png (249.0 KiB)
RafiTrad-7776 avatar image
0 Votes"
RafiTrad-7776 answered

I have the same problem, but I am dealing with an Azure DB for PostgreSQL. The IPs of the executors keep changing, so I cannot whitelist them. It's too permissive to allow all Azure services to access the DB. Any update on this issue please?

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.