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
Background information
If you are using an ApsaraDB for OceanBase database, you can add an ApsaraDB for OceanBase data source when you connect to the Quick BI for data analysis. For more information about ApsaraDB for OceanBase, see ApsaraDB OceanBase.
Limits
Only workspace administrators and developers can add data sources.
Procedure
Add the CIDR blocks of Quick BI to the IP address whitelist of ApsaraDB for OceanBase.
Before connecting to the ApsaraDB for OceanBase database over the Internet, you must add the Quick BI IP address to the whitelist of the ApsaraDB for OceanBase database. For more information about how to add a whitelist for ApsaraDB for OceanBase, see Whitelist.
After you 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.
Go to the Create Data Source page.
Click Show More.
Select Alibaba OceanBase.
In the Add OceanBase Data Source dialog box, configure the parameters.
Item
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 and Port Number
The public endpoint where the ApsaraDB for OceanBase database is deployed. If you use a VPC data source, you must enter the internal endpoint and port of the database. Log on to the ApsaraDB for OceanBase console. On the Connection Information tab of the Tenant Details page, obtain the database endpoint. Example: xxxxxxxxxxxxxxx.oceanbase.aliyuncs.com.
Database
The name of the database that is customized when you deploy the database.
Log on to the ApsaraDB for OceanBase console. On the Databases tab of the tenant details page, obtain the name of the database.
Username and Password
The username and password that are used access the ApsaraDB for OceanBase database.
Schema
The tenant mode that is used when you deploy the ApsaraDB for OceanBase database. Valid values: MySQL Mode and Oracle Mode.
Log on to the ApsaraDB for OceanBase console and view the Tenant Mode on the Tenant Details page.
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 use a VPC, select VPC Data Source and configure the following parameters:
AccessKey ID and AccessKey: the AccessKey ID and AccessKey secret that are used to access the ApsaraDB for OceanBase cluster.
Log on to the RAM console and obtain the AccessKey ID and AccessKey secret.
Instance ID and Region: the ID and region of the ApsaraDB for OceanBase cluster.
Log on to the ApsaraDB for OceanBase console. On the Clusters page, obtain the cluster ID and zone.
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 tables in the ApsaraDB for OceanBase database or user-created SQL statements 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.