All Products
Search
Document Center

Quick BI:Add an Alibaba PolarDB distributed edition data source

Last Updated:Sep 28, 2023

This topic describes how to add an Alibaba PolarDB distributed edition (formerly known as DRDS or PolarDB-X) data source. Only the Professional Edition allows you to add Alibaba PolarDB data sources.

Prerequisites

  • An Alibaba PolarDB distributed edition database is created.

  • The username and password of the Alibaba PolarDB distributed edition database are obtained.

Procedure

  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 you connect to Alibaba PolarDB Distributed Edition, you must add the Quick BI IP address to the whitelist of Alibaba PolarDB Distributed Edition. For more information about how to add an Alibaba PolarDB distributed edition whitelist, see Set a whitelist.

  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 these steps to add a data source.

      1. Go to the Create Data Source page.

      2. Click Show More.

        image
      3. Select Alibaba PolarDB Distributed Edition.

        image.png
  3. In the Configure Connection dialog box, configure the following settings based on your business requirements.

    Component

    Description

    Display 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

    The public endpoint for deploying the PolarDB distributed edition database. If you use a VPC data source, you must enter the internal endpoint and port of the database.

    Log on to the cloud-native Distributed Database console to obtain the database address. Example: xxxxxxxxxxxxxxxxxxxxxx.drds.aliyuncs.com.

    For more information, see View database information.

    Port

    The corresponding port number of the database.

    Username and Password

    The username and password that are used to access the database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.

    VPC data source

    If you use a VPC, select VPC Data Source and set the following parameters:

    • AccessKey ID and AccessKey secret: the AccessKey ID and AccessKey secret that have the permissions to manage the destination MySQL database.

      Log on to the RAM console and obtain the AccessKey ID and AccessKey secret.

    • Instance ID and Region: the ID and region of the MySQL database.

  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.