AWS data source: RDS for PostgreSQL

Limitations

Supports PostgreSQL 8.2 and later.

Procedure

1. Add IP addresses to the whitelist.

   Add the Quick BI IP addresses to the whitelist of your AWS PostgreSQL instance. For more information about configuring the whitelist, see Control access with security groups.

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

   1. Log on to the Quick BI console.

   2. Follow these steps to add a data source:

      1. Open the data source creation page by following the instructions in Create Data Source Entry Points.

      2. On the AWS Database tab, select the RDS for PostgreSQL data source.

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

   Parameter	Description
   Display name	The name of the data source as it appears in the list. Enter a unique name. The name cannot contain special characters or leading or trailing spaces.
   Database host and port	The public endpoint of the PostgreSQL instance, which you can find on the instance details page in the Amazon RDS console. Example: xxxxxxxxxxxxxxxxx.rds.amazonaws.com. For more information, see Connecting to a DB instance running the PostgreSQL database engine.
   Database	The name of the database to connect to.
   Schema	The name of the schema in your PostgreSQL database.
   Username and password	The username and password to connect to the PostgreSQL database.
   SSL	If your data source uses SSL, select this option to encrypt the connection.
   Initialize SQL	Run specified SQL statements automatically after each connection is established. Only SET statements are allowed. Use a semicolon (;) to separate multiple statements.
   Enable uploading files	Allow file uploads to this data source.

4. Click Test Connection to verify the connection.

   

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