Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 » SAP SQL Anywhere, on-demand edition » Tenant databases » Connections to tenant databases » Database connection parameters

 

Connection parameters to use when connecting to a tenant database in the cloud

Specify at minimum the following connection parameters:

Connection parameter Description
HOST

(Required) One or more host names (or IP addresses) and port numbers (if not the default TCP/IP 2638) of any cloud servers using fixed ports running in the cloud. For example, to connect using TCP/IP specify the following: myhost:49152.

DBN (Required) The name of the database in the cloud. For example, DBN=tenant1.
UID (Required) The user ID used to log in to the database.
PWD (Required) The password for the user ID specified by the UID connection parameter.

By default, when you connect to a database in the cloud, the NodeType (NODE) connection parameter is set to PRIMARY. So, when you connect to a database in the cloud, the connection is redirected to the Primary database. To change this connection redirection behavior, set the NodeType connection parameter to one of the following values:

  • PRIMARY   Default. Redirects the application to the tenant's primary database.

  • MIRROR   Redirects the application to the tenant's mirror database.

  • COPY   Redirects the application to a scale-out database copy of the database.

  • READONLY   Redirects the application to any database copy: either a scale-out database copy or the mirror copy. If there are no scale-out database copies, READONLY is equivalent to the MIRROR setting. If there are only scale-out database copies, READONLY is equivalent to the COPY setting.

  • DIRECT   Connection redirection does not apply. The connection succeeds only if the database is running on the host specified. When the NodeType connection parameter is set to DIRECT, you can specify the ServerName connection parameter. Otherwise, you cannot use the Server Name connection parameter.

    Caution

    Do not set NodeType to DIRECT. Following this recommendation allows the database to be moved to a different cloud server or host without affecting the connection to your application.