Add an AnalyticDB for PostgreSQL Data Source

Limits

• Only space administrators and developers are authorized to add data sources.

• The Professional Edition and Pro Edition of group space are required to create an AnalyticDB for PostgreSQL data source.

• Versions 6.0 and 4.3 are supported.

Procedure

1. Log on to the or the international Quick BI console.

2. Follow the steps in the figure below to add a data source.

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

   2. Choose the Alibaba AnalyticDB for PostgreSQL data source.

      

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

   Name	Description

   Name	Description
   Display Name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address and Port	The external address of the AnalyticDB for PostgreSQL database deployment (if using a VPC data source, fill in the internal address and internal port of the database deployment). Log on to the cloud-native data warehouse AnalyticDB PostgreSQL edition console to obtain the database address. Example: xxxxxxxxxxxxxxxxxxxxx.gpdb.rds.aliyuncs.com. See client connection.
   Database	The custom database name when deploying the AnalyticDB for PostgreSQL database cluster. Log on to the PolarDB console, and in Database Management, obtain the Database Name.
   Schema	The schema of the database that you want to access.
   Username and Password	The username and password for logging on to the AnalyticDB for PostgreSQL database cluster.
   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 access privileges to the destination AnalyticDB for PostgreSQL database. Ensure that the account has Read privileges for the destination instance. Additionally, if Write privileges are granted, the system will automatically add the whitelist. Otherwise, you need to add it manually. For related operations, see create a custom policy. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. Instance ID and Area: The AnalyticDB for PostgreSQL database cluster ID and the area where it is located. Log on to the cloud-native data warehouse AnalyticDB PostgreSQL edition console to obtain the instance ID. Note If you select the VPC data source, the database address and port must be filled in with the internal address and internal port.
   SSL	If the destination data source is configured with SSL, you can select the secure protocol SSL to protect data security.
   Initialize SQL	After enabling, you can configure the SQL statement that is executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement executed after each data source connection is initialized. Separate statements with periods.
   Enable file upload entry	After enabling, file upload is supported.

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

   

5. Once the test is successful, click OK.