Introduction to FineDB

All information in the Decision-making System except the platform attribute configuration, including directory tree settings, template timing task information, etc., are stored in the FineDB database.

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

The FineBI project has a built-in HSQL database as the FineDB database.

1. Storage location

The FineDB database is stored in the % BI_Home %\webapps\ webroot \WEB-INF\embed folder. As shown below:

2. Contents of database tables

The FineDB database stores all the information in the data decision system except the platform attribute configuration, including the directory tree settings, template timing task information, etc.

FineDB database table, please refer to: FineDB Table Structure.

3. Database files

Note: For a freshly installed FineBI , there are only necessary files such as db.properties and db.script .

If the database is used, and some properties of the tables and data are modified, other files are automatically generated.

4. FineDB data connection

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

1) The administrator enters the Decision-making System and clicks "Manage > Data Connection >Data Connection Management > New Data Connection", as shown in the following figure:

2) Click "Others", select "Other JDBC", and fill in the database connection information, as shown in the following figure:

The specific connection information is shown in the following table:

3 ) Click "Test Connection" to prompt the connection is successful, as shown in the following figure:

4) Click the "Save" button in the upper right corner.

Note: After adding a FineDB data connection to the server, be sure to control the permissions of the data connection ,otherwise there is a risk of unauthorized access and modification of the configuration database.

The HSQL database cannot be accessed by multiple threads, and the cluster environment and the large amount of data may lead to the instability of the HSQL database. Therefore, in the formal project of the enterprise, it is recommended to configure an external database.

For the supported types and usage of external databases, please refer to: Configure External Database

Note 1: If you need to call the data in the external database for analysis, please select the appropriate data connection method according to the database type.

Note 2: After adding a FineDB data connection to the server, be sure to control the permissions of the data connection , otherwise there is a risk of unauthorized access and modification of the configuration database.

1) Introduction to table structure

FineDB database table, please refer to: FineDB Table Structure

2) Table field modification

Some configuration items have no foreground modification settings, and you need to modify the FineDB database table fields to adjust the configuration.

FineDB database can be modified through plug-ins. For details, please refer to: FineDB Common Table Field Modification

It is forbidden to directly modify the FineDB database file, and it is forbidden to connect/modify the FineDB database through third-party software.