Add an OceanBase data source

Connect Quick BI to your Alibaba Cloud OceanBase database over the public network or through a VPC to analyze and visualize data.

Prerequisites

A cluster and tenant are created. Create a cluster and Create a tenant.

Overview

Add your Alibaba Cloud OceanBase Database as a data source in Quick BI to analyze and visualize its data.

Quick BI connects to OceanBase over the public network or through a VPC. The configuration varies by connection type. Network connectivity overview

Add the Quick BI IP CIDR blocks to your OceanBase Whitelist Groups to prevent connection failures.

Limits

Only workspace administrators and developers can add data sources.
Only OceanBase Database versions 4.2.1.3 and 4.3 are supported.

Procedure

Add IP addresses to the whitelist.

For public network connections, add the Quick BI IP addresses to your OceanBase Whitelist Groups.
Log on to the Quick BI console.
1. Go to the Add Data Source page. Create a data source.
2. On the Alibaba Cloud Databases tab, select the OceanBase data source.

In the Configure Connection dialog box, set the following parameters.

Parameter	Description
Display name	The display name in the data source list. No special characters or leading/trailing spaces allowed.
Mode	The tenant mode of your OceanBase database: MySQL Mode or Oracle Mode. In the OceanBase Management Console, find Tenant Mode on the tenant details page. If Tenant Mode is MySQL Tenant, select MySQL Mode. If Tenant Mode is Oracle Tenant, select Oracle Mode.
Database address and port	The public address and port of your OceanBase database. For VPC connections, use the internal address and port. In the OceanBase Management Console, go to the tenant details page and find the Database Address and port on the Connection Information tab. Obtain connection parameters.
Database	The name of the database in your OceanBase tenant. In the OceanBase Management Console, find the Database Name on the Database tab of the tenant details page.
Username and password	The username and password for your OceanBase database.
VPC data source	To connect through a VPC, select VPC data source and configure these parameters: AccessKey ID and AccessKey Secret: The AccessKey pair of an account with access to the target OceanBase cluster. Obtain your AccessKey pair from the RAM console. Note MySQL Mode: The account needs Read permissions for the target instance. With List and Write permissions, Quick BI auto-adds its IPs to the whitelist. Otherwise, add them manually. Oracle Mode: The account needs Read permissions for the target instance. With Write permissions, Quick BI auto-adds its IPs to the whitelist. Otherwise, add them manually. Instance ID and Region: The cluster ID and region. In the OceanBase Management Console, find the cluster ID and region on the cluster list page. Note For VPC data source, enter the internal address and port in the Database address and port fields.

Click Test Connection.
After the test succeeds, click OK.

Next steps

After the data source is added, create a dataset to start analyzing data.

Add tables or custom SQL queries from your OceanBase database. Create a dataset.
Build visualizations and analyze data. Create a dashboard and Overview of visualization charts.
Enable drill-down for in-depth analysis. Step 3: Configure and display drill-down data.