Add a Hologres data source in DataV - DataV - Alibaba Cloud Documentation Center

This document explains how to add and utilize a Hologres data source within DataV.

Prerequisites

Ensure you have a Hologres data source ready to add.

Important

You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.

Limits

Supports only Enterprise Edition or higher.

Add a Hologres data source

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
From the Type list, select Hologres.
Choose the region where your instance is located from the list, selecting Intranet.

Select the network type for the intranet database, which includes Virtual Private Cloud (VPC) and Classic Network.

Virtual Private Cloud (VPC)

Activate the VPC switch to switch to VPC mode.

Enter the database information.

Parameter	Description
VPC ID	The VPC ID of the specified VPC to which the Hologres instance is attached. Go to the Hologres Management Console product page, and obtain the VPC ID from the Network Information column of the specified VPC in the Scenarios section.
VPC instance ID	The instance ID generated after the Hologres instance is attached to the specified VPC. Go to the Hologres Management Console product page, and obtain the instance ID from the Network Information column of the specified VPC in the Scenarios section.
Name	The display name of the data source. You can specify a custom name.
Domain name	The domain name of the Hologres instance. Go to the Hologres Management Console product page, and obtain the domain name from the Network Information column of the specified VPC in the Domain Name section.
Username	The AccessKey ID of the account used to log on to the Hologres instance.
Password	The AccessKey Secret of the account used to log on to the Hologres instance.
Port	The port number of the VPC in which the Hologres instance resides. Go to the Hologres Management Console product page, and obtain the port number from the Network Information column of the specified VPC in the Domain Name section.
Database	The name of the selected database.

The system will automatically test the connection to confirm database accessibility once the information is entered.

Important
Should an error message Access VPC instance fail appear during the test, try appending the suffix -1 to the Instance ID and test the connection again.

Classic Network

Deactivate the VPC switch to enter Classic Network mode.

Enter the database information.

Parameter	Description
Name	The display name of the data source. You can specify a custom name.
Domain name	The domain name of the Hologres instance. Go to the Hologres Management Console product page, and obtain the domain name from the Network Information section of the classic network domain name.
Username	The AccessKey ID of the account used to log on to the Hologres instance.
Password	The AccessKey Secret of the account used to log on to the Hologres instance.
Port	The port number of the classic network endpoint used by the Hologres instance. Go to the Hologres Management Console product page, and obtain the port number from the Network Information section of the classic network domain name.
Database	The name of the selected database.

The system will automatically test the connection to confirm database accessibility once the information is entered.

Important
Should an error message Access VPC instance fail appear during the test, try appending the suffix -1 to the Instance ID and test the connection again.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will be automatically displayed in the data source list.

Add a data source through the Internet

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
From the Type list, select Hologres.
Choose Internet from the list.

Enter the database information.

Parameter	Description
Name	The display name of the data source. You can specify a custom name.
Domain name	The domain name of the Hologres instance. Go to the Hologres Management Console product page, and obtain the domain name from the Network Information section of the public domain name.
Username	The AccessKey ID of the account used to log on to the Hologres instance.
Password	The AccessKey Secret of the account used to log on to the Hologres instance.
Port	The port number of the public endpoint used by the Hologres instance. Go to the Hologres Management Console product page, and obtain the port number from the Network Information section of the public domain name.
Database	The name of the selected database.

The system will automatically test the connection to confirm database accessibility once the information is entered.

Once the connection test succeeds, click OK to finalize the data source addition.

The new data source will be automatically displayed in the data source list.

What to do next

Once you have the raw data, you can consult datasource config for widget data adaptation.

FAQ

For additional questions, consult the FAQ about datasource config.