Quick BI:Add an Alibaba AnalyticDB for MySQL 3.0 Data Source

Limits

Only workspace administrators and developers can add data sources.

Procedure

1. Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.

   Before connecting to ApsaraDB for MySQL, you must add the Quick BI IP address to the whitelist of AnalyticDB for MySQL 3.0. For more information about how to add a AnalyticDB for MySQL 3.0 whitelist, see Configure a whitelist.

2. After you log on to the Quick BI console.

3. Perform the steps that are shown in the following figure to add an AnalyticDB for MySQL V3.0 data source.

   1. Go to the Create Data Source page from the Create Data Source page.

   2. Select the Alibaba AnalyticDB for MySQL data source.

      

   3. Select Alibaba AnalyticDB for MySQL 3.0 for the database version.

      

4. In the Add AnalyticDB for MySQL 3.0 Data Source dialog box, configure the parameters.

   Feature	Description
   Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
   Database address	The public IP address and port number of the deployment Alibaba AnalyticDB for MySQL 3.0. If you use a VPC data source, you must enter the internal IP address and port number of the deployment database. Log on to the cloud-native Data Warehouse AnalyticDB for MySQL console and obtain the database address in the Connection Information section. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com.
   Port Number	The port corresponding to the database endpoint.
   Instance	The name of the database to which you want to connect.
   Account	The account of the database. Make sure that the account has the CREATE, INSERT, UPDATE, and DELETE permissions on tables in the database.
   Password	The password of the database account.
   VPC Data Source	Select VPC Data Source and set the following parameters: AccessKey ID: the AccessKey ID that is used to purchase the instance. For more information, see Create an AccessKey pair. AccessKey: the AccessKey secret that is used to purchase the instance. For more information, see Create an AccessKey. Instance ID: the ID of the ECS instance. Region: the region in which the ECS instance is deployed.
   Initialize SQL statements	The SQL statement that is initialized and executed after each data source connection. Only SET statements are allowed. The statements are separated by semicolons.

5. Click Test Connection to verify that the data source can be connected.

   

6. Click OK.