Oracle server using AZURE DATA FACTORY through Self Host IR, But i'm not able to connect to Oracle with Azure VM's,

Question

Hi Team,

I have created 2 VM(Virtual Machine) in azure and Installed Self host IR's in VM's to access on-premise Oracle server using AZURE DATA FACTORY through Self Host IR, But i'm not able to connect to Oracle with Azure VM's,

Please let me know step by step process to make connection between on-prem Oracle and azure VM's including network configuration to access Oracle by using ADF through Self Host IR installed in VM's

Thanks,

Answer 1

Hello @Yaganti, Venkateswarlu (Contractor),

Welcome to the MS Q&A platform.

Please follow the below steps:

You will need to create a virtual network in Azure and configure it to allow communication between your on-premises network and the Azure VMs. You can create a virtual network gateway and configure a VPN connection between the virtual network and your on-premises network.

Once the virtual network is set up, you'll need to configure the Azure VMs to use the virtual network. You can assign them to the virtual network and configure their network interfaces to use the virtual network's subnet.

You will need to configure the Oracle server to allow connections from the Azure VMs. You can create a firewall rule on the Oracle server to allow incoming connections from the Azure VMs' IP addresses.

Finally, you will need to configure the Self-hosted Integration Runtime in Azure Data Factory to use the virtual network and connect to the Oracle server. You can do this by specifying the virtual network's subnet and the Oracle server's IP address and port in the Self-hosted Integration Runtime's configuration.

I hope this helps. Please let us know if you have any further questions.