Connect to OceanBase Cloud in Tableau

This topic will demonstrate how to import data from OceanBase Cloud into Tableau Desktop, using an example of OceanBase Cloud MySQL-compatible tenant.

Prerequisites

• You have downloaded and installed Tableau Desktop.
• You have registered an OceanBase Cloud account, and have created an instance and a MySQL-compatible tenant. For details, refer to Create an instance and Create a tenant.

Procedure

Step 1: Obtain an OceanBase Cloud connection string

1. Log in to the OceanBase Cloud console. On the Instances page, expand the target instance and click Create under the target tenant.

   

2. In the pop-up window, click Connect with Public IP.

3. In the Connect with Public IP window, complete the following settings to generate the connection string:

   1. Under 1. Add an IP address to the allowlist, click Add to add your exit IP address(es) used for the connection to the allowlist.

   2. (Optional) Under 2. Download the CA certificate to connect securely to the tenant, download the CA certificate and complete the verification.

   3. Under 3. Connect to your instance, click the drop-down list for Database and Account to create a database and an account for the connection. Select MySQL CLI as the connection method.

      Notice

      Please keep your password in a secure place after creating your account.

      

Step 2: Connect to OceanBase Cloud in Tableau Desktop

1. Open Tableau Desktop. In the Connect pane on the left, under To a Server, select More > MySQL.

2. In the MySQL dialog, configure as follows based on the connection string obtained in Step 1: Obtain an OceanBase Cloud connection string:

   Field	Description
   Server	Taken from the -h parameter in the connection string, which is the hostname of OceanBase Cloud database, for example, t5******.aws-ap-southeast-1.oceanbase.cloud.
   Port	Taken from the -P parameter in the connection string, which is the OceanBase Cloud database connection port.
   Database	Taken from the -D parameter in the connection string, which is the name of the database to be accessed.
   Username	Taken from the -u parameter in the connection string, which is the account name, for example: test.
   Password	Taken from the -p parameter in the connection string, which is the account password.

   

3. Click Sign In. If you see the interface as shown below, it means you have successfully connected to OceanBase Cloud.

   

   Note

   If you are choosing MySQL for database connection for the first time, Tableau Desktop will prompt you to install the MySQL driver before connecting. You can follow the prompts to install the MySQL driver required for connection. For specific installation steps, refer to the MySQL Driver Download page.

What's next

Once the connection is established, you can start using Tableau Desktop. For detailed operational guidance on Tableau, refer to the Tableau Desktop Official User Guide.