'on-prem server and connect the node with the integration runtime in Azure

I wanted to pull the data from my on-prem server ( hive or oracle ) to Azure data factory. Whereas i am facing issues can you help me in this?

I am asking this on the basis of enterprise issue. I wanted my integration Runtime to be in Onprem server , currently we are installing it in our own laptops and if our laptop is shut down then obviously IR is stopped and data won't be loaded this can't be feasible in production.

Do anybody know that what is meant installing IR in my on prem server? that means in my hive server?

Your help will be really appreciated.



Solution 1:[1]

Your SHIR server does not have to be on the same server as your data source. But it should be close to it. Same region or same data center.

You need a server that is always powered and running. Refer to the documentation.

If you want high availability you should refer to this link.

If you want DR, you will need another SHIR on a DR server in your secondary region.

You can also install the SHIR onto a VM running on the cloud. But your Onprem network needs to be connect to the Cloud VNET using Express route or a VPN.

Laptops is fine for testing but as you said, not for production.

Your IT team should also take care of the patching and updates/maintenance of the new server whether it is on prem or on cloud.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Anupam Chand