PolarDB for MySQL data source

Limitations

• Only workspace administrators and developers can add data sources.

• Only Quick BI Professional and Advanced editions support creating PolarDB for MySQL data sources.

• Supported versions: 5.6, 5.7, 8.0.1, and 8.0.2.

Procedure

1. Log on to the Quick BI console.

2. Follow these steps to add a data source:

   1. Navigate to the data source creation page by following the instructions in Create a data source.

   2. On the Alibaba Cloud Databases tab, select PolarDB for MySQL.

3. In the Configure Connection dialog box, configure the following parameters.

   Parameter	Description
   Display name	The name of the data source that appears in the data source list. Enter a descriptive name. The name cannot contain special characters or leading or trailing spaces.
   Database address and port	The public endpoint of your PolarDB for MySQL cluster. If you are using a VPC data source, enter the internal endpoint and port of the database. Log on to the PolarDB console. In the Basic Information section, click Apply next to Public Endpoint to obtain the public endpoint and port number. If you use a VPC data source, in the Basic Information section, obtain the private network address and its port number.
   Database	The database name that you specified when you deployed the PolarDB for MySQL cluster. Log on to the PolarDB console. On the Database Management page, find the Database Name.
   Username and password	The username and password to log on to the PolarDB for MySQL cluster.
   Database version	The version number of the MySQL engine in your PolarDB cluster. Log on to the PolarDB console. In the Cluster List, find the MySQL engine version under Compatibility. If the MySQL engine version is 5.7 or earlier, select 5.7. If the MySQL engine version is 8.0, select 8.0.
   VPC data source	If you are connecting through an Alibaba Cloud VPC, select VPC data source and configure the following parameters: AccessKey ID and AccessKey Secret: The AccessKey ID and AccessKey Secret of a RAM user that has permissions to access the target PolarDB for MySQL database. Ensure that the account has read permissions for the target instance. If the account also has write permissions, the system automatically adds the IP addresses to the whitelist. Otherwise, you must add them manually. For more information, see Create a custom RAM policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. Instance ID and Region: The ID of the PolarDB for MySQL cluster and the region where it resides. Note If you select VPC data source, you must enter the internal endpoint and port in the Database address and port fields.
   SSL	Select this option if the target data source requires an SSL connection to protect data in transit.
   Initialize SQL	If enabled, you can specify SQL statements for Quick BI to execute after it establishes a connection. Only SET statements are allowed. Separate multiple statements with semicolons.
   Enable upload file entry	If enabled, this option allows you to upload files.

4. Click Test Connection to verify the connection.

   

5. If the connection test is successful, click OK.