Express route

Sourav 60 Reputation points
2024-04-13T05:05:24.7733333+00:00

Hi,

We have newly setup express route with on-prem. I have some queries.

  1. How do we test that we have express route connectivity between Azure to On-prem destination servers ?
  2. We want to connect on-prem oracle db over express route and TLS using ADF linked service with Self Hosted Integration Runtime. What ports we need to open for this ?
  3. If we want to use on-prem machine location to send files over ADF SFTP linked service. What ports do we need to open ? Thanks in advance.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,603 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. sorjun 240 Reputation points
    2024-04-13T05:38:29.2+00:00

    Hi Sourav,

    1. For test ExpressRoute, you can follow this link: https://learn.microsoft.com/en-us/azure/expressroute/expressroute-troubleshooting-expressroute-overview, you may need some support from the telcom vendor who setup ExpressRoute for you, usually they should do. And when link is up and you should be able to ping from your on-premise network to Azure vnet, like via normal WAN link.
    2. Regarding ADF connect to Oracle DB, normally default port is TCP/1521, and with TLS is TCP/2484, better confirm with Oracle Admin for the configuration on server. And for connect with ADF you can find link here: https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory.
  2. Smaran Thoomu 9,760 Reputation points Microsoft Vendor
    2024-04-15T08:58:37.8466667+00:00

    Hi @Sourav

    Thank you for your questions regarding ExpressRoute connectivity and port requirements for connecting to on-premises resources. Here are the answers to your queries:

    1. To test the connectivity between Azure and on-premises destination servers, you can use the Azure Network Watcher service. It provides a variety of tools for monitoring and diagnosing network connectivity issues, including the ability to perform connectivity tests between Azure resources and on-premises resources. You can use the "Connection troubleshoot" feature in Network Watcher to test connectivity between your Azure resources and on-premises resources over ExpressRoute. For more information you can refer this link.
    2. To connect to an on-premises Oracle database over ExpressRoute using ADF linked service with Self Hosted Integration Runtime, you will need to open the following ports: TCP port 1521 for Oracle database traffic TCP port 443 for TLS traffic
    3. If you use SHIR and ADF linked service created using SFTP connector to send files from on-premises machine location, you need to open port 22 for SFTP traffic. Additionally, if you have enabled remote access from intranet on the machine with SHIR, PowerShell uses port 8060 for secure communication. You can change this port from the Integration Runtime Configuration Manager on the Settings tab if necessary. Please note that these are the default port requirements for these services, and your specific port requirements may vary depending on your network configuration and security policies.

    I hope this clears up any confusion. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.