Aurora PostgreSQL data source

Limitations

Version 15.4 is supported.

Procedure

1. Add to the allowlist.

   To connect to Aurora PostgreSQL, add the Quick BI IP addresses to its allowlist.

2. Go to the page for creating a data source. For more information, see Create a data source.

3. On the AWS databases tab, select the Aurora PostgreSQL data source.

4. In the Configure Connection dialog box, configure the following parameters based on your business needs.

   Parameter	Description
   Display name	The display name for the data source, shown in the data source list. The name cannot contain special characters or leading or trailing spaces.
   Database address	The public endpoint of the Aurora PostgreSQL database cluster. To obtain the address, log in to the Amazon RDS console, select your database, and on the Connectivity & security tab, copy the endpoint, for example, xxxxxxxx.rds.amazonaws.com. For more information, see Create and connect to an Aurora PostgreSQL DB cluster.
   Port	The database port number. Default: 5432.
   Database	The name of the target database.
   Schema	The name of the target schema.
   User name and password	The user name and password for the Aurora PostgreSQL database. Note The user must have create, insert, update, and delete permissions on the tables in the database.
   Initialization SQL	SQL statements to run after the connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   SSL	Enable this option if your data source requires an SSL connection.

5. Click Test Connection to verify the connection.

6. After the connection test is successful, click OK to add the data source.