How do i get public static Ip for Data Factory

Question

How do i get public static Ip for Data Factory

Himanshu Devrani 11

I am having a data factory and I want to get its static IP so that I can whitelist that IP to connect with my datastore. I have gone through the list of IP ranges provided by Microsoft but could not find a permanent solution because these IPs will get changes every week. Another question what is the role of Azure auto resolve IR and self hosted IR . Can't I use Azure auto resolve IR and use static IP ranges to connect with cloud data stores(Azure sql db).

Pankaj Palta 10 Reputation points

2024-01-26T23:44:30.0866667+00:00

Hi @Nandan hegde @Himanshu Devrani Was this issue resolved? I have a situation where I want to get to a third party SFTP so I can give it to third party to whitelist. I'm trying to use the SFTP connector in ADF to connect to third part SFTP server. How can I generate a static IP that I can get whitelitsed? Is there anyother option except hosting a VM in Azure? Thanks in Advance.

1 answer

Your answer

Pankaj Palta 10 Reputation points

2024-01-26T23:44:30.0866667+00:00

Hi @Nandan hegde @Himanshu Devrani Was this issue resolved? I have a situation where I want to get to a third party SFTP so I can give it to third party to whitelist. I'm trying to use the SFTP connector in ADF to connect to third part SFTP server. How can I generate a static IP that I can get whitelitsed? Is there anyother option except hosting a VM in Azure? Thanks in Advance.

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Hey,
There is a similar mail thread:
https://learn.microsoft.com/en-us/answers/questions/89413/public-ip-address-adf.html

The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the data integration capabilities across different network environments.

Self hosed IR is wherein you are leveraging your own server/system to function as compute node
.

For additional details:https://learn.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

To connect to Azure sources via ADF like Azure SQL database, you can use Auto IR and then there is no need to whitelist any IPs as long as we enable the property in Azure SQL server :

If that property is disabled, you would need to whitelist the IPs of the region of the data factory in firewall

Himanshu Devrani 11 Reputation points

2021-09-07T11:23:50.567+00:00

Thanks for the reply @Nandan Hegde .
But my question is something different . I am asking can i use azure auto resolved integration runtime an d can use static Ip ranges to connect with clod data stores like azure sql db.

Do i need to create self hosted integration runtime to use public Ip of Data Factory ??
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2021-09-07T11:46:05.62+00:00

Hey, I have updated my answer above.
We use Self hosted IRs for accessing sources which are within a Vnet like On Prem sources or IaaS systems etc, For accessing cloud sources directly , we can leverage Auto IRs
Himanshu Devrani 11 Reputation points

2021-09-07T11:51:34.54+00:00

I dont want to enable that option (allow all azure services). I just want to whitelist IP for azure data factory but the IPs will get change once in a week for a region.

I have downloaded the file and extracted the list of Ips for a particular region but the thing is they will change after a week.

Is there any exist other way to do this ??
Himanshu Devrani 11 Reputation points

2021-09-07T11:55:55.697+00:00

For now just consider I am having a SQL Server which is in On- Premise so I will be using self hosted IR to connect with that and to connect with Sql Server I will be whitelisting the ranges of IPs of Data Factory region Central India .

"20.43.121.48/28",
"20.192.42.0/24",
"20.192.43.0/26",
"20.192.102.80/28",
"40.80.51.160/28",
"52.140.104.128/25",
"52.140.105.0/26",
"52.140.108.208/29"

This IP list I have to whilelist in Firewall. As this is a very large IP list so my question is how do I get a static IP form all of these IP list for Azure Data Factory.
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2021-09-07T12:00:14.08+00:00

Hey,
I am not sure the IPs for a region get updated within a week. Based on my knowledge they might change yearly and we do get notifications from MSFT w.r.t the changes.
Because I too have whitelisted NE region IPs in firewall and that has not impacted since last 6-7 months

In case if you want to have a static IP, then you would need to create a VM which would have its own public IP and open the ports for the database to be accessible from the VM and install the Self hosted IR for the ADF.
In this scenario, you would just need to whitelist the public IP of the VM but the data would flow from Azure SQL DB to ADF via the VM thereby adding latency and having to manage a VM and its cost (along with IR upgrades)
So would suggest to whitelist the subnet range of ADF region in your Azure firewall
@PRADEEPCHEEKATLA : Can you correct if I am wrong w.r.t the IP change frequency ?
Himanshu Devrani 11 Reputation points

2021-09-08T05:50:12.993+00:00

Thanks for your answer.

II have few more questions regarding the same.

I have a SFTP Server and the client is asking for data factory Ip to get whitelist into that server. The limition is that they can allow only max 4 IPs. So how to achieve this. Do i need to use Self hosted or Azure auto resolve IR to get the static IP
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2021-09-08T06:08:46.597+00:00

Hey,
In case if there is a restriction of only 4 IPs , then the best way is to create a VM that would have only 1 static Public IP and install the ADF SHIR in that VM.

Provide that VMs public IP to SFTP vendor to whitelist it.

Azure auto resolve for an ADF region would have more IPs than 4. So Self hosted in the only scenario here

Share via

How do i get public static Ip for Data Factory

1 answer

Your answer