Ports to enable for a Managed Virtual Network Synapse Workspace

Question

Hi,

I need to implement a Synapse Analytics solution in order to get data from an Oracle database by using a Manager Virtual Network (and not a SH-IR).

The system & network engineer of my customer would know which ports and policy firewall to enable for a such scenario.

Any suggests to me, please? Thanks

Answer 1

If the Oracle database is located outside of Azure, and you are using Azure Synapse Analytics with a Managed Virtual Network, you would typically need to:

• Open port 443 for outbound traffic from Azure to Oracle, as this is the standard for secure HTTPS communication.
• Ensure that the Oracle database's firewall allows inbound connections from the Azure Synapse Managed VNet's IP range.
• If necessary, set up a Site-to-Site VPN or Azure ExpressRoute for a secure dedicated network connection between Azure and the on-premises location where the Oracle database is hosted.

The specific ports required for Oracle will depend on the configuration of the Oracle server, but often include port 1521 for Oracle SQL*Net traffic. Always confirm with the Oracle database's network configuration to ensure proper connectivity.

Answer 2

Hi pmscorca ,

In addition to the above details, you can go through the below resources :

Azure Synapse Analytics Managed Virtual Network

Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints

Managed Virtual Integration Runtime in Azure Data Factory

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou