Data Connection to Doris

Version

Application Scenario

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

Version/Driver

URL format of the data connection: jdbc:mysql://IP address:Port number/Dbname

Note:

Multiple nodes exist in Doris. If you need to connect multiple nodes to one data connection, fill in the URL with the unified entry point of the nodes.

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

• Username and password of the database

• Database name

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 Doris icon, as shown in the following figure.

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

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