Skip to content

Database Settings

Database Settings configures the storage backends used by Emakin. The preserved documentation describes three storage categories: relational SQL databases, file repositories, and XML repositories.

Use this page during installation and when you need to change how Emakin stores operational, archive, file, or XML data.

System Connection

The system connection stores the application’s system tables.

Use Test Connection to verify connectivity before startup.

Replicate Fulltext Database

The documentation notes that full-text content is stored in the local file system of the agent machine and can also be replicated into SQL storage for synchronization with other agents.

It also notes that in large deployments this synchronization may reduce performance, and recommends using a central file system location with replication disabled when the full-text database becomes very large.

Archive Connection

The archive connection is used for archived records. Older data can be moved into this storage when a larger but slower archive area is preferred.

Repository Connections

At least one repository connection is required for normal application behavior. Repository databases store domain tables, and multiple repositories can be created.

The preserved documentation states that tenant-related data is sharded across repositories.

Use Test Connection to verify connectivity.

Repository connection settings

File Repositories

File repositories store uploaded files outside SQL storage.

Use them when file size growth would otherwise affect SQL performance.

The preserved documentation states:

  • file repositories are optional
  • multiple file repositories can be configured
  • local network storage and S3-compatible repositories are supported
  • when a new file repository is added, existing SQL-stored files are moved to it
  • files are replicated across all configured file repositories

The Get Status button shows replication status.

File repository settings

XML Repository Connection

XML repositories store domain and process-related XML data.

XML repository connection settings