After you add an ApsaraDB for OceanBase data source that connects an ApsaraDB for OceanBase database to Quick BI, you can analyze and view data in the database in the Quick BI console. Quick BI allows you to access ApsaraDB for OceanBase over the Internet or a virtual private cloud (VPC). This topic describes how to add an ApsaraDB for OceanBase data source in a group workspace.
Prerequisites
An ApsaraDB for OceanBase cluster is created and a tenant is created in the ApsaraDB for OceanBase cluster. For more information, see Create a cluster and Create a tenant.
Context
If you want to analyze data of an ApsaraDB for OceanBase database in the Quick BI console, you can add an ApsaraDB for OceanBase data source. For more information about ApsaraDB for OceanBase, see What is OceanBase Database.
If an IP address whitelist is configured for the data source and the CIDR blocks of Quick BI are not added to the IP address whitelist, Quick BI cannot access the data source. To prevent this issue, add the CIDR blocks of Quick BI that are used in different network environments to the IP address whitelist. For more information about how to configure an IP address whitelist, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.
Limits
Only workspace administrators and developers can add data sources.
Access ApsaraDB for OceanBase over the Internet
Add the CIDR blocks of Quick BI to the IP address whitelist of ApsaraDB for OceanBase.
Before you access the ApsaraDB for OceanBase database over the Internet, you must add the CIDR blocks of Quick BI to the IP address whitelist of ApsaraDB for OceanBase. The CIDR blocks of Quick BI are
11.193.158.0/24, 11.193.162.0/24, 47.74.161.0/24, and 47.74.162.0/24. For more information about how to add CIDR blocks to the IP address whitelist of ApsaraDB for OceanBase.Add an ApsaraDB for OceanBase data source and verify that the data source can be connected.
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add an ApsaraDB for OceanBase data source.
In the Add OceanBase Data Source dialog box, configure the parameters.
Parameter
Description
Name
The name of the data source. The name is displayed in the data source list. You can specify a custom name.
The name can contain letters, digits, underscores (_), and hyphens (-).
Database Address and Port Number
The public endpoint and port number of the ApsaraDB for OceanBase database.
Database
The name of the database that is customized when you deploy the database.
Username and Password
The username and password that are used access the ApsaraDB for OceanBase database.
Mode
The tenant mode that is used when you deploy the ApsaraDB for OceanBase database. Valid values: MySQL Mode and Oracle Mode.
If the tenant mode of the database is MySQL, set Mode to MySQL Mode.
If the tenant mode of the database is Oracle, set Mode to Oracle Mode.
Click Test Connection to verify that the data source can be connected.
After the data source passes the connectivity test, click OK.
Access ApsaraDB for OceanBase over a VPC
Add the CIDR blocks of Quick BI to the IP address whitelist of ApsaraDB for OceanBase.
Before you access the ApsaraDB for OceanBase database over a VPC, you must add the CIDR block
100.104.0.0/16of Quick BI to the IP address whitelist of ApsaraDB for OceanBase. For more information about how to add CIDR blocks to the IP address whitelist of ApsaraDB for OceanBase, see Configure an IP address whitelist.Add an ApsaraDB for OceanBase data source and verify that the data source can be connected.
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add an ApsaraDB for OceanBase data source.
In the Add OceanBase Data Source dialog box, configure the parameters.
Parameter
Description
Name
The name of the data source. The name is displayed in the data source list. You can specify a custom name.
The name can contain letters, digits, underscores (_), and hyphens (-).
Database Address and Port Number
The internal endpoint and port number of the ApsaraDB for OceanBase database.
Database
The name of the database that is customized when you deploy the database.
Username and Password
The username and password that are used to access the ApsaraDB for OceanBase database.
Mode
The tenant mode that is used when you deploy the ApsaraDB for OceanBase database. Valid values: MySQL Mode and Oracle Mode.
If the tenant mode of the database is MySQL, set Mode to MySQL Mode.
If the tenant mode of the database is Oracle, set Mode to Oracle Mode.
VPC Data Source
If you want to access ApsaraDB for OceanBase over a VPC, you must select VPC Data Source and configure the following parameters:
AccessKey ID and AccessKey Secret: the AccessKey ID and AccessKey secret that are used to access the ApsaraDB for OceanBase cluster.
Instance ID and Region: the ID of the ApsaraDB for OceanBase cluster and the region in which the cluster is deployed.
Click Test Connection to verify that the data source can be connected.
After the data source passes the connectivity test, click OK.