Add a Data Lake Analytics data source to connect to the Alibaba Cloud Data Lake Analytics database and the Quick BI. After the connection is successful, you can analyze and display data on the Quick BI. This topic describes how to connect a Quick BI data source to Alibaba Cloud Data Lake Analytics Data Lake Analytics over the Internet.
Prerequisites
A DLA database is created.
The username and password that are used to access the DLA database are obtained.
Background information
If you are using an Alibaba Cloud Data Lake Analytics database, you can add a cloud data source Data Lake Analytics when connecting to the Quick BI for data analysis. For more information about Data Lake Analytics, see What is a Data Lake Analytics.
Limits
Only workspace administrators and developers can add data sources.
Connect to Alibaba Cloud Data Lake Analytics over the Internet
Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.
Before connecting to the Alibaba Cloud Data Lake Analytics over the Internet, add the Quick BI IP address to the whitelist of the Alibaba Cloud Data Lake Analytics. For more information about how to add an Alibaba Cloud Data Lake Analytics whitelist, see Create an endpoint.
Add a Hologres data source and verify that the data source can be connected.
After you log on to the Quick BI console.
Follow the instructions in the following figure to add a data source
Go to the Create Data Source page.
Select Alibaba Data Lake Analytics Data Source.
In the Add Data Lake Analytics Data Source dialog box, configure the following settings based on your business scenario.
Field
Description
Name
The name of the data source. The name is displayed in the data source list.
The name cannot contain special characters or start or end with spaces.
Database Address
Log on to the DLA console to view the database endpoint. Example: xxxxxxxxxxxxxxxxxxxx.datalakeanalytics.aliyuncs.com
For more information, see Overview.
Port
The port number corresponding to the deployment Data Lake Analytics database address.
Source Database
The name of the database that is customized when the Data Lake Analytics database is deployed.
Username
The username used to log on to the Data Lake Analytics database.
Password
The password used to log on to the Data Lake Analytics database.
Virtual Cluster Name
Log on to the DLA console and view the name of the virtual cluster on the Virtual Cluster Management page.
Click Test Connection to verify that the data source can be connected.
Click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add a data table in the Data Lake Analytics data source or a user-created SQL statement to the Quick BI, see Create and manage datasets.
You can add charts and analyze data. For more information, see Create a dashboard and Overview.
You can drill down and further analyze data. For more information, see Drilling, filter interaction, and hyperlink.