Add a Hologres Data Source

A Hologres instance is created. Purchase a Hologres instance.

To analyze data from an Alibaba Cloud Hologres database in Quick BI, add it as a data source. For more information about Hologres, see What is Hologres?.

Add Quick BI IP address ranges to your Hologres instance whitelist to prevent connection failures. Configure an IP address whitelist.

Limitations

• Only workspace administrators and developers can add data sources.

• Only Quick BI Professional Edition and Advanced Edition support adding Hologres data sources.

• Only the data warehouse edition of Hologres is supported.

Procedure

1. Configure an IP address whitelist.

   Add Quick BI IP addresses to your Hologres instance whitelist before connecting. Configure an IP address whitelist.

2. Test the connection and create the data source.

   1. Sign in to the Quick BI console.

   2. Add a data source:

      1. Go to the data source creation page. Create a data source.

      2. On the Alibaba Cloud databases tab, click Hologres.

         

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

   Parameter	Description
   Display name	Display name shown in the data source list. Cannot contain special characters or leading/trailing spaces.
   Database address and Port	Public endpoint of the Hologres instance. For VPC data sources, enter the internal endpoint and port. Find connection details in the Hologres management console > Basic Information. Example: xxxxxxxxxxxxxxx.hologres.aliyuncs.com. Endpoints.
   Database	Name of the database specified during Hologres instance creation. Find the Database Name on the Database Management page of the Hologres management console.
   Time zone	Time zone of the region where the Hologres instance is deployed.
   Schema	Schema name in the Hologres database.
   Username and Password	Database credentials. Use an AccessKey ID or a custom account with create, insert, update, and delete permissions on the tables.
   VPC data source	To connect over VPC (recommended), select VPC data source and set these parameters. Purchaser AccessId and Purchaser AccessKey: AccessKey pair of an account with read permissions on the instance. Create a custom RAM policy. Obtain the AccessKey pair from the RAM console. Obtain an AccessKey pair. Instance ID and Region: ID and region of the Hologres instance. Find the instance ID in the Hologres management console under Network Information. View instance details.
   SSL	Encrypts data in transit. Requires SSL to be enabled on the data source.
   Initial SQL	Specify SQL statements to run on each connection. Only SET statements are supported. Separate multiple statements with semicolons (;).
   Enable file upload	Allows uploading files to this data source.

4. Click Connection Test to verify the connection.

   

5. If the connection test is successful, click OK to add the data source.

Next Steps

With the data source connected, create datasets and analyze your data.

• Add tables or custom SQL queries from your Hologres database. Create and manage a dataset.

• Build visual charts and dashboards. Create a dashboard. Visual chart overview.

• Use drill-down for deeper analysis. Step 3: Configure and use drill-down.