Connections specify data sources and their credentials used by Versago.

The Connections page provides a list of existing connections in the system

1. Click the [Add Connection] button to create a new user.
2. Click a row in the listing to edit a connection.

Use the standard icons to the search, filter and show/hide columns.

• Fields marked with * are required. All other values are optional.
• Name your connection and select between SQL or HANA databases.

1. Server Name is MSSQL instance name or the HANA server. For HANA connections, the Server Name must include the correct port number (e.i. <hanaserver>:30015).
2. Database Name is the name of the database to be used. It is case sensitive for HANA.
3. Timezone is used by Data Views that display calendars to determine the correct adjustment between the user and connection timezones.
4. Password is not retrieved on edit mode for security reasons.

The standard communications port for a single tenant HANA database is 30015. This is defined during the HANA database setup. The server name field should be set up as <hanaserver>:30015

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

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

SELECT
SERVICE_NAME, PORT, SQL_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 should be used as the port in the Server Name. 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 port 30015 (e.i. <hanaserver>:30047).

Home