Quick BI:Add a RedShift Data Source

Procedure

1. Add IP addresses to the whitelist.

   Before connecting to RedShift, you need to add the IP addresses of Quick BI to the RedShift whitelist.

2. Access the create data source interface from the create data source entry.

3. On the AWS Database tab, select RedShift data source.

4. In the Configure Connection dialog box, complete the configuration based on your business scenario.

   Name	Description
   Display name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
   Database address	The public endpoint of the deployed RedShift database cluster. Log on to the Amazon RDS console, click the corresponding database in the database list to access the details page, and obtain the endpoint name from the "Connectivity & security" tab. This is the database address, for example: xxxxxxxx.redshift.amazonaws.com.
   Port	The port number of the database. The default port is 5439.
   Database	The name of the database to be connected.
   Schema	The name of the schema to be connected. The default schema is public.
   Username and Password	The username and password used to log on to the RedShift database. Note Make sure that the user who logs on to the RedShift database has the create, insert, update, and delete permissions on tables in the database.
   SSL	If the target data source has SSL configured, you can select the SSL security protocol to protect data security.

5. Click Test Connection to test the connectivity of the data source.

6. After the test is successful, click OK to complete adding the data source.