Connecting to a PostgreSQL Data Source

Preparations

Accessing a PostgreSQL Data Source Through a Public Network

1. Log in to the DataArts Insight console.
2. Click in the upper left corner of the management console to select a region and select an enterprise project from Enterprise Project in the upper right corner of the Workspace page.
3. On the top menu of the console, click Project. On the displayed My Projects page, click the name of the desired project.
4. In the navigation pane on the left, choose Data Management > Data Sources. On the displayed page, click Create Data Source. In the slide-out panel, set Source Database Type to PostgreSQL and Access Network Type to Public network.
5. Set other parameters based on Table 1.
   Figure 1 Connecting to a PostgreSQL data source
   

   Table 1 Parameters

   Parameter	Mandatory	Description
   Source Database Type	Yes	Type of the data source to be connected.
   Access Network Type	Yes	Select Public network for GaussDB(DWS) instances with public IP addresses, not restricted by account, region, or other limitations.
   Name	Yes	Name the current data connection for easier subsequent use and configuration.
   Domain Name	Yes	Public IP address or domain name bound to the target data source, which can be obtained from the public IP address in the Connection Information area on the GaussDB(DWS) instance details page.
   Port	Yes	External port of the target data source on the corresponding node, which can be obtained from the port number in the Connection Information area on the GaussDB(DWS) instance details page.
   Database	Yes	Select the database in the target data source based on service requirements.
   SASL_SSL	N/A	It is used for trusted identity authentication and secure data transmission when DataArts Insight retrieves data from the data source. This function is enabled by default.
   Username	Yes	Username used for connection authentication.
   Password	Yes	Password used for connection authentication.

6. Click Test Connection to test the data source connectivity.
7. Once the test is successful, click OK.

Accessing a PostgreSQL Data Source Through a VPC Network

1. Log in to the DataArts Insight console.
2. Click in the upper left corner of the management console to select a region and select an enterprise project from Enterprise Project in the upper right corner of the Workspace page.
3. On the top menu of the console, click Project. On the displayed My Projects page, click the name of the desired project.
4. In the navigation pane on the left, choose Data Management > Data Sources. On the displayed page, click Create Data Source. In the slide-out panel, set Source Database Type to PostgreSQL and Access Network Type to RDS.
5. Set other parameters based on Table 2.
   Figure 2 Parameters for connecting to a PostgreSQL cloud data source
   

   Table 2 Parameters

   Parameter	Mandatory	Description
   Source Database Type	Yes	Type of the accessed data source. In this example, PostgreSQL is selected.
   Access Network Type	Yes	In this example, RDS is selected.
   Region	Yes	Region where the PostgreSQL service host is located.
   Name	Yes	Name of the data source displayed in the list.
   Description	No	Description of the data source.
   Instance	Yes	Role instance corresponding to RDS for PostgreSQL.
   Host	Yes	Host where RDS for PostgreSQL is located.
   Port	Yes	Port of RDS for PostgreSQL.
   Database	Yes	Name of the database to be logged in to.
   Username	Yes	Username for logging in to the database.
   Password	Yes	Password for logging in to the database.
   SASL_SSL	N/A	It is used for trusted identity authentication and secure data transmission when DataArts Insight retrieves data from the data source. This function is enabled by default.

6. Click Test Connection to test the data source connectivity.
7. Once the test is successful, click OK.

Connecting to a PostgreSQL Data Source Through a VPC Endpoint Service

VPCEP enables connections to data sources using the VPCEP service name, offering flexible data access and addressing issues related to cross-account access and self-built data source access for ECS. Furthermore, the same main account and its IAM users can share a single connection channel, streamlining connection management. The existing access method eliminates the need for permission delegation, further simplifying operations.

• Prerequisites
  • Connection Approval has been enabled on the basic information page of the VPCEP service. For details, see Viewing a VPC Endpoint Service.
  • You have whitelisted the VPCEP service by adding its domain ID to the whitelist. For details, see Managing Whitelist Records of a VPC Endpoint Service. You can obtain the domain ID in the Create Data Source dialog box.
    Figure 3 Obtaining the domain ID
    

• Procedure
  1. Log in to the DataArts Insight console.
  2. Click in the upper left corner of the management console to select a region and select an enterprise project from Enterprise Project in the upper right corner of the Workspace page.
  3. On the top menu of the console, click Project. On the displayed My Projects page, click the name of the desired project.
  4. In the navigation pane on the left, choose Data Management > Data Sources. On the displayed page, click Create Data Source. In the slide-out panel, set Source Database Type to PostgreSQL and Access Network Type to VPC Endpoint Service.
  5. Set other parameters based on Table 3.
     Figure 4 Connection through a VPCEP service
     

     Table 3 Parameters

     Parameter	Mandatory	Description
     Source Database Type	Yes	Type of the accessed data source. In this example, PostgreSQL is selected.
     Access Network Type	Yes	Select VPC Endpoint Service.
     Region	Yes	Region where the PostgreSQL service host is located.
     Name	Yes	Name of the data source displayed in the list, which is user-defined.
     Description	No	Description of the data source.
     VPC Endpoint Service	Yes	Name of the VPCEP service to be connected. The prerequisites for connecting to a VPCEP service are as follows: You have obtained the correct VPCEP service name. For details, see Checking a VPC Endpoint Service. You have whitelisted the VPCEP service by adding its domain ID to the whitelist. For details, see Managing Whitelist Records of a VPC Endpoint Service.
     Verify	N/A	After entering the VPCEP service name, click Verify. If a green tick is displayed next to the VPC endpoint ID, the verification is successful. If a red exclamation mark () is displayed next to the VPC endpoint ID, the VPCEP service is connected to for the first time. In this case, you need to authorize the VPCEP service. To do so, log in to the VPCEP console. Under Network Console, choose VPC Endpoint > VPC Endpoint Services. On the displayed page, click the desired VPCEP service and click the Connection Management tab. On the tab page, authorize the VPCEP service. For details, see Managing Connections of a VPC Endpoint Service. Once the authorization is successful, click Verify again. The verification is successful. NOTE: All initial connections to the VPCEP service from different data sources require approval. Only an administrator account or an account with administrator permissions can approve the connection. If your current account does not have approval permissions, contact an administrator account for approval.
     VPC Endpoint ID	Yes	This parameter is automatically filled in once you entered the VPCEP name and clicked Verify.
     Port	Yes	Port number for logging in to the database.
     Database	Yes	Name of the database to be logged in to.
     Username	Yes	Username for logging in to the database.
     Password	Yes	Password for logging in to the database.
     SASL_SSL	N/A	It is used for trusted identity authentication and secure data transmission when DataArts Insight retrieves data from the data source. This function is enabled by default.

  6. Click Test Connection to test the data source connectivity.
  7. Once the test is successful, click OK.