Due to some features of the SQL Server database, the performance may be slow. You are advised to use other types of databases as external databases.
6.0
/
If an external database is configured for the BI system, the BI system will become more stable in cluster environments or situations with large amounts of data.
You can configure external databases during initialization or SQL Server databases on the platform.
If the external database is configured, do not modify the username and password of the external database. Otherwise, project startup will fail.
If you need to modify them, see Modifying the Account and Password of the External Database.
The following table describes the types and versions supported by the external database.
SQL Server
2000/2005/2008/2012/2014/2016/2017
Memory
2 GB
4 GB
CPU
4 cores
8 cores
Internet speed
50 Mbps
100 Mbps
FineDB-occupied space
1 GB
Server disk space
100 GB
200 GB
Disk read/write speed
50 MB/s
100 MB/s
1. You are advised to use the memory with the same size of the memory reserved for the project configuration library.
2. You need to modify the occupied space according to the usage rate. You can configure the space to be one to two times larger than the size of the finedb folder in webapps/webroot/WEB-INF/embed (estimated size based on the actual size).
3. The external database should be in the same network segment as the BI project to avoid network fluctuations.
Create a database to store platform-related data.
The standard database creation statement is CREATE DATABASE finedb COLLATE Latin1_General_CI_AS.
You can set the sort rule of the SQL Server database to Latin1_General_CS_AS (case-sensitive) or Latin1_General_CI_AS (case-insensitive). You are advised to use Latin1_General_CS_AS (case-sensitive).
Select Latin1_General_CS_AS to migrate all the data intactly.
Select Latin1_General_CI_AS. If a message, such as one indicating that the fine_conf_entity table violates the PRIMARY KEY limit, is displayed during migration, generally the project has dirty data.
You can execute the following SQL statement to view dirty data:
select lower(ID),COUNT(1) FROM FINE_CONF_ENTITY GROUP BY LOWER(ID) HAVING COUNT(1) >1
The three external database configuration entries are as follows:
(1) You can configure an external database for the BI system upon login as the super administrator for the first time.
(2) For systems that use built-in databases, you can log in to the BI system as the admin, choose System Management > System Setting > General > External Database > To Be Configured, and configure the external database for the system for the first time.
(3) For systems for which external databases have been enabled, you can log in to the BI system as the admin, choose System Management > System Setting > General > External Database > Configured, and migrate data to a new external database for the system.
After entering the external database configuration page, select the database type and enter the corresponding information of the actual database.
The following table describes each setting item.
Database Type
Select SQL Server.
Driver
This parameter will be automatically set, requiring no modification.
Database Name
For details, see the database name in section "Database Creation."
Your project must not share the database with other projects. You are advised to create a database.
The database name can contain only numbers, letters, underscores, and periods (.).
Username/Host/Password/Port
Set these parameters according to the actual information of the local database.
The host name can contain only numbers, letters, underscores, hyphes (-), and periods (.).
You need to have the create, delete, alter, update, select, insert, and index permissions.
Mode
You can only select a mode from the drop-down list.
After correctly setting the above parameters, select Click to Connect Database from the drop-down list. The system will automatically connect to the database and read modes. You just need to select a node (better select the one corresponding to the database username).
You can determine whether to select Migrate Data to Database to Be Enabled based on your own needs. The following describes the details:
(1) Select Migrate Data to Database to Be Enabled when the new external database is empty.
After you click Enable New Database, the platform data of the original FineDB database will be migrated to the new external database.
(2) Select Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.
After you click Enable New Database, the message "The platform data already exists in the database. Before data import, the original platform data will be cleared. Sure to connect to the database?" pops up.
After you click OK, the original platform data will be cleared, and the platform data of the original FineDB database will be migrated to the new external database.
(3) Deselect Migrate Data to Database to Be Enabled when the new external database is empty.
After you click Enable New Database, the message "The target database is a new database and can be used after the current data is migrated to the target database." pops up.
After you click Migrate and Enable, the platform data of the original FineDB database will be migrated to the new external database.
(4) Deselect Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.
After you click Enable New Database, the BI project in 5.1.15 and later versions will automatically detect whether the JAR package version corresponding to the data in the target database is consistent with that in the current project.
If the versions are inconsistent, the message "Unable to enable it. Project version required to enable the new database: xxx Current project version: xxx Ensure that the project version is consistent." is displayed. In this case, you fail to configure external databases.
If the JAR package versions are consistent and the original FineDB database is a built-in database, the new external database is enabled directly.
If the JAR package versions are consistent and the original FineDB database is an external database, the configuration information of the original database is automatically backed up before migration (as result of which the db.properties.bak file is generated in webapps\webroot\WEB-INF\config), and the new external database is enabled directly.
Wait until the migration is successful. Different pop-up prompts may appear depending on the migration situation.
(1) New external database using data of the original FineDB database
The message "The target database has been enabled successfully." pops up. Click OK to complete the migration.
(2) New external database using data of the original FineDB database (which is a built-in database)
The message "Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use." pops up.
Click OK and restart the BI project to complete the migration.
(3) New external database using data of the original FineDB database (which is an external database)
The following two messages pop up:
Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use.
The original database configuration has been backed up to the config folder. You can use the backup file to restore the database configuration if necessary.
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, after configuring the external database, check whether a data connection exists for the built-in FineDB database in Data Connection.
If so, delete the data connection in time. Otherwise, the connection will continue to occupy server memory.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy