Doris Data Connection

Version

Application Scenario

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

Database Version and 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.

Preparation

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

• Database name

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

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

3. Enter 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