Quick BI:Add a MaxCompute Data Source

Limits

Versions 1.0 and 2.0 are supported.

Limits

Only workspace administrators and developers can add data sources.

Procedure

1. Log on to the Quick BI console.

2. Add a data source as shown in the following figure:

   1. Go to the Create Data Source page from the entry for creating a data source.

   2. Select Alibaba MaxCompute data source.

      

3. In the Configure Connection dialog box, complete the connection configurations.

   Name	Description
   Display 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 used to connect to the MaxCompute project. You can use a public network or cloud product interconnection. We recommend that you use the "Cloud Product Interconnection Endpoint" (if the network is not connected, you need to disable the whitelist restriction) to avoid additional costs that may be incurred when accessing through the public network. Select the corresponding "Cloud Product Interconnection Endpoint" based on the region where your project is located (you can check the region by clicking the upper-left corner after logging in to the MaxCompute console). For example, the "Cloud Product Interconnection Endpoint" for China (Hangzhou) is https://service.cn-hangzhou-intranet.maxcompute.aliyun-inc.com/api.
   Project Name	The name of the MaxCompute project. Log on to the MaxCompute console, switch to the appropriate region in the upper-left corner, and then you can view the specific MaxCompute project name 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 CreateInstance, List permissions for the project and the Desc permission for tables. If you need to upload files, the account must also have the CreateTable and Write permissions for the project. Log on to the RAM console to 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 Query Acceleration.
   Enable File Upload Entry	After this option is enabled, you can upload files.
   Init SQL	After this option is enabled, you can configure SQL statements that are executed for initialization after the data source is connected. The SQL statements that are executed for initialization each time the data source is connected. Only SET statements are allowed. Separate statements with semicolons.

4. Click Test Connection to test the connectivity of the data source.

   

5. After the test is successful, click OK to add the data source.

   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.