Data Management Service (DMS) allows you to connect to a database on the internal network of a third-party cloud service by using a Cloud Enterprise Network (CEN) and then register and manage the database as an instance in the DMS console.
- The Virtual Private Cloud (VPC) service is activated and a VPC is connected to the target third-party internal network. For more information about how to establish the connection, see Build an enterprise-level hybrid cloud by using different access methods. The following figure shows the relevant route configuration.
- DMS is activated.
- You are a database administrator (DBA) or a DMS administrator.
CEN is a network that Alibaba Cloud provides to offer a high-quality transmission service. By simplifying the network connection, CEN allows you to quickly build an enterprise-level hybrid cloud that has communication capabilities. In the hybrid cloud that you build, you can connect to a third-party cloud service through the CEN to register a database in the third-party cloud and then manage the database in the DMS console.
We recommend that you register your database by using a database gateway, which is more secure and convenient. Currently, the Database Gateway service is in public preview and is free of charge. For more information, see Register a database in a third-party cloud by using a database gateway. Currently, DMS allows you to register the following types of VPC-connected databases as instances:
- SQL Server
Log on to the DMS console.
Move the pointer over the plus sign (+) in the upper-left corner and select Add instance.
You can also open the Add instance dialog box in the following way:
- In the top navigation bar, choose System Management > Instance.
- On the Instance List tab of the Instance page, click New in the upper-left corner.
In the Add instance dialog box that appears, click the VPC line IDC tab.
In the VPC line IDC section, select a database type.
In the dialog box that appears, set the parameters as required. The following table describes the parameters.
Tab Parameter Description Basic Information Database Source The category of the data source. Set this parameter to VPC line IDC. Database type The type of the database to be registered. Instance Area The Alibaba Cloud region that is geographically close to the region where the target database is deployed. VPC ID The ID of the VPC that is connected to the third-party internal network. You must establish the connection before you register the database. For more information, see Build an enterprise-level hybrid cloud by using different access methods. 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 username that you use to log on to the database. Database password The password that you use to log on to the database. Control Mode The control mode that is used to manage the instance in DMS. For more information, see Control modes. Advanced Information Environment type The type of environment where the database is deployed. Instance Name The name that you specify for the instance in DMS. Enable DSQL Specifies whether to enable the cross-database query feature for the database. For more information, see Cross-database query. OnlineDDL Specifies whether to allow changing schemas without locking tables for the database and the specific method. For more information, see Change schemas without locking tables. DBA The DBA of the instance who is allowed to grant permissions to users. query timeout(s) The timeout interval of the statement that is used to query data. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security. export timeout(s) The timeout interval of the statement that is used to export statistics. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
On the Basic Information tab, click Test connection in the lower-left corner. Wait until the connectivity test is passed.
If the test fails, check the parameter values that you specify.
Click Submit. Now you have registered a database in a third-party cloud as an instance in DMS and the instance appears in the left-side navigation pane of the DMS console. You can view and manage the instance in the DMS console.