For a customer I'm currently working on a project where we periodically want toload data from an SFTP server with the use of Data Factory. I can't, however, get it to work. Everytime I'm trying to make a connection using the AutoResolveIntegrationRuntime, I get the message:
SocketErrorCode: 'TimedOut'. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
I think the problem is on our side. I'm able to connect to the SFTP server using Filezilla and using a locally installed IR I was able to make to connection in Data Factory. Hence, it seems that the SFTP server is blocking Azure somehow.
We have whitelisted the IP adresses stated on: https://docs.microsoft.com/en-us/azure/data-factory/azure-integration-runtime-ip-addresses. Since our Data Factory is hosted in Western Europe, I assume that I have to whitelist the IP adresses for that part of the world:
Below a link to a screenshot of the configuration of the SFTP server (I can't upload it here somehow):
Can anybody tell what I'm doing wrong?
Thank you in advance for helping me out.