Database Settings¶

Emakin utilizes three types of databases for storing data: relational SQL databases, file systems, and NoSQL XML databases. Each serves a distinct purpose and requires configuration in this section before application startup.

Details¶

System Connection¶

The system database must be configured with the necessary properties to enable the creation of the application's system tables.

Use the "Test Connection" button to verify the database connection. For more information, refer to the Relational Database documentation.

Replicate Fulltext Database¶

The content of the full-text database is stored in the local file system of the Agent machine. When database content is modified, it is replicated into SQL storage for synchronization with other Agent instances.

In large deployments, the full-text database content may become substantial. For large databases, this synchronization may degrade system performance. To enhance performance, the full-text database should be stored in a central file system location, and this replication feature should be disabled.

Archive Connection¶

The archive database connection is used to access archived records. After a specified period, older records may be moved to an archive database that offers a larger, but slower storage area.

Repository Connections¶

At least one repository database must be configured with the necessary properties for the application to function. This database stores domain tables. Multiple repositories can be created.

Tenant-related databases are sharded across these repositories for efficient data storage.

Use the "Test Connection" button to verify database connectivity.

File Repositories¶

File repositories are used to store files on the file system, rather than in the SQL database. This is useful because the total size of uploaded files can impact SQL performance. The use of file repositories is optional, and multiple file repositories may be configured. For more information, see the File Database documentation.

Local network storage and S3-compatible file repositories are supported.

When a new file repository is added, all files stored in the database are moved to the new repository. Additionally, all files are replicated across all available file repositories.

The replication status can be viewed using the "Get Status" button.

XML Repository Connection¶

XML repositories are used to store domain and process-related data in XML format. For more information, refer to the XML Database documentation.