Port Usage

The following TCP/IP ports are used by the SQDR Plus solution; refer to this information when configuring firewalls.

Management

Access to the jetty ports specified during installation of SQDR Plus (default 8080 and 8443 (SSL)) is needed when using a browser to connect to the SQDR Control Center on the SQDR Plus platform.  See Connecting to SQDR Control Center.

SQDR Plus to Source System (Db2 for i)

Host server ports used by IBM i Access and Java Toolbox:

• as-svrmap 449

• as-central 8470

• as-database 8471

• as-file 8473

• as-rmtcmd 8475

• as-signon 8476

• 9470, 9471, 9473, 9475, 9476 for SSL

SQDR to Source System (Db2 for i)

DRDA (default 446, SSL: 448)
or IBM i Access host server ports (see previous section)

SQDR Plus to Source System (Db2 for Linux, UNIX and Windows)
SQDR to Source System (Db2 for Linux, UNIX and Windows)

DRDA (default 50000)

SQDR Plus to Source System (Microsoft SQL Server)
SQDR to Source System (Microsoft SQL Server)

Listening port for the SQL Server instance. The default instance uses port 1433; named instances use dynamic ports. If dynamic ports are being used, then the SQL Server browser is listening on UDP port 1434.

SQDR Plus to Source System (Oracle)
SQDR to Source System (Oracle)

typically 1521

SQDR Plus to Source System (Informix)
SQDR to Source System (Informix)

typically 9088

SQDR Plus to Source System (MySQL)
SQDR to Source System (MySQL)

typically 3036

SQDR to SQDR Plus (Db2 for LUW control/staging database)

DRDA (default 50000)

SQDR Plus to local Apache Derby control database

Derby (port 1527)

SQDR Plus to SQDR

UDP port 2728 - used to send notification that change data is available for subscriptions that have been specified to receive notifications. (optional)

SQDR to Destination Database

varies