Connect Sugar BI to MaxCompute

Prerequisites

• You have created a MaxCompute project.

  For more information, see Create a MaxCompute project.

• You have obtained an AccessKey ID and an AccessKey Secret with permissions to access the MaxCompute project.

  You can obtain the AccessKey ID and AccessKey Secret on the AccessKey Management page.

• The Sugar BI service is activated.

Procedure

To connect Sugar BI to MaxCompute for visual data analysis, follow these steps:

1. Step 1: Connect Sugar BI to MaxCompute

   Configure connection parameters to connect Sugar BI to your MaxCompute project.

2. Step 2: Create a data model

   Create a data model to prepare for visual data analysis.

3. Step 3: Perform visual data analysis

   Access and analyze data from your MaxCompute project by using Sugar BI.

Step 1: Connect Sugar BI to MaxCompute

1. Log on to the Sugar BI console and click Use Now.

2. In the Organization List, find the target organization and click Enter Organization in the Actions column.

3. On the Space Square page, click the target space.

4. In the left-side navigation pane, choose Data Management > Data Source. On the Data Source Management page, click Add Data Source.

5. In the Add Data Source dialog box, configure the following parameters.

   Parameter	Description
   Data source network	Select Public Network.
   Type	Required. The type of the data source. Select MaxCompute (Alibaba Cloud).
   Data source name	Required. A unique name for the data source connection. This name helps you identify the connection within Sugar BI. Example: MaxCompute.
   Description	Optional. A description of the data source.
   Database host	Required. The endpoint for the region that contains your MaxCompute project. For information about the endpoints for each region, see Endpoints.
   Database name	Required. The name of the target MaxCompute project. This is the name of your MaxCompute project, not your workspace. To find the project name, log on to the MaxCompute console, switch to the correct region in the upper-left corner, and then click Workspace > Project Management. You can find the project name on the Project Management page.
   Username	Required. The AccessKey ID with permissions to access the target MaxCompute project. You can obtain the AccessKey ID from the AccessKey Management page.
   Password	Required. The AccessKey Secret for the specified AccessKey ID. You can obtain the AccessKey Secret from the AccessKey Management page.

6. Click Test Connection. After the Connection test successful! message appears, click Add.

7. Add the following IP addresses to the IP address whitelist of your MaxCompute project:

   183.240.92.0/24,111.45.0.0/22,14.215.188.4/25

   Note

   For more information about how to configure an IP address whitelist, see Configure an IP address whitelist. If you do not add these IP addresses, Sugar BI cannot read data from MaxCompute.

Step 2: Create a data model

After connecting to the data source, create a data model for visual data analysis. For more information, see data models.

Step 3: Visual data analysis

In the Sugar BI console, you can query and analyze data from your MaxCompute project by using the data source and data model you created. For example, you can create reports and dashboards. For detailed instructions, see Create a report and Create a Dashboard.