Manage repositories

With Tricentis Tosca Test Data Service you can manage new and existing repositories with an endpoint. You can manage your repositories in the following ways: 

To do this, you need to send a request message to the repositories endpoint with Tricentis Tosca API Scan.

All the following examples in this topic are using the v2 endpoints of Test Data Service.

Repositories endpoint

In API Scan, use the following endpoint to list the Tricentis Tosca Test Data Service repositories: http://<ip>:<port>/testdataservice/v2/repositories

The repositories endpoint contains the following elements:

  • IP address of the Tricentis Tosca Server

  • Port which you entered during the installation of Tricentis Tosca Test Data Service

Request properties

Once you have sent your request message, you receive a JSON file with the repository information as response. This file contains the following properties:

Property

Value

description

Describe the repository, e.g. Second_repository.

location

Path to the location where the SQlite database is saved, e.g. %PROGRAMDATA%\\Tricentis\\TestDataService\\new_databasefile.db.

name

Name of the repository. It is a unique identifier.

type

Repository type InMemory, Mssql, Oracle, or Sqlite.

schema

Database schema of the MSSQL database.

server

Name of the MSSQL or Oracle database server, e.g. for MSSQL: W10X64C\SQLEXPRESS.

This property is mandatory when you use MSSQL or Oracle.

database

Name of the MSSQL or Oracle database. In case of Oracle database, this indicates the system id value.

This property is mandatory when using MSSQL or Oracle

username

User name for accessing the MSSQL or Oracle database.

This property is optional. If you do not enter specific credentials, TDS uses Windows authentication to connect.

password

Password for accessing the MSSQL or Oracle database.

This property is optional. If you do not enter specific credentials, TDS uses Windows authentication to connect.

connectionString

A connection string to define the access information for your MSSQL or Oracle database.

This property is optional and only available when you use MSSQL or Oracle.

Repository types

You can select one of the following repository types:

  • InMemory: If you select InMemory, the data is stored temporarily in the computer's memory. Use the property name for unique identification.

    Don't use the InMemory provider for high load or production use. Microsoft designed it only for testing purposes .

  • Mssql: If you select Mssql, you need to define the connection parameters to the server, e.g. server, database, username, and password.

  • Oracle: If you select Oracle, you need to define the connection parameters to the server, e.g. server, database, username, and password.

  • SQlite: If you select SQlite, you need to define the path to the location where the .db file is saved.