Quick BI:Huawei Cloud PostgreSQL data source

Limitations

This data source supports PostgreSQL 8.2 and later.

Procedure

1. Add IP addresses to the whitelist.

   To connect to the Huawei Cloud PostgreSQL database, add the Quick BI IP addresses to the database whitelist.

2. Create the data source.

   1. Log on to the Quick BI console.

   2. Follow these steps to add the data source:

      1. Go to the data source creation page. For more information, see Create a data source.

      2. On the Huawei Cloud Database tab, select the PostgreSQL data source.

3. In the Configure Connection dialog box, set the following parameters.

   Parameter	Description
   display name	The display name of the data source in the Quick BI console. Do not use special characters or leading/trailing spaces.
   database address and port	The public IP address of the PostgreSQL instance. To obtain this address, log on to the Huawei Cloud console, go to the basic information page of the instance, and bind an elastic IP address. You can then find the address on the elastic IP address page.
   database	The name of the database to connect to.
   schema	The name of the schema in the PostgreSQL database.
   username and password	The username and password for the PostgreSQL database.
   SSL	Select this option to enable SSL encryption for data in transit.
   initial SQL	SQL statements that run automatically after a connection is established. Only SET statements are allowed. Separate multiple statements with semicolons (;).
   Enable file upload	Enables file uploads to this data source.

4. Click test connection to verify the connection parameters.

   

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