Configuring External Databases

Application Scenario

The built-in database for the BI is the HSQLDB database.

HSQLDB database does not support multi-threaded access. In a cluster environment with large amounts of data, the database may become unstable. HSQLDB database is suitable for the local trial of product functionality.

The external database is suitable for the formal use of the platform.

Migration is based on existing old data, and unpredictable problems are held in the migration process of old data. Therefore, you can choose to migrate the old data or directly enable a new database.

Function Description

If an external database is configured for the BI system, the BI system can remain stable in cluster environments or situations with large amounts of data.

You can configure external databases during initialization or on the platform. The two configuration methods require the same configuration via the same procedures.

The following table describes the supported types and versions of the external databases.

Note: MySQL and Oracle databases are recommended as the external databases.