Data Connection to Tbase

Version

Application Scenario

This document introduces how to connect to the TBase database.

Version and Driver

Download the driver package and upload it to FineBI. For details, see the "Creating a Data Connection" section in Driver Management.

Connection Information Collection

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

• IP address and port number of the database server

• Username and password of the database

• Schema of the database to be connected

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

2. Find the TDSQL icon, as shown in the following figure.

3. Select the driver uploaded in section "Version and Driver", enter the connection information collected in section "Connection Information Collection", and select the database schema, as shown in the following figure.

Note:

You can modify other advanced settings as needed. For details, see the "Advanced Setting" section 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