Network Architecture

The diagram Delphix Virtualizing and Masking SQL Server Network Architecture below depicts the overall network architecture for Delphix virtualizing and masking SQL Server. In the diagram, each of the arrows represents the direction of a network connection between two nodes. Next to each arrow is a label indicating the network protocol (TCP) and the port number indicating the network service. Also, indicated in red are the recommended network latencies between the major components of the architecture.

You can optionally configure a separate Connector Environment, specifically used to discover databases on the source during Environment creation. You can also use your Staging Target Host to be used as the Connector Environment, as seen in the image below.

Delphix Virtualizing and Masking SQL Server Network Architecture


Based on the table below, the Windows Network Administrator needs to complete a series of tasks. For each port listed, determine whether it must be opened in your firewall between your Delphix Engine and source or target systems. Work with your Delphix Administrator to understand what requirements are there, and ensure that they have been met before proceeding.


Network Service

Required for virtualization?

Required for masking?

Description and usage
22SSHYesYesUsed for accessing command-line interface (CLI) and internal Delphix OS accounts
80HTTPYesNoUsed for GUI console access on Delphix Engine by default, disabled when HTTPS in use
443HTTPSYesNoUsed for GUI console access on Delphix Engine, disabled when HTTP in use
445SMBYesNoUsed for attaching shared folders on Windows. To take a copy-only backup or use Delphix Managed backups, this port is required to allow the source environment access to the staging environment.
1433JDBCYesYesUsed for accessing SQL Server databases for queries on data-dictionary. This port is the default, but you can use other ports instead.
3260iSCSIYesNoUsed for network-attached storage (NAS) on Windows database servers
8415DSPYesNoUsed for SQL Server hooks, when enabled. This port needs to be open between the Delphix Engine and the VDB target.

Delphix Windows Connector

YesNoUsed for connecting to the Delphix Connector service installed on Windows target database servers.
50001iPERFNoNoUsed for network throughput testing with the open-source iPerf package through the Delphix CLI, this is purely optional (but useful) functionality

AppData Port Requirements

The use of AppData requires the following ports/protocols.
Two important notes about these specifications:

  1. The next release of the Delphix Engine will significantly augment the port/protocol utilization of AppData. The upcoming-only requirements have been marked with a *.
  2. AppData V2P uses RSYNC to export to the target. RSYNC between the target and Delphix Engine is not required for general virtualization usage. The V2P-only requirements have been marked with a ^.

From Source to Delphix Engine

From Delphix Engine to Source

From Target to Delphix Engine

From Delphix Engine to Target

RSYNC (TCP Port 873)RSYNC (TCP Port 873)DSP (Default TCP Port 8415)DSP (Default TCP Port 8415)
DSP (Default TCP Port 8415)SSH (TCP Port 22)NFSSSH (TCP Port 22)
*NFSDSP (Default TCP Port 8415)^RSYNC (TCP Port 873)^RSYNC (TCP Port 873)

Related Topics