Azure Data Factory to On Premise SQL/Oracle DB RRS feed

  • Question

  • HI Team,

    We have on premise DB and Web servers which has firewall rules implemented. Now when i am trying to connect to on premise DB from Data Factory, due to firewall restriction it is not able to connect. Same with the Web server which contains web APIs. Is there a option to open firewall between Data Factory and On Premise server as I don't see any client IP for Data Factory. Also I have seen On-Premise Gateway Service option to install in my on premise servers but the problem is due to security reason in our servers we don't have internet connection enabled.

    Could you please help me out to resolve this issue?

    Wednesday, July 25, 2018 4:08 PM

All replies

  • You could install a self hosted IR to access your on premise DB and whitelist the IP of the machine hosting the self hosted IR.
    Wednesday, July 25, 2018 10:14 PM