Quick BI:Add a MaxCompute Data Source

Limits

Supports 1.0 and 2.0 versions.

Limits

Only workspace administrators and developers can add data sources.

Procedure

1. Log on to the Quick BI console.

2. Follow the instructions in the following figure to add a data source

   1. Go to the Create Data Source page.

   2. Select Alibaba MaxCompute.

      

3. In the Configure Connection dialog box, set the following 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 URL that is used to connect to the MaxCompute project over the Internet or classic network. You recommend use a classic network connection (if the network is not connected, you must disable the whitelist limit) to improve the connection speed and avoid additional fees that may be incurred in Internet access. Select the corresponding classic network endpoint based on the region where the project is located. For more information about the region, click in the upper-left corner. For example, the corresponding classic network endpoint for China (Hangzhou) is http://service.cn-hangzhou.maxcompute.aliyun-inc.com/api.
   Project Name	The name of the MaxCompute project. Log on to the MaxCompute console. Switch the region in the upper-left corner. Then, you can view the name of the MaxCompute project on the Project Management tab.
   AccessKey ID and AccessKey Secret	The AccessKey pair of your Alibaba Cloud account that is used to access the MaxCompute project. Make sure that the account has the Createlnstance, List, and Desc permissions on the project. If you want to upload objects, you must also have the CreateTable and Write permissions on the project. Log on to the RAM console and obtain the AccessKey ID and AccessKey secret.
   MaxCompute Query Acceleration	Specifies whether to enable the MaxCompute Query Acceleration (MCQA) feature. If you want to enable the MCQA feature, select this option. For more information about the MCQA feature, see MaxCompute Query Acceleration.
   Enable the file upload portal	You can upload files after you enable this function.
   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.

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

   

5. Click OK.

   After the data source is added, you can view the data source in the data source list.

   Note

   After you add a MaxCompute data source, Quick BI asynchronously loads and updates data from MaxCompute. If you add the data source for the first time, wait one to five minutes for data synchronization.