This topic describes how to connect DataV to a Hologres instance and use DataV to present data.
Background information
DataV is a BI service that Alibaba Cloud provides to help you present data. On the graphical interface of the service, you can use templates to create data visualization projects and drag and drop elements to edit the projects. DataV can fulfill your diversified data presentation requirements.
Hologres is deeply integrated with DataV. You can connect DataV to a Hologres instance and then present data in a visualized manner.
Procedure
-
Connect DataV to a Hologres instance.
You can connect DataV to a Hologres instance in three ways: over a virtual private cloud (VPC), the internet, or a classic network. For more information about these network types, see Instance details. We recommend connecting over a VPC.
NoteTo connect to a Hologres instance over a VPC, first bind the instance to a specific VPC. This generates a VPC endpoint. For more information, see Instance details.
-
Log on to the DataV console . In the left-side navigation pane, click Data Sources. On the Data Sources page, click Add Source.
-
In the Add Data Source dialog box, configure the parameters based on your network type, and then click OK. For example, to connect over a classic network, set Type to Hologres and Network to intranet. Select a Region such as China (Shenzhen). Then, turn off the VPC switch, and specify the Name, classic network endpoint, Username, Password, and Port. In the Database field, click Get Data List and select the target database.
-
Connect to a Hologres instance over a specified VPC
Parameter
Description
Instructions
Type
Select Hologres.
N/A
Network
Select intranet.
N/A
Region
The region where your Hologres instance is located.
N/A
VPC
Turn on the VPC switch.
N/A
VPC ID
The ID of the VPC that the Hologres instance is bound to.
Go to the Hologres console and open the instance details page. In the Network Information section, find the VPC ID in the Scenario column.
Instance ID
The ID generated when the Hologres instance is bound to the VPC.
Go to the Hologres console and open the instance details page. In the Network Information section, find the instance ID in the Scenario column.
Name
A custom name for the data source to help you identify it.
N/A
VPC endpoint
The VPC endpoint of the Hologres instance.
Go to the Hologres console and open the instance details page. In the Network Information section, find the VPC endpoint in the Domain Name column.
Username
The AccessKey ID of your Alibaba Cloud account.
You can obtain your AccessKey ID from the AccessKey Management page.
Password
The AccessKey secret of your Alibaba Cloud account.
You can obtain your AccessKey secret from the AccessKey Management page.
Port
The port used by the VPC endpoint.
Go to the Hologres console and open the instance details page. In the Network Information section, find the port number in the Domain Name column.
Database
The name of the database that you want to connect to.
N/A
-
Connect to a Hologres instance over the Internet
Parameter
Description
Instructions
Type
Select Hologres.
N/A
Network
Select internet.
N/A
Name
A custom name for the data source to help you identify it.
N/A
Internet endpoint
The internet endpoint of the Hologres instance.
Go to the Hologres console and open the instance details page. In the Network Information section, find the internet endpoint in the Network Information column.
Username
The AccessKey ID of your Alibaba Cloud account.
You can obtain your AccessKey ID from the AccessKey Management page.
Password
The AccessKey secret of your Alibaba Cloud account.
You can obtain your AccessKey secret from the AccessKey Management page.
Port
The port used by the internet endpoint.
Go to the Hologres console and open the instance details page. In the Network Information section, find the port number for the internet endpoint in the Network Information column.
Database
The name of the database that you want to connect to.
N/A
-
Connect to a Hologres instance over the classic network
Parameter
Description
Instructions
Type
Select Hologres.
N/A
Network
Select intranet.
N/A
Region
The region where your instance is located.
N/A
Name
A custom name for the data source to help you identify it.
N/A
Classic network endpoint
The classic network endpoint of the Hologres instance.
Go to the Hologres console and open the instance details page. In the Network Information section, find the classic network endpoint in the Network Information column.
Username
The AccessKey ID of your Alibaba Cloud account.
You can obtain your AccessKey ID from the AccessKey Management page.
Password
The AccessKey secret of your Alibaba Cloud account.
You can obtain your AccessKey secret from the AccessKey Management page.
Port
The port used by the classic network endpoint.
Go to the Hologres console and open the instance details page. In the Network Information section, find the port number for the classic network endpoint in the Network Information column.
Database
The name of the database that you want to connect to.
N/A
-
-
-
Present data in a visualized manner.
After connecting DataV to your Hologres instance, you can visualize and analyze your data. To get started, create a project from a template or a blank canvas. For more information, see Create a visualization application (for existing templates) or Create a visualization application (for blank canvases).