Create Huawei Cloud DWS Data Source

NineData supports adding data sources of different types and environments to the console for centralized management. After a data source is added, you can use features such as Database DevOps, Backup and Restore, Data Replication, and Data Comparison. This topic describes how to add a Huawei Cloud DWS data source to NineData.

Prerequisites

• The server IP address of NineData has been added to the data source allowlist. The server IP address can be viewed by selecting the target region in Access Region on the Create Datasource page.

  

• Make sure you have available data source quota; otherwise, the data source cannot be added. You can quickly check your remaining quota at the top-right corner of the NineData console.

Procedure

1. Log in to the NineData Console.

2. In the left-side navigation pane, choose Datasource > Datasource.

3. On the Datasource tab, click Create Datasource. In the data source type dialog box, choose Huawei Cloud > Cloud Datasource > Cloud Data Warehouse (DWS), and then configure the parameters on the Create Datasource page using the table.

   tip

   If you select the wrong type, click the icon at the top of the Create Datasource page to reselect the data source type.

4. Configure the data source parameters:

   Parameter	Description
   Name	Enter a data source name.
   Connection	Select the connection method. The console currently supports Private Network, IP Address, Gateway, and SSH Tunnel. If a private connection has already been created, Private Network is recommended.
   Private Connection	When Private Network is selected, choose the created private connection here.
   Access Method	The current fixed value is Connection Address.
   Connection Address	Enter the DWS endpoint and port. The default port shown in the console is 8000.
   DB Account	Enter the database login username.
   DB Password	Enter the database login password.
   Access Region	Select the access region nearest to the instance.
   Environment	Select the environment tag for the data source, such as Production or Development.

5. After all parameters are configured, click Connection Test on the right of Create Datasource to test connectivity. When Connection Successfully is displayed, click Create Datasource to finish creating the data source.

Result

After the connection test succeeds and you create the data source, it appears in the data source list. You can use it in NineData features that support this data source type.