Connect to an AWS Redshift data source

Procedure

1. Add IP addresses to the whitelist.

   Before connecting to Redshift, add the Quick BI IP addresses to the Redshift whitelist.

2. Go to the data source creation page as described in Create a data source.

3. On the AWS Databases tab, select Redshift.

4. In the Configure Connection dialog box, configure the parameters.

   Parameter	Description
   Display name	The display name for this data source. The name must not contain special characters or leading or trailing spaces.
   Database address	The public endpoint of your Redshift cluster. To find this address, log on to the Amazon RDS console, click your database, and locate the endpoint on the Connectivity & security tab. For example: xxxxxxxx.redshift.amazonaws.com.
   Port	The port number for the database. Default: 5439.
   Database	The name of the database.
   Schema	The name of the schema. Default: public.
   Username and password	The username and password for your Redshift database. Note The database user must have create, insert, update, and delete permissions on the database tables.
   SSL	Enable this option if your data source requires an SSL connection.

5. Click Test Connection to verify the connection.

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