Add an User-created Vertica Data Source

Procedure

1. Log on to the Quick BI console.

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

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

   2. Click Show more.

      

   3. Select the Vertica data source.

      

3. On the Add Vertica Data Source page, fill in the required configuration.

   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	The address where the Vertica database is deployed, including IP or domain name.
   Port	The port number of the database that you want to access. Default value: 5433.
   Database	The name of the database that you want to access.
   Schema	The schema of the database. Default value: public.
   Username	The username that is used to connect to the database. Note Make sure that this username has the create, insert, update, or delete permission on the tables in the database.
   Password	The password that is used to access the database.
   VPC Data Source	Specifies whether to access the user-created data source over a VPC based on your business requirements. If you select VPC Data Source, you need to configure the following parameters: Buyer Accessid: The AccessKey ID of the purchaser of this instance. For more information, see obtain an AccessKey. Note Make sure that this AccessKey ID has the Read permission on the destination instance. If it also has the Write permission on the corresponding security group, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see create a custom policy. Buyer Accesskey: The AccessKey Secret of the purchaser of this instance. For more information, see obtain an AccessKey. Instance ID: The ID of the purchaser of this instance. Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see view instance information. Area: The area where this instance is located. For more information, see view instance information.
   SSH	Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, you need to configure the following parameters: SSH Host: The hostname or IP address. SSH Username: The SSH username that is used to connect to the database. SSH Password: The password of the SSH username that is used to connect to the database. SSH Port: The port number of the database that you want to access. Default value: 22. Note Only Quick BI Pro allows you to access user-created data sources over an SSH tunnel.

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

   

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