We are able to write data to azure sql database from an on-premise oracle database by using self hosted integration runtime and using azure data factory.
The self hosted integration runtime software is installed and running on a virtual machine within on-premise network which already has some communication to azure to read power bi datasets (i.e. port 443).
We therefore have dataflow which reads from on-premise oracle to azure blob storage (i.e. uses port 443) then read the contents of azure blob storage into an azure sql database (i.e. uses port 1433 within azure network).
What we would like to do is write directly from on-premise oracle to azure sql database using azure data factory without having the intermediate staging step.
If we allow our machine running the self hosted integration runtime to access azure on ports 1433,1434,14000-14999)
for uk south region microsoft public ip addresses would that be enough.
Is there anything else that would be required to allow this to happen (e.g. other i.p. addresses or ports)
uk south microsoft public ip addresses