FineDB Database Introduction

Except for platform attribute configurations, all information in the decision-making platform, including directory tree settings and template scheduled task information, is stored in a single database called FineDB database.

You can use the built-in FineDB database or connect to an external FineDB database in FineReport.

FineReport contains a built-in HSQL database as the FineDB database.

Storage Location

The built-in database is saved in the %FR_Home%/webapps/webroot/WEB-INF/embed path.

Database File

Note:

Newly installed designers only contain 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 Connection in the Designer

Note:

The built-in FineDB database is an HSQL database that creates 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.

This document only introduces how to connect to the built-in FineDB database in the designer. For details about the platform connection method, see [Platform] HSQL Data Connection.

Choose Server > Define Data Connection and create a JDBC data connection.

 The following table lists specific connection information.

Settings	Value
Database	Select Others.
Driver	Enter com.fr.third.org.hsqldb.jdbcDriver.
URL	Enter jdbc:hsqldb:file://${ENV_HOME}/embed/finedb/db. Note: It is compatible with Windows/Linux/Mac.
User Name	Enter sa.
Password	Keep empty.

Create a database query, select FineDB data connection from the dropdown menu on the left, and drag data tables from the list box (listing all data tables in FineDB) on the left to the SQL statement box on the right for usage.

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 data volumes, HSQL database may become unstable. Therefore, you are advised to configure an external database in formal enterprise projects.

For details about the type and usage of supported external databases, see External Database Configuration.

If you need to access and analyze data from an external database, choose the appropriate data connection method based on the database type.

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.

1. Table Structure Introduction

For details about FineDB database table content, see FineDB Table Structure.

2. Table Field Modification

Some configuration items cannot be modified on the frontend and can only be modified by adjusting table fields in FineDB database.

Fields stored in the fine_conf_entity table in FineDB database can be modified through the following methods.

• Method one: Modify fields through the plugin. For details, see FINE_CONF_ENTITY Visual Configuration.

• Method two: Modify fields through filling.

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