Skip to content

FineBI

This page explains how to connect FineBI to Aloudata CAN and create a dataset.

Procedure

Create a Data Connection

On the FineBI home page, choose Management System > Data Connection > Data Connection Management. Click Create Data Connection, and then select StarRocks under All, as shown below.

Tip

If the metric platform data source is Doris, you can select MySQL or Doris as the account platform.
If the metric platform data source is StarRocks, you can select MySQL or StarRocks as the account platform.

image.png

Configure the Data Connection

Follow the prompts to enter the database address, username, password, database name, port, and other information, as shown below:

image.png

Obtain the configuration information in Aloudata CAN: choose Metric Applications in the top navigation bar, select Metric Views on the left, and click "BI Tool Integration Guide" in the lower-left corner of the metric views page. The guide provides the address, port, account, catalog, and schema, as shown below:

image.png

Note

Use **schema** as the database name. Make sure the connection URL uses the format **address:port/catalog.schema**.

The password is the password of the current Aloudata CAN login account.

Click Test Connection in the upper-right corner of the page. If the system prompts that the connection is successful, FineBI can connect normally. Click Save in the upper-right corner to finish configuring the data connection.

image.png

Create a Dataset

  1. Go to Public Data, select a folder for which you have administrator permission, and click Create Dataset, as shown below:

image.png

  1. You can load data from StarRocks by using database tables, SQL datasets, and other methods. This example uses a database table to obtain table information. Click Database Table to open the database table selection page, select the created data connection, and view all data tables in the corresponding schema on the right, as shown below:

Note

The tables obtained from the table catalog correspond one-to-one with the names in the metric view list.

Only views that the current account has permission to use in Aloudata CAN are displayed. In the example below, the account has usage permission only for the views named "quickbi" and "guanyuantest", so the table catalog lists only "quickbi" and "guanyuantest". If the account has permission for all metric views, all metric views are displayed. To add more metric views to FineBI, obtain user or administrator permission.

image.png

image.png

  1. Select the data table to load and click OK in the upper-right corner. FineBI loads the selected data table, and added tables are grayed out and cannot be selected, as shown below:

image.png

  1. A direct-connection table can be used immediately after it is added, as shown below:

After the dataset is created, the original field names correspond one-to-one with the field names in the metric view. However, the field names must be renamed in FineBI, as shown below.

image.png

image.png

The FineBI connection to Aloudata CAN and dataset creation are now complete. You can use the data table for data visualization. For more guidance, see the FineBI official documentation.