Connecting Common Repositories

Select your preferred repository type in the Common Repository section.

Selecting a single user workspace

  1. Select the required repository type.

    The option None (creates single user workspace) is available forsingle-user workspaces. Please note that this repository type is intended for only one workstation (computer).

    The following repository types are available for multiuser environments (see also see chapter "Multiuser mode"):

    For further information on supported versions, please see also the System requirements.

Tricentis recommends using a database with a database server in productive test environments.

SQLite common repositories are not supported in productive multiuser environments.

You can use SQLite common repositories for training or demo purposes.

  1. Specify if you would like to create either a workspace for an existing common repository, or a new common repository with a new workspace.

Connecting an existing Common Repository

Tosca allows you to create a new workspace for an existing common repository, which is intended to be used by one specific user on one workstation (computer).

  1. Enable the checkbox next to the option Use existing Repository

  2. Select the existing repository

  3. If you would like to create a workspace for an existing branch follow the steps in chapter "Create a workspace for an existing branch". Any workspace not assigned to a branch points to the master branch.

The next configuration steps depend on the various repository types. Please see also the following chapters: , MS SQL Server, Oracle, DB2 and SQLite.

Creating a new Common Repository

A new common repository is created to be able to centrally store data and to manage multiple workspaces. A new workspace is additionally created which is connected to this new common repository.

The next configuration steps depend on the respective repository types. (Please see also the following chapters:, MS SQL Server, Oracle, DB2 and SQLite.)

Creating the Repository type SQLite

The following parameters have to be specified for the repository type SQLite:

  • Create new Common Repository in:

    User-defined directory for the new common repository. If this is intended to be used as a common repository for multiuser operations, the directory should be selected in a network resource accessible to other users. Note that only one user or process can alter the SQLite Repository at a time.

  • Select name for new Repository:

    The new name for an SQLite repository is defined by the user.

Repository type SQLite

Creating the Repository type MS SQL Server

The repository type MS SQL Server creates a common repository for SQL server or Microsoft Azure SQL, the cloud-based solution of the SQL server.

For further details on common repositories of this type, please see also chapter "Preparing an MS SQL Server for common repositories".

Define the following parameters:

  • Schema

    Specify a schema name if tables were created with a user-defined schema.

  • Connection String

    Specification of connection parameters. Pressing the ? button right next to the edit box inserts predefined connection parameters.

    Server: network ID or IP address of the MS SQL Server

    Database: database name

    Uid: user ID for database access

    Pwd: password of the user ID

The connection string of an existing workspace can be copied encrypted or unencrypted. The string is located in the menu of the existing workspace at Project->Info (see setting "Info").

  • The connection to the database can be checked by clicking on Test connection.

Repository type MS SQL Server

Creating the Repository type DB2

For further details on common repositories of this type, please see also chapter "Preparing DB2 for common repositories".

Define the following parameters:

  • Schema:

    Specify a schema name if tables were created with a user-defined schema.

  • Connection String

    Specification of connection parameters. Pressing the ? button right next to the edit box inserts predefined connection parameters.

    Server: the IP address or network name of the DB2 server

    Database: the name of the database instance

    Uid: user ID for database access

    Pwd: password of the user ID

The connection string of an existing workspace can be copied encrypted or unencrypted. The string is located in the menu of the existing workspace at Project->Info (see setting "Info").

  • The button Test connection can be used to verify the connection to the database.

Repository type DB2

Creating the Repository type Oracle

For further details on common repositories of this type, please see also chapter "Preparing Oracle for common repositories".

Define the following parameters:

  • Schema

    Specify a schema name if tables were created with a user-defined schema.

  • Connection String

    Specification of connection parameters. Pressing the ? button right next to the edit box inserts predefined connection parameters.

    Data source: path to the Oracle Host

    User Id: user ID for database access

    Password: password of the user ID

The connection string of an existing workspace can be copied encrypted or unencrypted. The string is located in the menu of the existing workspace at Project->Info (see setting "Info").

  • The connection to the database can be checked by clicking on Test connection.

Repository type Oracle