• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. User Guide
  4. Connecting to a Cluster
  5. Obtaining the Cluster Connection Address

Obtaining the Cluster Connection Address

Scenario

You can access data warehouse clusters using different methods and the connection address of each connection method varies. This section describes how to view and obtain the private network address in the public cloud, public network address on the Internet, and JDBC connection strings.

To obtain the cluster connection address, use either of the following methods:

Obtaining the Cluster Connection Address on the Connection Management Page

  1. Log in to the DWS management console.
  2. In the navigation tree on the left, click Connection Management.
  3. In the Data Warehouse Connection Information area, select an available cluster.

    You can only select clusters in the Available state.

    Figure 1 Connection information

  4. View and obtain the cluster connection information.

    • Private Network Address
    • Public Network Address
    • JDBC URL (Private Network)
    • JDBC URL (Public Network)
    • ODBC URL
    NOTE:
    • If no EIP is automatically assigned during cluster creation and Public Network Address is empty, click Bind EIP to bind an EIP to the cluster.
    • If an EIP is bound during cluster creation, click Unbind EIP to unbind the EIP.

Obtaining the Cluster Access Addresses on the Basic Information Page

  1. Log in to the management console at https://console.otc.t-systems.com/dws/.
  2. In the navigation tree on the left, click Cluster Management.
  3. In the cluster list, click the name of the cluster that you want to view. The Basic Information page is displayed.
  4. In the Database Attribute area, view and obtain the cluster's access address information, including the private network address and public network address.

    Figure 2 Access addresses
    Table 1 Database attribute parameters

    Parameter

    Description

    Default Database

    Database that is automatically created during cluster creation. When you connect to the cluster for the first time, you need to connect to the default database.

    Initial Administrator

    Administrator user specified during cluster creation. When you connect to the cluster for the first time, you need to use the initial administrator and password to connect to the default database.

    Port

    Port for accessing the cluster database over the public network or private network. Database port specified during cluster creation. It is used to listen to client connections.

    JDBC URL (Private Network)

    In the private network environment, you can use the JDBC URL (private network) to connect to the cluster when developing applications.

    JDBC URL (Public Network)

    In the public network environment, you can use the JDBC URL (public network) to connect to the cluster when developing applications.

    Private Network Domain Name

    Name of the domain for accessing the database in the cluster through the private network. The private network domain address is automatically generated when you create a cluster. The default naming rule is as follows: cluster name.dws.otc-tsi.de

    NOTE:

    If the cluster name does not comply with the domain name standards, the prefix of the default access domain name will be adjusted accordingly.

    Click Modify to change the private network access domain name. The access domain name contains 4 to 63 characters, which consist of letters, digits, and hyphens (-), and must start with a letter.

    For more information, see section Managing Access Domain Names.

    Private Network IP Address

    IP address for accessing the database in the cluster through the private network. The private network address is automatically generated when you create a cluster.

    Public Network Domain Name

    Name of the domain for accessing the database in the cluster through the public network.

    NOTE:
    • If you have not bound an EIP to the cluster, Public Network IP Address, Public Network Port, and Public Network Domain Name are left blank.
    • If you bind an EIP during cluster creation, the public network domain name is automatically generated. The default naming rule is as follows: cluster name.dws.t-systems.com
    • Bind an EIP to the cluster before binding the public network domain name to the cluster. Click Create to bind the public network domain name to the cluster.
    • You can click Modify to modify the public network domain name bound to the cluster. The domain name contains 4 to 63 characters, which consist of letters, digits, and hyphens (-), and must start with a letter.
    • You can click Release to release the public network domain name bound to the cluster.

    For more information, see section Managing Access Domain Names.

    Public Network IP Address

    IP address for accessing the database in the cluster through the public network.

    NOTE:
    • If no EIP is assigned during cluster creation and Public Network IP Address is empty, click Bind EIP to bind an EIP to the cluster.
    • If an EIP is bound during cluster creation, click Unbind EIP to unbind the EIP.

    ODBC URL

    In DWS, you can use an ODBC driver to connect to the database. The drivers can connect to the database through the ECS in the public cloud or over the Internet.