Data Management (DMS) provides graphic interfaces to help you manage databases in a simpler and visual manner. DMS uses permission management to ensure database access security. If you use DMS to connect to AnalyticDB for PostgreSQL, you can focus more on application development and business requirements, instead of management and maintenance of the underlying database.
Overview
DMS allows you to manage relational databases such as MySQL, SQL Server, PostgreSQL, PPAS, and Petadata. DMS also allows you to manage online transaction processing (OLTP) databases such as PolarDB-X, online analytical processing (OLAP) databases such as AnalyticDB and Data Lake Analytics (DLA), and NoSQL databases such as MongoDB and Redis. DMS offers an integrated solution for managing data, schemas, and servers. You can use DMS to grant permissions to users, audit security, view business intelligence (BI) charts and data trends, track data, and optimize performance.
Prerequisites
The internal or public endpoint of an AnalyticDB for PostgreSQL instance is obtained.
If your client is deployed on an Elastic Compute Service (ECS) instance that resides in the same region and uses the same network type as the AnalyticDB for PostgreSQL instance, you can use the internal endpoint to connect to the AnalyticDB for PostgreSQL instance. Log on to the AnalyticDB for PostgreSQL console. In the Database Connection Information section of the Basic Information page, view the internal endpoint of the instance.
If your client is deployed on an ECS instance that resides in a different region or uses a different network type from your AnalyticDB for PostgreSQL instance or a system outside Alibaba Cloud, you must apply for a public endpoint and then use the public endpoint to connect to the AnalyticDB for PostgreSQL instance. For information about how to apply for a public endpoint, see Manage public endpoints.
The IP address of your client is added to an IP address whitelist of the AnalyticDB for PostgreSQL instance. For more information, see Configure an IP address whitelist.
Procedure
Log on to the AnalyticDB for PostgreSQL console.
In the upper-left corner of the console, select the region where the instance resides.
Find the instance that you want to manage and click the instance ID.
(Optional) Create a database account for the instance. For more information, see Create a database account.
If you already created a privileged account, you can use the account to connect to the instance.
In the upper-right corner of the page, click Log On to Database.
In the Log on to Database Instance dialog box, configure the Database Account and Database password parameters, and click Login.
For more information about DMS, see What is DMS?