FineDB Database Introduction

The FineDB database stores all the platform configuration information of FineDataLink projects, including pipeline tasks, scheduled tasks, permission control, and system management.

Note:

The configuration information of platform attributes is not stored in the FineDB database.

You can use the built-in FineDB database or connect to an external database to be used as the FineDB database in FineDataLink.

FineDataLink contains a built-in HSQL database used as the FineDB database.

Storage Location

The FineDB database is stored at %BI_Home%\webapps\webroot\WEB-INF\embed, as shown in the following figure.

Database Table Content

The FineDB database stores platform configuration information of FineDataLink projects, including pipeline tasks and scheduled tasks.

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

Database File

Note: 

Newly installed FineDataLink only contains the mandatory files, including db.properties and db.script. 

But if the database is in use and certain table and data properties are modified, the optional files will be generated automatically.

Connecting to the FineDB Database

Note: 

The built-in FineDB database is an HSQL database and runs in memory. It can consume a large amount of memory when processing large volumes of data.

Therefore, do not create a data connection to the built-in FineDB database in the FineDataLink project unless necessary.

You can connect to the built-in FineDB database in the FineDataLink data platform.

1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, select a folder, click , and create a data connection, as shown in the following figure.

2. Set the name of the data connection and, if needed, modify its directory, as shown in the following figure.

3. You can search for the database by connection name or filter it by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure.

4. Fill in the information, click Click to Connect Database on the right of Schema, and select PUBLIC from the Schema drop-down list, as shown in the following figure.

Parameter	Value
Driver	com.fr.third.org.hsqldb.jdbcDriver (by default)
URL	jdbc:hsqldb:file://${ENV_HOME}/embed/finedb/db. Note:  The URL is compatible with Windows/Linux.
Username	sa
Password	No input required
Schema	PUBLIC

5. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Note: 

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

The HSQL database does not support multithreaded access. It may become unstable in a clustered environment or when handling large volumes of data. 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.

Note: 

1. To analyze data from an external database, you need to select an appropriate data connection method based on the database type.

2. After establishing a FineDB data connection, it is necessary to configure the permission of the data connection, 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 editing table fields in the FineDB database.

Some fields in the FineDB database can be modified using plugins. For details, see Modification of Common Table Fields in the FineDB Database.

Note: 

Do not directly modify FineDB database files or access/modify the FineDB database via third-party software.