Database Settings

Emakin uses three types of databases to store data, those are relational SQL databases, file system and NoSQL XML databases. Each of them has different purposes and are needed to be configured from this section before starting your application.

Details

System Connection

System database must be configured with the required properties for application's system tables to be able to be created.

Use Test Connection button to test database connection. See Relational Database page for further information.

Open

Replicate Fulltext Database

Fulltext database content is stored in the Agent machine’s local file system and when database content is changed replicated into SQL storage to synchronize with other Agent instances.

In some large deployments, fulltext database content may reach large sizes. For large databases, this synchronization may reduce the system performance. To increase performance, the fulltext database must be stored in the central file system location and this feature must be disabled.

Archive Connection

Archive database connection to lookup for archived records. After some period old records can be moved to an archive database with a larger but slower storage area.

Repository Connections

For the application to run at least one repository database must be configured with the required properties. This database is used for hosting domain tables. You can create more than one repository.

Tenant-related databases are sharded under these repositories to efficiently store the data.

Use the “Test Connection” button to test the database connectivity.

Open

File Repositories

Because the total size of files uploaded into the system tends to be a burden on SQL performance, file repositories are useful for storing your files on the file system instead. This repository is optional. You can create more than one file repository. See the File Database page for further information.

You may add local network area storage or S3 compatible file repositories are supported.

Adding a new file repository moves all database stored files to given repository and replicates all files in available all file repositories.

You may also view the replication status with the “Get Status” button.

XML Repository Connection

XML repositories are used for storing domain and process-related data in XML format. See the XML Database page for further information.