Community Blog How to Set up and Configure Alibaba Cloud Data Management Service to Manage all Your Cloud Databases

How to Set up and Configure Alibaba Cloud Data Management Service to Manage all Your Cloud Databases

This article explains how to set up and configure Alibaba Cloud Data Management Service to manage your cloud databases.

By Kelvin Galabuzi

What Is Alibaba Cloud Data Management Service?

Alibaba Cloud Data Management Service (DMS) is a database research and development service used for managing and securing multiple data sources. DMS supports databases, including relational databases (such as MySQL, SQL Server PostgreSQL, PolarDB, etc.), NoSQL Databases (such as MongoDB and Redis), and Data warehouses (such as AnalyticDB, ClickHouse, and Data Lake Analytics).

Alibaba Cloud Data Management Service is always free to use. However, you can also opt-in for the DMS Pro edition to have a DMS customized to your needs using features (such as Sensitive Data Protection, Stable Change, and Security Collaboration).

Alibaba Cloud Data Management Service Core Features

  • Secure Database Access: DMS allows users to use cloud account authorization and auditing to manage a large number of database instances.
  • Multi-Database Sources: DMS provides a unified database management platform to manage multiple relational, non-relational databases and data warehouses. Additionally, DMS supports the management of multi-cloud and on-premises databases.
  • Data Import and Export: DMS allows easy importation and exportation of database data to different file formats, such as Word, Excel, PDF, etc.
  • Unified Data Security: DMS supports the on-demand authorization of databases, tables, and fields and supports on-demand control of rows returned from each query. In addition, it supports the logging of people, time, modules, and behaviors of any operations performed on a database.
  • Facilitates Data Research and Development: DMS provides an efficient research and development process by providing easy-to-use data analysis tools, performing cross-instance queries on heterogeneous databases through a single SQL statement, and supporting multiple data sources to enable ease of integration of data from different sources.

Setting up and Configuring Alibaba Cloud Data Management Service

  • Step 1: On the Alibaba Cloud Console, access the Utilities and Tools section and then select the Data Management service:


  • Step 2: On the Data Management Service console, you will be presented with a list of the current databases in your Alibaba Cloud account:


  • Step 3: You can add Databases to DMS on the console. Click Add Database under the Databases blade:


  • Step 4: Select the Database type, Database Instance type, Logon address, port, databases username, and password and then click on Connectivity Test. If the test is successful, you can click on the Add button:


Note: The logon address is the Fully Qualified Domain Name of your database instance and is used to access your database over the database TCP port.

  • Step 5: In the RDS (Ali Cloud General DB) section, you can select an RDS instance you want to connect:


Optionally, you can try out the Data Management Service (DMS) User Interface within this blade. The option is available on the top right section of the DMS console:


The new DMS experience will load in a different tab:


  • Step 6: In the account authorization section, you can create a Database Account Group:


Note: A Database account group allows you to specify database accounts that allow authorized users to log on to databases. This feature reduces the exposure of your passwords, making your data more secure.

  • Step 7: Click the Create Account Group button to create a Database account group. Add an Account Group Name, Logon User, and Logon Password:


After creation, the new Database account group will appear on the console:


  • Step 8: Select your instances region, authorize users, authorize source IP addresses, and view instances under the Instances blade:


  • Step 9: The Operation Logs section shows the different operations performed on your database instances registered in DMS:


  • Step 10: In the Security Audit category blade, you can view the security audit logs associated with your Database instances:


  • Step 11: Under Audit Analysis, you can view the different statistics associated with your Database Instances:


0 0 0
Share on

Alibaba Cloud Community

921 posts | 208 followers

You may also like