Specify at minimum the following connection parameters:
(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:
|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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company - SAP SQL Anywhere, on-demand edition 1.0|