Connect Alibaba Cloud Quick BI to AnalyticDB for PostgreSQL

Procedure

1. Log on to the Quick BI console.
2. In the top navigation bar, click Workspace.
3. In the left-side navigation pane of the Workspace page, click Data Sources.
4. In the upper-right corner, click Create Data Source. In the dialog box that appears, choose Add Data Source > AnalyticDB for PostgreSQL.
5. In the Add AnalyticDB for PostgreSQL Database dialog box that appears, set parameters.
   Note

   • Add the following IP addresses to a whitelist of your AnalyticDB for PostgreSQL instance to allow access from Quick BI: 10.152.69.0/24, 10.152.163.0/24, and 139.224.4.0/24.
   • For more information about how to configure a whitelist, see Configure an IP address whitelist for an AnalyticDB for PostgreSQL instance.
   

   Parameter	Description
   Name	The name of the data source.
   Database Address	The endpoint used to connect to the AnalyticDB for PostgreSQL database. For more information, see Endpoints.
   Port Number	The port number that corresponds to the endpoint.
   Database	The name of the AnalyticDB for PostgreSQL database you want to connect.
   Schema	The name of the database schema.
   Username	The username used to connect to the AnalyticDB for PostgreSQL database.
   Password	The password used to connect to the AnalyticDB for PostgreSQL database.

6. After you have configured the preceding parameters, click Test Connection. After the data source connection is verified, click Add.
   Note If the data source connection fails, check whether all parameters are correctly configured. After you confirm that the parameters are correctly configured, test the connection again.

Use Quick BI

After you connect to the data source of AnalyticDB for PostgreSQL, follow these steps to complete operations such as report analysis in Quick BI.

• Create a dataset.
• Create a dashboard.
• Create a workbook.
• Create a portal.