Quick BI:Add an RDS for PostgreSQL Data Source

Limits

• Only space administrators and developer accounts have permission to add data sources.

• The service supports PostgreSQL version 8.2 and later.

Procedure

1. Log on to the Quick BI console.

2. To add a data source, follow these steps:

   1. Navigate to the data source creation page via the data source creation entry.

   2. On the Alibaba Cloud Database tab, select RDS PostgreSQL data source.

3. In the Configure Connection dialog box, configure the connection settings according to your business needs.

   Name	Description
   Display Name	The display name of the data source, shown in the data source list. The name cannot contain special characters or start or end with spaces.
   Database Address and Port	The external address and port of the PostgreSQL database. For a VPC data source, enter the internal address and port instead. Log on to the RDS Management Console, and in the Basic Information section, click to view connection details and obtain the database address. Example: rm-xxxxxxxxxxxxxxxxxx.pg.rds.aliyuncs.com. If the external address is not displayed on your interface, click Request External Address to obtain the address and port. For more information, see View or Modify Connection Address and Port.
   Database	The database name specified when you created the PostgreSQL database. Log on to the RDS Management Console, and in Database Management, obtain the Database Name.
   Schema	The schema of the PostgreSQL database.
   Username and Password	The username and password used to connect to the PostgreSQL database.
   VPC Data Source	When using the Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters: Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret with management permissions for the target PostgreSQL database. Ensure that the account has Read permissions for the target instance. If Write permissions are also granted, the system will automatically add the whitelist. Otherwise, you need to add it manually. For more information, see Create a Custom Policy. Log on to the RAM Console to obtain the AccessKey ID and AccessKey Secret. For more information, see View RAM User AccessKey Information. Instance ID and Region: The instance ID and region of the PostgreSQL database. Log on to the RDS Management Console, and obtain the instance ID in the Basic Information section. Note When selecting VPC Data Source, the database address and port must be the internal address and port.
   SSL	If SSL is configured on the target data source, enable this option to encrypt the connection.
   Initialize SQL	SQL statements executed after each connection to the data source. Only SET statements are allowed, separated by semicolons.
   Enable File Upload	Enable this option to allow file uploads to the data source.

4. Click Connection Test to verify the data source connectivity.

   

5. Once the test is successful, click OK to finalize the addition of the data source.