Add an User-Created TiDB Data Source

Limits

Version 7.1.3 is supported.

Procedure

1. Add Quick BI's IP address to the whitelist of your TiDB data source.

   Before connecting, ensure that Quick BI's IP address is added to the whitelist of your self-managed TiDB data source.

2. Log on to the Quick BI console.

3. Access the data source creation interface via the data source creation entry.

4. Select the TiDB data source from the list.

5. In the Configure Connection dialog box, based on your business scenario, you can configure the following settings.

   Name	Description

   Name	Description
   Display Name	The name displayed in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address	The address where the TiDB database is deployed, including IP or domain name.
   Port	The port number corresponding to the database.
   Database	The custom database name when deploying the TiDB database.
   Username and Password	The username and password for logging on to the TiDB database. Ensure that the username has create, insert, update, and delete permissions on tables in the database.
   Initialization SQL	After enabling, you can configure the SQL statement to be executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement executed after each data source connection initialization. Separate statements with periods.

6. Click the Connection Test button to verify the data source connectivity.

   

7. Once the test succeeds, click OK to finalize the addition of the data source.

What to Do next

After the data source is established, you can proceed to create datasets and analyze data.

• For instructions on adding data tables from the TiDB database or creating custom SQL in Quick BI, refer to Create and Manage Datasets.

• To add visualization charts and perform data analysis, refer to Create a Dashboard and Overview of Visualization Charts.

• For detailed data analysis and drilling options, refer to Drilling Settings and Display.