All Products
Search
Document Center

Quick BI:Add a DLA Data Source

Last Updated:Jan 25, 2024

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

  1. 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.

  2. Add a Hologres data source and verify that the data source can be connected.

    1. After you log on to the Quick BI console.

    2. Follow the instructions in the following figure to add a data source

      1. Go to the Create Data Source page.

      2. Select Alibaba Data Lake Analytics Data Source.

        image

  3. 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.

  4. Click Test Connection to verify that the data source can be connected.

    image

  5. Click OK.

What to do next

After you add a data source, you can create a dataset and analyze data.