Alibaba Cloud data source: PolarDB for Xscale

Procedure

1. Configure an IP address whitelist.

   Before connecting to PolarDB for Xscale, add the IP addresses of Quick BI to the database's IP address whitelist. For instructions, see Set an IP address whitelist.

2. Verify the data source connection and create the data source.

   1. Log on to the Quick BI console.

   2. Follow these steps to add the data source:

      1. Navigate to the page for creating a data source. For more information, see Create a data source.

      2. On the Alibaba Cloud database tab, select PolarDB for Xscale.

         

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

   Parameter	Description
   Display name	The display name for the data source. This name must be unique and cannot contain special characters or leading or trailing spaces.
   Database address	The public endpoint of your PolarDB for Xscale database. For a VPC data source, enter the internal endpoint instead. Obtain the database address from the Distributed Relational Database Service console. Example: xxxxxxxxxxxxxxxxxxxxxx.drds.aliyuncs.com For more information, see View database information.
   Port	The port number used to connect to the database.
   Username and password	The username and password for the database account. The account must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables you want to access.
   VPC data source	If your database is in an Alibaba Cloud Virtual Private Cloud (VPC), select VPC data source and configure the following parameters. Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret for an account with permissions to manage the target database. The account must have read permissions on the target instance. If the account also has write permissions, Quick BI automatically adds its IP addresses to the IP address whitelist. Otherwise, you must add them manually. For more information, see Create a custom RAM policy. Obtain your AccessKey ID and AccessKey Secret from the RAM console. Instance ID and Region: The instance ID and region of the PolarDB for Xscale database. Log on to the Distributed Relational Database Service console to obtain the instance ID and region. Instance version: Select the version of your instance. Supported versions are 1.0 and 2.0. Note If you select VPC data source, enter the internal endpoint in the Database Address field and its port number in the Port field.
   Enable file upload	Enables file uploads.

4. Click Test Connection to verify the connection.

   

5. After the connection test succeeds, click OK to add the data source.