I have to transfer data from an on-premise sql server to Azure Sql using Azure Data Factory however sql server owner needs to whitelist the public IP's to provide access to their service. I know that there is a range of IP's that are used by ADF in specific regions but is there a way to set one static IP which not gonna change and which I will be able to provide to my client ?
As rightly mentioned by Nick and wBob, you can get IP addresses that your Azure Integration Runtime uses but that is same for all in the same region and not unique Static IP address for only your integration runtime as Azure Integration Runtime is serverless. You have to set up a self-hosted integration runtime to get a Static IP for Data Factory connectors.
Also checkout simialr Copy data securely from Azure Blob storage to a SQL database by using private endpoints