Data Connection to TiDB

Version

Application Scenario

This document introduces how to connect to the TiDB database in FineBI.

Version/Driver

Connection Information Collection

Before connecting the database, you need to collect the following information:

• IP address and port number of the server where the database is located

• Database name

• Username and password of the database

1. Log in to FineBI, choose System Management > Data Connection, and click New Data Connection, as shown in the following figure.

2. Select All, and find the TiDB icon, as shown in the following figure.

3. Enter the data connection configuration page, and enter the relevant information for the connection in section "Connection Information Collection", as shown in the following figure.

Note:

You can optionally modify other advanced settings. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets