Quick BI:Azure data source: Azure Database for PostgreSQL

Limitations

This data source supports PostgreSQL 8.2 and later.

Procedure

1. Add IP addresses to the allowlist.

   Add the Quick BI IP addresses to the allowlist for your Azure Database for PostgreSQL instance. For details, see Firewall rules in Azure Database for PostgreSQL - Flexible Server.

2. Verify the data source connection and create the data source.

   1. Log in to the Quick BI console.

   2. Add a data source.

      1. Navigate to the data source creation page from an entry point for creating a data source.

      2. On the Azure tab, select Azure Database for PostgreSQL.

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

   Parameter	Description
   Display name	The display name of the data source in the console. The name cannot contain special characters or leading or trailing spaces.
   Database address and port	The public endpoint and port of your PostgreSQL instance, available in the Azure portal.
   Database	The name of the database to connect to.
   Schema	The name of the schema in your PostgreSQL database.
   Username and password	The credentials used to log in to the PostgreSQL database.
   SSL	Enables SSL encryption for data in transit. Select this option if your data source requires SSL.
   Initialize SQL	Specifies SQL statements that run automatically when a connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   Enable file upload	Allows users to upload files to this data source.

4. Click Test Connection.

   

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