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 these steps:

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

  2. Create the workspace.

Create a Tricentis Server Repository workspace

With Tricentis Server Repository workspaces, you can easily connect to a project, without having to remember connection strings.

Please note that you can't mix and match workspaces. If you want to use Tricentis Server Repository workspaces, you also have to use them for "non-tester workspaces", such as the AOS workspace for Tosca Distributed Execution with AOS or the qTest workspace for the qTest integration infrastructure.

To create a Tricentis Server Repository workspace, follow these steps:

  1. Prepare the environment. You only have to do this once.

  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".