Quick BI:Add an AnalyticDB for MySQL 3.0

Limits

Only space administrators or developers are permitted to add data sources.

Procedure

1. Add the whitelist.

   Before connecting to Alibaba Cloud MySQL, add the IP address of Quick BI to the whitelist of AnalyticDB for MySQL V3.0. For more information on how to add to the AnalyticDB for MySQL V3.0 whitelist, see Set a Whitelist.

2. Log on to the or the international Quick BI console.

3. Follow the steps shown in the figure below to add a data source.

   1. Navigate to the data source creation interface from the data source creation entry.

   2. Select the Alibaba AnalyticDB for MySQL data source.

      

   3. Choose the Alibaba AnalyticDB for MySQL V3.0 database version.

      

4. Select the engine type you want to connect to and complete the configuration in the Add AnalyticDB for MySQL V3.0 Data Source dialog box.

   • Select the XIHE engine (MPP)

     Name	Description
     Display name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
     Database address	The public address and port of the deployed Alibaba AnalyticDB for MySQL V3.0. If you use a VPC data source, you must enter the internal address and internal port of the deployed database. Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the database address in the connection information. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com
     Port	The port number of the database. The default value is 3306.
     Database	The name of the database to be connected.
     Account and password	The account and password of the database. Make sure that the account has the create, insert, update, or delete permissions on tables in the database.
     VPC data source	If the database uses the Alibaba Cloud VPC network, select VPC data source and configure the following parameters. Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret that have access privileges to the destination database. Make sure that the account has the Read permission on the destination instance. If the account has the Write permission, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see Create a Custom Policy. You can log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. For more information, see Obtain an AccessKey. Instance ID and region: The instance ID and region of the database. Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the instance ID and region of the instance. Note If you select a VPC data source, you must enter the internal address and internal port of the database.
     Initial SQL	You can select this option to configure initial SQL. The SQL statements that are executed to initialize the data source connection. Only SET statements are allowed. Separate statements with a semicolon.

   • Select the Spark engine

     Name	Description
     Display name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
     Database address	The public address and port of the deployed Alibaba AnalyticDB for MySQL V3.0. If you use a VPC data source, you must enter the internal address and internal port of the deployed database. Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the database address in the connection information. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com
     Port	The port number of the database. The default value is 3306.
     Database	The name of the database to be connected.
     Resource group name	The name of the resource group in the database. Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the resource group name in Cluster Management > Resource Management > Resource Group Management.
     Account and password	The account and password of the database. Make sure that the account has the create, insert, update, or delete permissions on tables in the database.
     VPC data source	If the database uses the Alibaba Cloud VPC network, select VPC data source and configure the following parameters. Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret that have access privileges to the destination database. Make sure that the account has the Read permission on the destination instance. If the account has the Write permission, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see Create a Custom Policy. You can log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. For more information, see Obtain an AccessKey. Instance ID and region: The instance ID and region of the database. Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the instance ID and region of the instance. Note If you select a VPC data source, you must enter the internal address and internal port of the database.
     Initial SQL	You can select this option to configure initial SQL. The SQL statements that are executed to initialize the data source connection. Only SET statements are allowed. Separate statements with a semicolon.

5. Click Connection Test to verify the data source connectivity.

   

6. Once the test is successful, click OK to finalize the data source addition.