×
Community Blog Starter Guide | Build BI Dashboard By PostgreSQL, Cube and React in One Click

Starter Guide | Build BI Dashboard By PostgreSQL, Cube and React in One Click

This tutorial describes you how to build a BI Dashboard with Cube, React and RDS for PostgreSQL on Alibaba Cloud.

This article focuses on one-click deployment through the Alibaba Cloud console. If you need to use scripting for automated deployment, you can refer to this article that uses Terraform.

Overview

Cube is the headless API layer that connects cloud data warehouses to your front end code so you can build data applications faster.

Billing Instructions

The expenses on BI Dashboard mainly involve:

  1. Selected vCPU and memory specifications
  2. System disk type and capacity
  3. Public network bandwidth
  4. ApsaraDB RDS for PostgreSQL specifications and storage space

Deployment Architecture

1

Parameter Description

Parameter Group Parameter item Illustrate
Service Instance Service Instance Name The name can be up to 64 characters in length, and can contain digits, letters, hyphens (-), and underscores (_). The name must start with a letter.
Region The region where the service instance is deployed.
Instance Charge Type Charge type for the service instance.
ECS instance configuration Instance Type ECS instance type
Instance Password Server login password, Length 8-30, must contain three(Capital letters, lowercase letters, numbers, ()`~!@#$%^&*_-+={}[]:;'<>,.?/ Special symbol in)
network configuration Availability Zone The availability zone where the ECS instance is located
VPC ID VPC where resources are located
VSwitch ID The availability zone of the VSwitch
PostgreSQL configuration Instance specifications The specifications of PostgreSQL instances that can be used in the availability zone
Storage Instance Storage

Permissions Required

Deploying this service instance requires accessing and creating some Alibaba Cloud resources. Therefore, your account needs to include permissions for the following resources.

Note: You only need to add this permission when your account is a RAM account.

Permission policy name Remarks
AliyunECSFullAccess Permission to manage cloud server service (ECS)
AliyunVPCFullAccess Permission to manage private network (VPC)
AliyunROSFullAccess Permission to manage Resource Orchestration Service (ROS)
AliyunComputeNestUserFullAccess Manage user-side permissions for the ComputeNest service (ComputeNest)
AliyunPostgreSQLFullAccess Manage permissions for cloud database services (PostgreSQL)

Deployment Steps

1.  Visit Deployment Link and fill in the deployment parameters as prompted: Deployment link

2

2.  After filling in the deployment link parameters, you can see the corresponding inquiry details. After confirming the parameters, click Next step: Confirm the order.

3

3.  After confirming the completion of the order, agree to the service agreement and click Create Now to enter the deployment phase.

4

4.  Wait for deployment to complete before entering service instance management.

5.  Find CubeJs and Dashboard links in the console and copy them to the browser to access them.

5
6
7

Reference Documents

https://github.com/alibabacloud-howto/opensource_with_apsaradb/blob/main/cubejs/postgresql/README.md

0 1 0
Share on

ApsaraDB

397 posts | 81 followers

You may also like

Comments