Quick BI:Add an user-created Impala 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 via the data source creation entry.

   2. Click Show more.

      

   3. Select the Impala data source.

      

3. In the Add Impala Data Source dialog box, fill in the required fields.

   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 Impala database is deployed, including the IP address or domain name.
   Port	The port number of the database. Default value: 21050.
   Database	The name of the database that you want to access.
   Database Version	Select the database version. Versions 2.x and 3.x are supported.
   Username and Password	The username and password that are used to access the database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.
   VPC Data Source	Specifies whether to access the data source over a VPC based on your business requirements. If you select VPC Data Source, you must 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 the AccessKey ID has the Read permission on the destination instance. If the AccessKey ID also has the Write permission on the corresponding security group, the system automatically adds the whitelist. Otherwise, you must manually add the whitelist. 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.
   SSL	If the destination data source is configured with SSL, you can also select SSL in the security protocol to protect data security when connecting to the destination database.
   SSH	Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, you must configure the following parameters: SSH Host: The hostname or IP address. SSH Username: The SSH username that is used to access the database. SSH Password: The password of the SSH username that is used to access the database. SSH Port: The port number of the database. Default value: 22. Note Only Quick BI Enterprise Standard allows you to access user-created data sources in group workspaces over SSH tunnels.
   Auth	You need to enter the Username and Password only if this option is selected.
   Initialize SQL	After this option is enabled, you can configure the SQL statements that are executed to initialize the data source connection. Only SET statements are allowed in the SQL statements that are executed to initialize the data source connection. The statements must be separated by semicolons and cannot contain line breaks.

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

   

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