System Management > System Setting > Data Space Configuration

Note: File Synchronization and Datastore Space selection is supported by Z-Suite by default; an advanced module for X-Suite, which needs to be purchased separately. This feature is not supported in Y-Reporting, and Y-Vivid Show.

❖Global Files Configuration

The user can configure database connection information in the data space configuration and select the access space as required: database or file system, using the product in different storage locations. It supports MySQL, SQLServer, DB2, Oracle, Derby and PostgreSQL database at present.

Data space configuration interface is as follows:

dataspaceconfig

【Database & Driver】The default database is ORACLE. And the default driver is oracle.jdbc.driver.OracleDriver.

【URL】Database connection URL. The default protocol is jdbc:oracle:thin:@. It can be customized as well.

【Schema】The default database to use when connecting to the database.

【Server Login】Does it require authentication to login the database. When login with name and password are selected, the user and password input boxes will become enterable.

【User & Password】When login with name and password is required, input the user and password set for the database.

【Database Charset & Convert Charset】Non-required, users can adjust the database code according to the actual situation.

【Test Connection】Click the "test connection" button to test whether the database connection configuration information can be connected.

【Save Connection】Save the current database connection configuration information.

【Create Table】Create required tables in the default database.

【Delete Table】Delete the created tables in the default database. Click the "Delete Table" button to pop up a prompt box: The "Delete Table" operation will delete the table in the database. After the deletion, the original data cannot be restored. Do you continue to delete the table?Click "Yes" to continue the delete operation, click "No" to cancel the delete operation.

【File Synchronization】Select the direction of synchronization, "file system to database" or "database to file system".

【Synchronize & Cancel】Click Synchronize to split the contents of the permission file under bihome into the AUTHORIZATION_TABLE table of the database or synchronize the contents of the AUTHORIZATION_TABLE table back to the permission file, this process will be displayed as "Data is being prepared, please wait.". After the permission file is split, the other files under bihome will be synchronized accordingly, and the cancel option will appear, you can click it to cancel the current sync operation.

【Datastore Space Selection】Select whether the required data storage space is file system or database. The default system is file system. You need to restart tomcat after switching.

【File Path】Path of bihome.

❖Mart Audit Configuration

Here, the user can configure the database connection information to store the CPU, memory, disk network information, and JVM information of each node of each machine in the market. Currently supports MySQL, SQLServer, DB2, Oracle, and PostgreSQL databases.

console1