Quick BI:Add an AnalyticDB for MySQL 3.0 Data Source

Limitations

Only workspace administrators and developers can add data sources.

Procedure

1. Configure a whitelist.

   Add the IP addresses of Quick BI to the whitelist of your AnalyticDB for MySQL 3.0 instance. Configure a whitelist.

2. Log on to the Quick BI console.

   1. Go to the data source creation page.

   2. For database version, select Alibaba AnalyticDB for MySQL 3.0.

4. Select an engine type and configure the parameters in the Add AnalyticDB for MySQL 3.0 Data Source dialog box.

   • Select XIHE Engine (MPP)

     Parameter	Description
     display name	Display name of the data source. No special characters or leading/trailing spaces allowed.
     database address	Public endpoint of the AnalyticDB for MySQL 3.0 instance. For VPC data sources, enter the private endpoint. Find the address in the AnalyticDB for MySQL console under connection information. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com
     port	Connection port. Default: 3306.
     database	Name of the target database.
     account and password	Database account and password. The account must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
     VPC data source	Select VPC data source if the database is in an Alibaba Cloud VPC, and configure the following parameters. Credentials to access the database. The account must have read permissions on the target instance. With write permissions, IP addresses are automatically whitelisted; otherwise, add them manually. For more information, see Create a custom policy. Obtain the AccessKey ID and AccessKey Secret from the RAM console. Obtain an AccessKey. instance ID and region: ID and region of the database instance. Find these values in the AnalyticDB for MySQL console. Note When using a VPC data source, enter the private address and port.
     Initialize SQL	Enable to run SQL statements on each connection. Only SET statements are allowed. Separate multiple statements with semicolons (;).

   • Select Spark Engine

     Parameter	Description
     display name	Display name of the data source. No special characters or leading/trailing spaces allowed.
     database address	Connection endpoint of the resource group. For VPC data sources, enter the VPC endpoint. To find the resource group address: Log on to the AnalyticDB for MySQL console and click the target cluster's ID to open its details page. In the left-side navigation pane, choose Cluster Management > Resource Management, and then click the Resource Groups tab. In the Actions column of the target resource group, choose More > Details.
     port	Connection port. Default: 3306.
     database	Name of the target database.
     resource group name	Name of the target resource group. Find this in the AnalyticDB for MySQL console under Cluster Management > Resource Management > Resource Group Management.
     account and password	Database account and password. The account must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
     Initialize SQL	Enable to run SQL statements on each connection. Only SET statements are allowed. Separate multiple statements with semicolons (;).

5. Click Test Connection.

   

6. After the test succeeds, click OK.