Connecting to a GaussDB(DWS) Data Source

Preparations

Do the following to check if an EIP or VPCEP security group is added:

1. Log in to the management console.
2. In the service list, choose EI Enterprise Intelligence > Data Warehouse Service.
3. Select a region in the upper left corner.
4. In the navigation pane on the left, choose Dedicated Clusters > Clusters.
5. Click the name of the cluster you want to connect to. The cluster details page is displayed.
6. On the displayed page, find the Network area and click the security group next to Security Group. Click the Inbound Rules tab and check if an EIP or VPCEP security group is added.
   • If yes, return to the DataArts Insight data source editing page to connect to the data source.
   • If no, perform the following steps to add a security group:
     1. Click Add Rule. In the displayed Add Inbound Rule dialog box, set the protocol, port, and source IP address.
     2. Confirm the parameter settings and click OK to return to the DataArts Insight page and connect to the data source.
     Note

     If the data source connection test fails after the security group is added, the possible cause is that SASL_SSL is not enabled for that data source.

Accessing a GaussDB(DWS) Data Source Through a Public Network

1. 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.
2. On the top of the console, click Projects and click the name of a desired project.
3. 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 GaussDB(DWS) and Access Network Type to Public network.
4. Set other parameters based on Table 1.

   Table 1 Parameters

   Parameter	Mandatory	Description
   Source Database Type	Yes	Type of the data source to be connected.
   Access Network Type	Yes	In this example, Public network is selected.
   Name	Yes	Name of the data source displayed in the list.
   Domain Name	Yes	IP address of the data source.
   Port	Yes	Port number for logging in to the database.
   Database	Yes	Name of the database to be logged in to.
   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 for logging in to the database.
   Password	Yes	Password for logging in to the database.

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

Accessing a GaussDB(DWS) Data Source Through a VPC Network

1. 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.
2. Click the name of the desired project in the My Projects area in the right pane.
3. 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 GaussDB(DWS) and Access Network Type to GaussDB(DWS).
4. Set other parameters based on Table 2.

   Table 2 Parameters

   Parameter	Mandatory	Description
   Source Database Type	Yes	Type of the accessed data source. In this example, GaussDB(DWS) is selected.
   Access Network Type	Yes	In this example, GaussDB(DWS) is selected.
   Region	Yes	Region where the GaussDB(DWS) 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.
   Instance	Yes	Role instance corresponding to the GaussDB(DWS) service.
   Servers	Yes	List of GaussDB(DWS) servers. NOTE: If the cluster is associated with an ELB, the ELB address will be automatically populated. However, if there is no ELB associated with the cluster, the IP address and port number of the first node will be used by default.
   Database	Yes	Name of the database to be logged in to.
   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 for logging in to the database.
   Password	Yes	Password for logging in to the database.

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