:Register an on-premises database by using an Express Connect circuit

Usage notes

• You are charged for using an Express Connect circuit. We recommend that you register your on-premises database by using Database Gateway, which is more secure and convenient. Database Gateway is in public preview and is free of charge. For more information, see Register a self-managed database deployed in a data center by using Database Gateway.
• DMS allows you to register the following types of VPC-connected databases as instances:

  MySQL, SQL Server, PostgreSQL, Oracle, MongoDB, Redis, OceanBase, ClickHouse, MariaDB, DamengDB, and DB2

Procedure

1. Log on to the DMS console V5.0.
2. On the Home page of the DMS console, click the icon in the upper-right corner of the left-side instance list.
   Note Alternatively, click Data Assets in the top navigation bar. In the left-side navigation pane, click Instances. On the Instances page, click New.
3. In the Add Instance dialog box, click the VPC line IDC tab and select a database type.
4. Set the parameters as described in the following table.

   Basic Information	Data Source	The source of the database. Set this parameter to VPC line IDC.
   	Database Type	The type of the database to be registered.
   	Instance Region	The Alibaba Cloud region that is geographically close to the region in which the database is deployed.
   	VPC ID	The ID of the VPC that is connected to your data center. You must establish a connection between the VPC and your on-premises database before you register the database. For more information, see Build an enterprise-class hybrid cloud by combining multiple connection services.
   	Login Address	The endpoint that is used to connect to the database.
   	Port	The port that is used to connect to the database.
   	Database Account	The account that you use to log on to the database.
   	Database password	The password of the account that you use to log on to the database.
   	Control Mode	The control mode that is used to manage the database in DMS. For more information, see Control modes.
   	Sensitive Data Protection	Specifies whether to enable the sensitive data protection feature based on your business requirements. This feature allows you to control and mask sensitive data. For more information, see Overview.
   Advanced Information	Environment type	The type of the environment in which the database is deployed.
   	Instance Name	The instance name that you specify for the database in DMS.
   	Enable DSQL	Specifies whether to enable the cross-database query feature for the database. For more information, see Query data across multiple database instances.
   	Lock-free Schema Change	Specifies whether to enable the lock-free schema change feature for the database. For more information, see Perform lock-free DDL operations.
   	Enable SSL	Specifies whether to allow DMS to connect to the database by using SSL connections. If this feature is enabled, DMS can connect to the database by using SSL connections. Valid values: Default (DMS automatically checks whether self-negotiation is enabled for the database instance.): DMS automatically checks whether the SSL encryption feature is enabled for the database. If the SSL encryption feature is enabled, DMS connects to the database by using SSL connections. Otherwise, DMS connects to the database without encryption. Open: DMS connects to the database by using SSL connections. This value is invalid if you disable the SSL encryption feature for the database. Close: DMS does not connect to the database by using SSL connections. Note This parameter is displayed only if you set the Database Type parameter to MySQL.
   	DBA	The DBA of the database. The DBA can grant permissions to users.
   	query timeout(s)	The timeout period for the execution of an SQL query statement. If the execution of an SQL query statement lasts longer than the specified timeout period, the execution of the statement is terminated to protect the database.
   	export timeout(s)	The timeout period for the execution of an SQL export statement. If the execution of an SQL export statement lasts longer than the specified timeout period, the execution of the statement is terminated to protect the database.

   Note After you set the preceding parameters, click Test Connection in the lower part of the dialog box. Wait until the connectivity test passes. If the connectivity test fails, an error message appears. Modify the parameters as prompted and try again.
5. Click Submit.
   After you register an on-premises database as an instance in DMS, the instance appears in the left-side instance list of the DMS console. You can view and manage the instance in the DMS console.