O&M Asset Repository

Usage of Constraints

Prerequisites

Obtain asset IP address, port number, asset type, database account, database password, database name/instance name and other relevant information.

Adding Data Assets

1. Logging in to the Database Operations and Maintenance Management System using the sysadmin system administrator account.
2. Select Ops Asset Management > Ops Asset DB from the left navigation bar to access the asset configuration page, then click Add data source.
   Figure 1 Adding new data source
   

3. Configure asset information in the Add Asset dialog box.

   Table 2 Table2 Parameter description for asset addition

   Parameter	Description
   Data Source Type	Select the type of data asset. Supported types include MySQL, Oracle, PostgreSQL, DB2, SQL Server, MariaDB, Kingbase, DM, Greenplum and OpenGauss. (Required)
   Data Source Name	Customize a name for the data asset. (Required)
   IP	Enter the IP address or domain name of the data asset. (Required)
   Port	Fill in the corresponding service port of the data asset. (Required)
   Database / Instance Name	Input the database name or instance name. (Required)
   Username	Specify the login account of the database. (Required)
   Password	Enter the corresponding database login password. (Required)
   Database Version	Displays the database version information. Click Detect to auto-identify and populate the version; alternatively, select a specific version from the drop-down list. (Required)
   Character Encoding	Shows the character set of the managed database. Available options vary by database; for example, MySQL provides UTF8 and GBK as two commonly-used encoding options. (Required)
   Authorized User	Grant asset management permissions to designated system users. Authorization is mandatory upon data source saving. Only authorized users can select and bind this data source when creating new Ops Asset Control rules. (Required)

4. Click OK to save the configuration of the data asset.

   After addition, you can view the newly added data asset in the asset list.

Relevant Operations

You may perform the following data source management operations as needed later:

• Verify whether the IPv4 address of the primary server on the O&M asset proxy service page is an intranet IP and whether the public network IP is configured correctly. If the configuration is incorrect, administrators shall not execute Automated Security Configuration or any other related operations.
  Figure 2 O&M asset proxy service
  
• Automated Security Configuration: Locate the target asset and click this button; the system will automatically generate default security configurations for the asset (including a default Ops Asset Control policy and Ops Asset Proxy Server).
• Edit Data Asset: Click Edit to modify data asset information.
• Delete Data Asset: Click Delete to remove the target data asset.
  

  Prior to asset deletion, you must first cancel the asset protection status by deleting its corresponding Ops Asset Control.

• Detect: When adding or editing an asset, click detection to retrieve the version information of the data asset.
• Test: When adding or editing an asset, click Testing to verify the connectivity of the data asset.