Add a self-hosted TiDB data source

Limitations

TiDB version 7.1.3 is supported.

Procedure

1. Add IP addresses to the allowlist.

   Add the Quick BI IP addresses to the allowlist of your TiDB database.

2. Log on to the Quick BI console.

3. Navigate to the data source creation page from a data source creation entry point.

4. On the Self-hosted Data Sources tab, select the TiDB data source.

5. In the Configure Connection dialog box, configure the parameters.

   Parameter	Description
   display name	The display name shown in the data source list. The name cannot contain special characters or leading or trailing spaces.
   database address	The IP address or domain name of the TiDB database.
   port	The port number of the database.
   database	The name of the database specified when you deployed TiDB.
   username and password	The username and password used to log on to the TiDB database. The user must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
   initialization SQL	SQL statements that run automatically after a connection is established. Only SET statements are allowed. Separate multiple statements with a semicolon (;).

6. Click Test Connection to verify the connection.

   

7. After the test succeeds, click OK to add the data source.

Next steps

After the data source is created, you can create datasets and analyze your data.

• To add data tables or custom SQL queries from your TiDB database to Quick BI, see Create a dataset.

• To add visualizations and analyze data, see Create a dashboard and Visualization overview.

• To drill down and perform in-depth analysis, see Step 3: Configure and display drill-down settings.