Introduction to FineDB

Except for platform attribute configurations, all information in the FineBI system, including directory tree settings, scheduled task information, etc., is stored in FineDB database. 

FineBI supports using the built-in FineDB database or connecting to an external FineDB database.

FineBI has a built-in HSQL database as FineDB database.

Storage Location

FineDB database is stored at % BI_Home %\webapps\ webroot \WEB-INF\embed, as shown below:

Database Table Content

FineDB database stores all information in FineBI system except for platform attribute configurations, including directory tree settings, scheduled task information, etc. 

For details, see FineDB Table Structure.

Database File

Note:

1. Newly installed FineBI only has required files such as db.properties and db.script. But if the database is used and some properties of the table and data are modified, other files will be generated automatically.

2. Newly installed FineBI only has required files such as db.properties and db.script. But if the database is used and some properties of the table and data are modified, other files will be generated automatically.

FineDB Data Connection

Note:

Built-in FineDB database is an HSQL database that will create an in-memory database when used, which will occupy a large amount of memory when the data volume is large. Therefore, do not create a Built-in FineDB Database data connection in FineBI project unless necessary.

Users can connect to the built-in FineDB database in the BI platform.

1) Admin logs into FineBI, clicks Manage > Data Connection > Data Connection Management > New Data Connection, as shown below:

2) Click Other, select Other JDBC, as shown in the figure below:

3) Fill in the information, and click Click to connect database on the right of Pattern, and select PUBLIC, as shown in the figure below:

4) Click Test Connection. It will prompt Connection Successful, as shown below:

5) Click Save in the upper right corner.

Note:

After establishing a FineDB data connection, it is necessary to control data connection permissions, otherwise the database might be accessed and modified by unauthorized personnel.

HSQL database cannot be accessed by multiple threads. In a clustered environment with large amounts of data, HSQL database may become unstable.  Therefore, it is recommended to configure an external database in formal enterprise projects.

For the types of supported external databases and usage, see Configure External Database.

Note:

1. If you want to use data from an external database for analysis, select an appropriate data connection method according to the database type.

2. After establishing a FineDB data connection, it is necessary to control data connection permissions, otherwise the database might be accessed and modified by unauthorized personnel.

Table Structure Introduction

For details, see FineDB Table Structure.

Table Field Modification

Some configuration items cannot be modified in the platform and can only be modified by adjusting table field in the FineDB databases.

Some fields in the FineDB database can be modified by plugins.

It is prohibited to modify the FineDb data file directly and to connect/modify FineDB database through third-party software.