User-created Impala data source

Procedure

1. Log on to the Quick BI console.

2. Add the data source:

   1. Navigate to the data source creation page using an entry point for creating a data source.

   2. On the User-Created Data Source tab, click Impala.

3. In the Configure Connection dialog box, configure the following parameters.

   Parameter	Description
   Display name	The display name shown in the data source list. Enter a name without special characters or leading or trailing spaces.
   Database Address and Port	The endpoint of your Impala database. You can enter an IP address or a domain name.
   Port	The port used to connect to the database. Default: 21050.
   Database	The name of the database you want to connect to.
   Database version	The database version. Versions 2.x and 3.x are supported.
   Username and Password	The username and password for the database. The user must have CREATE, INSERT, UPDATE, and DELETE permissions on the database tables.
   VPC data source	Select this option if your data source is in an ECS VPC. When VPC Data Source is selected, configure the following parameters: Purchaser AccessKey ID: The AccessKey ID of the account that purchased the instance. For more information, see Create an AccessKey pair. Note The AccessKey ID must have Read permissions on the target instance. If the AccessKey ID also has Write permissions on the corresponding security group, Quick BI automatically adds its IP addresses to the whitelist. Otherwise, you must manually add them. For more information, see Create a custom policy. Purchaser AccessKey Secret: The AccessKey Secret of the account that purchased the instance. For more information, see Create an AccessKey pair. Instance ID: The ID of the ECS instance. You can obtain the instance ID on the Instances page of the ECS console. For more information, see View instance information. Region: The region where the instance is located. For more information, see View instance information.
   SSL	If your data source uses SSL, select the SSL checkbox to encrypt data in transit.
   SSH	Select this option to connect to your data source through an SSH tunnel. When SSH is selected, configure the following parameters: SSH host: The hostname or IP address of the SSH server. SSH username: The username for the SSH connection. SSH password: The password for the SSH user. SSH port: The port for the SSH connection. Default: 22. Note Connecting to a user-created data source through an SSH tunnel is supported only in Quick BI Pro workspaces.
   Auth	If you select this option, you must enter a Username and Password.
   Initial SQL	SQL statements that are automatically executed after a connection to the data source is established. Only SET statements are allowed. Separate multiple statements with semicolons (;). Do not use line breaks.

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

   

5. After the test succeeds, click OK to add the data source.