Updated on 2023-12-05 GMT+08:00

Adding a Self-Built Database

Add self-built database assets.

Prerequisites

  • DSC has been allowed to access the database assets. For details, see Allowing or Disallowing Access to Cloud Assets.
  • The self-built database engine, version, and database server address have been obtained. There are available IP addresses in the corresponding subnet.

Constraints

Only asset types and versions supported by DSC can be added. For details, see Table 1.

Table 1 Asset types and versions supported by DSC

Asset Type

Version

MySQL

5.6, 5.7, 5.8, and 8.0

SQL Server

  • 2017_SE, 2017_EE, and 2017_WEB
  • 2016_SE, 2016_EE, and 2016_WEB
  • 2014_SE and 2014_EE
  • 2012_SE, 2012_EE, and 2012_WEB
  • 2008_R2_EE and 2008_R2_WEB

KingBase

V8

DMDBMS

7 and 8

GaussDB for openGauss

1.4

PostgreSQL

11, 10, 9.6, 9.5, 9.4, and 9.1

TDSQL

10.3.X

Oracle

11, 12

DDS

4.2, 4.0, and 3.4

DWS

4.2, 4.0, and 3.4

Elasticsearch

5.x, 6.x, and 7.x

OBS

V3

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select a region or project.
  3. In the navigation pane on the left, click and choose Security & Compliance > Data Security Center.
  4. In the navigation tree on the left, choose Asset Management > Assets. On the displayed Assets page, choose Database > Unauthorized. The Unauthorized Database page is displayed, as shown in Figure 1.

    Figure 1 Unauthorized database assets

  5. In the upper left corner of unauthorized database assets, click Add Self-Built Database.
  6. In the displayed dialog box, set database parameters. For details, see Table 2.

    Figure 2 Adding a self-built database
    Table 2 Parameters for adding a self-built database

    Parameter

    Description

    Example Value

    Asset

    Database name

    N/A

    Region

    Region where the account is used for login

    N/A

    ECS

    Select an ECS instance created in ECS from the drop-down list.

    N/A

    Security Group

    Name of the security group to which the ECS instance belongs

    default

    Database Engine

    Database engine

    Value options: MySQL, TDSQL, KingBase, DMDBMS, PostgreSQL, SQLServer, and Oracle

    MySQL

    Version

    Version number corresponding to the database engine

    5.6

    Schema Name

    Database schema name

    N/A

    Database Server Address

    IP address of the database server

    N/A

    Port

    Port number of the database server

    N/A

    Database

    Self-built database name

    N/A

    Username

    Username for logging in to the database server

    N/A

    Password

    Password for logging in to the database server

    N/A

  7. Click OK. The authorized databases are displayed on the Authorized tab page.

    Figure 3 Connectivity test
    DSC will check the connectivity of the added database, and the connectivity status of the added database is Checking.

Related Operations