Online Help > Data Sources

Repositories

Description

 

Repositories allow to divide a database in multiple, smaller compartments. Instead of handling the whole database as a single block of data, each repository handles its own subset of entries. As a result, repositories allow to manage a massive amount of entries, without experiencing reduced performance. All repositories common to a database have the same set of users, security groups and roles. Only entries differ from one repository to another.

 

If you have more than 3500 entries stored in your data source and start experiencing performance issues, we strongly recommend to use repositories to split your entries.

Repositories are available with: Devolutions Password Server, MariaDB, MySQL, and SQL Server data sources.

 

Create a Repository

1.Select the desired data source (Advanced data source only) which to create the repositories in and navigate to Administration – Repositories. Only administrators can manage repositories, unless the permission to manage repositories has been granted to a user.

 

Administration – Repositories

Administration – Repositories

 

2.Click on Add Repository. In the list below, Default is the main repository. This is where all users, security groups and roles are defined.

 

Repositories – Add Repository

Repositories – Add Repository

 

3.Enter a name for the new repository. The description is optional. Offline mode is enabled by default. Uncheck the option if you want to restrict access to the repository when users do not have a connection to the data source.

 

Repository Management

Repository Management

 

The repository is now created and is part of the database.

 

Connect to a repository

1.Create a new data source that connects to the database which the repository has been created in.

 

2.From the navigation pane, select the desired repository.

 

Navigation pane – Repository selector

Navigation pane – Repository selector