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
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.
Add a Hologres data source and verify that the data source can be connected.
After you log on to the Quick BI console.
Follow these steps to add a data source.
Go to the Create Data Source page.
Click Show More.
Select Alibaba PolarDB Distributed Edition.
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.
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 from an Alibaba PolarDB distributed edition data source or a user-created custom SQL 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.