This topic describes how to 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
    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.