Create multi-user workspaces

Create multi-user workspaces for environments where several people need access to the same data.

In this case, Tricentis Tosca centrally manages projects in one common repository database. A checkin / checkout mechanism ensures that users don't interfere with each others work.

Choose a repository type

You can create multi-user workspaces for the following repository types:

  • Oracle

  • MS SQL Server (including Microsoft Azure SQL)

  • DB2

  • SQLite

For information on supported versions, see the system requirements.

Advantages and disadvantages of SQLite

  • Creating them on a network drive is easy and fast.

  • You don't need to configure any additional settings or perform administrative tasks.

  • Only one user or process at a time can alter the SQLite Repository. Parallel checkins or updates might cause damage and loss of data.

  • Administration of multiple users is slow.

  • An increase in data volume leads to a significant decline in performance.

  • Resources are only available to a certain extent, compared to database servers.

Advantages and disadvantages of other databases

  • They allow for large user groups.

  • They provide stable performance even if data volume increases.

  • From a hardware point of view, database servers allow for additional resources that are also improved.

  • A system admin has to set up and configure them.

  • You must pay attention to access rights, ports, and firewalls.

Tricentis recommends that you use a repository with a database server in production environments.

You can use SQLite common repositories for training or demo purposes. SQLite common repositories aren't supported in multi-user production environments.

Create a multi-user workspace

Create a multi-user workspace for SQLite repositories

For information on how to create SQLite workspaces, see chapter "Create SQLite workspaces".

Create a multi-user workspace for Oracle, MS SQL Server, or DB2 repositories

To create a workspace for a database repository, follow the steps below:

  1. Prepare your database for a multi-user environment.

  2. Create the workspace.

Work in a multi-user environment

Chapter "Get to know your workspace" contains all user-relevant information on workspaces.

For information on actions that are specific to multi-user workspaces, for instance how to revoke checkouts, see chapter "Checkin and checkout objects".