Wiki

A specific port (logical connection) is used when Versago connects to a database. The port used will vary depending on the database and your local environment. In addition to defining the port correctly in the Versago database configuration, you also need to be sure the port is not blocked by your network firewall.

The standard communication port for Microsoft SQL Server is 1433. Unless your environment is specifically configured to use a different port, nothing special is required to define a Versago connection for this type of database. Connections to other ports are not supported at this time.

The communication port SAP HANA databases will depend upon the configuration of the database environment.

The standard communication port for a single tenant HANA database is 30015. This is defined by the HANA database setup.

In the case where the target database is located in the SAP HANA multi-tenant environment, the actual port to be used must be determined manually.

To determine the appropriate port, open a SQL Console for the Tenant and run the following query.

SELECT
SERVICE_NAME, PORT, SQL_PORT, (PORT+2) AS "HTTP_PORT"
FROM SYS.M_SERVICES
WHERE ((SERVICE_NAME='indexserver' AND COORDINATOR_TYPE='MASTER') OR (SERVICE__NAME='xsengine'))

The “SQL_Port” value returned by the query is used by Versago. In the following image, the tenant is DEVTenant. The query returns port 30047. The connection in Versago is created using this port, rather than the single tenant 30015.