Using Data Studio to Connect to a GaussDB(DWS) Cluster

Preparations Before Connecting to a Cluster

• You have obtained the administrator username and password for logging in to the database in the data warehouse cluster.
• You have obtained the public network address, including the IP address and port number in the data warehouse cluster. For details, see Obtaining the Connection Address of a GaussDB(DWS) Cluster.
• You have configured the security group of the GaussDB(DWS) cluster and added an inbound rule that allows users' IP addresses to access ports using the TCP.

  For details, see Adding a Security Group Rule in the Virtual Private Cloud User Guide.

Connecting to the Cluster Database Using Data Studio

1. GaussDB(DWS) provides a Windows-based Data Studio client and the tool depends on the JDK. You need to install the JDK on the client host first.
   

   Only JDK 1.8 is supported.

   In the Windows operating system, you can download the required JDK version from the official website of SDK, and install it by following the installation guidance.

2. Log in to the GaussDB(DWS) console.
3. Choose Management > Client Connections.
4. On the Download Client and Driver page, download Data Studio GUI Client.
   • Select Windows x86 or Windows x64 based on the OS type and click Download to download a Data Studio version that matches the current cluster.

     If clusters of different versions are available, you will download the Data Studio matching the earliest cluster version after clicking Download. If there is no cluster, you will download the Data Studio tool of the earliest version after clicking Download. GaussDB(DWS) clusters are compatible with earlier versions of Data Studio.

   • Click Historical Version to download the corresponding Data Studio version. You are advised to download Data Studio based on the cluster version.
   Figure 1 Downloading clients
   

   If you have clusters of different versions, the system displays a dialog box, prompting you to select the cluster version and download the corresponding client. In the cluster list on the Clusters > Dedicated Clusters page, click the name of the specified cluster to go to the Cluster Information page and view the cluster version.

   Table 1 Data Studio download links

   Applicable OS	Download Link	Verification File
   Windows x64	Data_Studio_8.2.x_64.zip	Data_Studio_8.2.x_64.zip.sha256
   	Data_Studio_8.1.x_64.zip	Data_Studio_8.1.x_64.zip.sha256
   	Data_Studio_8.0.x_64.zip	Data_Studio_8.0.x_64.zip.sha256
   Windows x86	Data_Studio_8.2.x_32.zip	Data_Studio_8.2.x_32.zip.sha256
   	Data_Studio_8.1.x_32.zip	Data_Studio_8.1.x_32.zip.sha256
   	Data_Studio_8.0.x_32.zip	Data_Studio_8.0.x_32.zip.sha256

5. Decompress the downloaded client software package (32-bit or 64-bit) to the installation directory.
6. Open the installation directory and double-click Data Studio.exe to start the Data Studio client. See Figure 2.
   Figure 2 Starting the client
   
   

   If your computer blocks the running of the application, you can unlock the Data Studio.exe file to start the application.

7. Choose File > New Connection from the main menu. See Figure 3.
   Figure 3 New connection
   

8. In the displayed New Database Connection window, enter the connection parameters.

   Table 2 Connection parameters

   Field	Description	Example Value
   Database Type	Select HUAWEI CLOUD DWS.	HUAWEI CLOUD DWS
   Connection Name	Name of the connection	dws-demo
   Host	IP address (IPv4) or domain name of the cluster to be connected	-
   Port Number	Database port	8000
   Database Name	Database name	gaussdb
   Username	Username for connecting to the database	-
   Password	Password for logging in to the database to be connected	-
   Save Password	Select an option from the drop-down list: Current Session Only: The password is saved only in the current session. Do Not Save: The password is not saved.	-
   Enable SSL	If Enable SSL is selected, the client can use SSL to encrypt connections. The SSL connection mode is more secure than common modes, so you are advised to enable SSL connection.	-

   If Enable SSL is selected, download the SSL certificate and decompress it. Click the SSL tab and configure the following parameters:

   Table 3 Configuring SSL parameters

   Field	Description
   Client SSL Certificate	Select the sslcert\client.crt file in the decompressed SSL certificate directory.
   Client SSL Key	Only the PK8 format is supported. Select the sslcert\client.key.pk8 file in the directory where the SSL certificate is decompressed.
   Root Certificate	When SSL Mode is set to verify-ca, the root certificate must be configured. Select the sslcert\cacert.pem file in the decompressed SSL certificate directory.
   SSL Cipher	Set the password for the client SSL key in PK8 format.
   SSL Mode	GaussDB(DWS) supports the following SSL modes: require verify-ca GaussDB(DWS) does not support the verify-full mode.

   Figure 4 Configuring SSL parameters
   

9. Click OK to establish the database connection.

   If SSL is enabled, click Continue in the displayed Connection Security Alert dialog box.

   After the login is successful, the RECENT LOGIN ACTIVITY dialog box is displayed, indicating that Data Studio is connected to the database. You can run the SQL statement in the SQL Terminal window on the Data Studio page.

   For details about how to use other functions of Data Studio, press F1 to view the Data Studio user manual.

   

   • Data cannot be rolled back after being added, deleted, modified, or queried in Data Studio.
   • Data Studio can save connection information, excluding passwords.
   • DDL/DDL and data cannot be exported in batches for the following objects:
     • Export DDL:

       Connection, database, foreign table, sequence, column, index, constraint, partition, function/procedure group, regular tables group, views group, schemas group, and system catalog group.

     • Export DDL and Data:

       Connection, database, namespace, foreign table, sequence, column, index, constraint, partition, function/procedure, view, regular tables group, schemas group, and system catalog group.