Creating a Data Source

Scenarios

You can perform unified data source management. Currently, this function is used only for SQL audit.

Prerequisites

The data source to be created must be connected successfully.

Procedure

1. Log in to the UGO console.
2. In the navigation pane, choose Data Source Management.
3. Click Create Data Source in the upper right corner.
4. Configure parameters as needed.

   After the basic information is configured, the Test button next to Test Connection is available.

   Figure 1 Creating a data source
   

   Table 1 Parameter description

   Parameter	Description
   Name	Name displayed in the data source management list The name must contain 5 to 50 characters, start with a letter, and end with a digit or letter. Only letters (case-insensitive), digits, underscores (_), and hyphens (-) are allowed.
   DB Type	Type of the source database to be configured. GaussDB, MySQL, PostgreSQL, TaurusDB, GoldenDB, Oracle, Microsoft SQL Server, and MariaDB are supported.
   Network Type	Public network: An EIP is used to connect to a database. If the database has an IP address whitelist, add the EIP to the whitelist to ensure that UGO can connect to the database.
   Connection Method	Only a service name can be used for connection.
   DB Name	Name of a database to be managed. The name can contain 2 to 128 characters, including letters, digits, periods (.), underscores (_), hyphens (-), dollar signs ($), number signs (#), and spaces. The value must start with a letter, digit, period (.), underscore (_), hyphen (-), or space. The name can be enclosed in double quotation marks ("").
   Host IP Address/Host Name	Host IP address (IPv4 or IPv6) or host name NOTE: When DB Type is set to MySQL, an IPv6 address can be used.
   Host Port	Port of the database to be managed
   Username	Username of the database to be managed. The username can contain 2 to 128 characters and must start with a letter, digit, period (.), underscore (_), or hyphen (-). Only letters, digits, periods (.), underscores (_), hyphens (-), dollar signs ($), and number signs (#) are allowed. The username can be enclosed in double quotation marks ("").
   Password	Password of the database to be managed. The password can contain up to 50 characters.
   SSL Type	No SSL: SSL is disabled and there may be potential security risks. One-way SSL: The target database will be authenticated and transmission will be encrypted. Truststore password: Enter the password of the truststore used to access the certificate. Click Add File to upload the root certificate file of the target database. NOTE: If you select One-way SSL, enter the correct uploaded file and entered password, which are private information of users. If the target database type is GaussDB or PostgreSQL, upload a PEM root certificate file. No password is required. Secure Socket Layer (SSL) provides a secure connection between the network and application layers. In mutual SSL authentication, an SSL connection between a client and a server is established only if they validate each other's identity using digital signatures. If SSL is disabled, your data may be at risk.

5. Click Test. If the test is successful, Connected is displayed, and the Create button in the lower right corner is available.

   If the test failed dut to network faults or insufficient permissions, an error is displayed. You cannot create a data source.

6. Click Create. A message is displayed, indicating that the project is created.
7. Click OK to go to the Data Source Management page. View the data source you created in the list.
   You can search for a data source by data source ID, data source name, database name, database type, IP address, or port.

   Figure 2 Viewing a data source