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 SP 6 » Tenant databases » Connections to tenant databases » Database connection parameters and strings

Connection strings

You can use a connection string to connect to any tenant database running on any cloud server.

For example:

-c "HOST=connection-server1,connection-server2,cloud-arbiter-host
DBN=database-name;UID=database-user-name;PWD=database-password"

Example

  • For example, you have two connection servers that both use the fixed port 2638. One connection server runs on host cloudhost1 and the other connection server runs on host cloudhost2. You have a tenant database named tenant4, that is running on the cloud server cloudhost4#1. To connect to tenant4, run the following:

    dbisql -c "HOST=cloudhost1,cloudhost2;DBN=tenant4;UID=DBA;PWD=sql"
  • For example, you have two connection servers that both use the fixed port 2638. Suppose you have a cloud with two connection servers that each use the fixed port 2638 on hosts cloudhost1 and cloudhost2. One connection server runs on host cloudhost1 and the other connection server runs on host cloudhost2. You have a tenant database called mytenant that uses both mirroring and read-only scale-out. The primary database runs on cloudhost2#1; the mirror database runs on host cloudhost4#1; and a scale-out database copy is running on cloudhost3#1.To connect to the mytenant primary database, run the following command:

    dbisql -c "HOST=cloudhost1,cloudhost2;DBN=mytenant;UID=DBA;PWD=sql"

    To connect to the mytenant mirror copy, run the following command:

    dbisql -c "HOST=cloudhost1,cloudhost2;DBN=mytenant;UID=DBA;PWD=sql;NODE=MIRROR"

    To connect to the mytenant scale-out database copy, run the following command:

    dbisql -c "HOST=cloudhost1,cloudhost2;DBN=mytenant;UID=DBA;PWD=sql;NODE=COPY"